BINGO... I had to remove a leading and trailing single quote before using the ListQualify, followed by a:
WHERE accounts.streetname in (#PreserveSingleQuotes(newlist)#) but, it now works... thanks for your help! -----Original Message----- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Sunday, September 14, 2003 11:48 PM To: CF-Talk Subject: RE: works fine in access, but not cf > -----Original Message----- > From: B.H. Forbes [mailto:[EMAIL PROTECTED] > Sent: Monday, September 15, 2003 12:28 AM > To: CF-Talk > Subject: RE: works fine in access, but not cf > > this thing is driving me nuts... my passed variable looks like this: > > <cfoutput>#passed_street_names#</cfoutput> > > exact results: 'street 1,street 2,street 3,street 4' > (exactly... one single quote before and after, one comma in between) > > SELECT accounts.accountid, accounts.streetname > FROM accounts > WHERE accounts.streetname In (#passed_street_names#) > > Realizing that I need to get it looking like: > 'street 1','street 2','street 3','street 4' > > I create a listappend that builds it exactly like the above, but when the > query runs, it has dropped the beginning and trailing single quote... so > that it now looks like: This is exactly what the ListQualify() function is designed to do. Use that and I think that you'll be much happier. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
