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: "street 1','street 2','street 3','street 4" I have been looking at this too long and now I must be missing the obvious. I just want to be able to pass that "passed_street_list" to the query and use it in the "IN" statement. I'm probably making this way to hard. Any help? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
