On 9/29/06, Ron Mast <[EMAIL PROTECTED]> wrote:
Hi All,
I have converted an array to a list and it looks like this:
<cfset allCusArray = arrayNew(1)>
<cfloop query="getAllCus">
<cfset allCusArray[currentRow] = "'"&trim(CDGDID)&"'">
</cfloop>
<cfset myDWGlist = ArrayToList(allCusArray, ",")>
Now I want to use that list in the query as the value of the IN
statement:
<cfquery name="getAllDWGs" datasource="DSN" dbtype="ODBC">
Select *
From blah
where DWGRID IN (#myDWGlist#)
Order by DWGDNO
</cfquery>
I'm getting the following error:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][IBM][iSeries Access
ODBC Driver][DB2 UDB]SQL0104 - Token CBE99B83 was not valid. Valid
tokens: ,.
The error occurred in
E:\wwwroot\data\appDWGDisplay_cusSearchForDWGs.cfm: line 29
27 : Select *
28 : From AEQDWG
29 : where DWGRID IN (#myDWGlist#)
30 : Order by DWGDNO
31 : </cfquery>
SQL Select * From AEQDWG where DWGRID IN
(''CBE99B83-E8BB-07D5-ECC57AAA3A6D0F11'',''CBE99BB2-B847-C9BD-D112B583AE
B4FF20'') Order by DWGDNO
DATASOURCE blah
VENDORERRORCODE -104
SQLSTATE 42000
What's going on causing the rearrangement of single quotes? How do I fix
this issue? Sorry if this is a dumb question. Thanks in advance.
Ron Mast
Truth Hardware
Webmaster
507-444-4748
_______________________
This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual to whom they are addressed. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, please be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited.
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
--
~Dave Shuck
[EMAIL PROTECTED]
http://www.daveshuck.com
_______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
