hi
i have tried using the example specified but it is throwing an error, this is
the example i am trying to use:
<cfset subjectIDArray[1] = 1>
<cfset subjectIDArray[2] = 2>
<cfset subjectIDArray[3] = 3>
<cfquery name="getSubjects" datasource="myDB" username="myUsername"
password="myPassword">
SELECT subjectID, firstName, lastName from subjects where subjectID in
<cfqueryparam value="#arraytolist(subjectIDArray)#" list="yes"
cfsqltype="cf_sql_integer">;
</cfquery>
and the error i am getting is:
You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'in 1,2,3' at line 1
thanks again for your help
richard
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303977
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
