I am using CF5 and oracle 7.3.4 and I am trying to create a query with an IN clause in it. I have done this many times using the same technique but now it is causing me great pain. Here is my code:
I get the following error:
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00907: missing right parenthesis
SQL = "select FirstName,LastName from trainer where userid in (''000F37C2-4888-1C6D-835B8309797D0000'',''000D7F31-3B55-1C6D-835B8309797D0000'')"
when I do an output on the selTrainerID right before I run the query, it only shows one singlequote around each value...but in the error it shows that there are two single quotes around each value. Any ideas??
Code:
<cfset session.Event.selTrainerID=ListQualify(session.Event.selTrainerID,"'")>
<cfoutput>#session.Event.selTrainerID#</cfoutput>
<CFQUERY NAME="qTrainer">
select FirstName,LastName
from trainer
where userid in (#session.Event.selTrainerID#)
</CFQUERY>
I get the following error:
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00907: missing right parenthesis
SQL = "select FirstName,LastName from trainer where userid in (''000F37C2-4888-1C6D-835B8309797D0000'',''000D7F31-3B55-1C6D-835B8309797D0000'')"
when I do an output on the selTrainerID right before I run the query, it only shows one singlequote around each value...but in the error it shows that there are two single quotes around each value. Any ideas??