> -----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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
