Saweetness! Thanks a million that worked awesome! Ron Mast Truth Hardware Webmaster 507-444-4748
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of miguel olivarez Sent: Friday, September 29, 2006 12:45 PM To: Dallas/Fort Worth ColdFusion User Group Mailing List Subject: Re: [DFW CFUG] SQL IN statement help Sorry misspelling: Should be this: PreserveSingleQuotes(myDWGlist) --- miguel olivarez <[EMAIL PROTECTED]> wrote: > You might try this instead of creating the array. > <cfset myDWGlist = quotedValueList(getAllCus.cfgid)> > > And in the SQL statement if your quotes are being > 'rearranged' use this PreserverSingleQuotes(DWGlist) > > > > --- 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/ > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.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/ > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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/ _______________________________________________ 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/
