5 Replies Latest reply on Dec 20, 2007 6:14 AM by (James_Dee)

    JDBC Query Single Row service Parse Query

    Level 1
      Using JDBC Query Single Row service on an Oracle database,
      I specify a SQL statement like this:
      select abc, to_char(aDate, 'MM/DD/YYYY') from xyz where def = 123

      then I click the "Parse Query" button to try to map the query results to my variables, but the mapping window gives me 3 fields instead of 2:
      1. abc
      2. to_char(aDate)
      3. 'MM/DD/YYYY'

      how do I let it understand that there are only 2 fields in the results so that I can map it properly?