At 05:03 PM 3/3/2006, Charlie Hanlon wrote: > Keep the Where the clause the same as it was before: > >WHERE r.regionID IN (<cfqueryparam value=#Session.regionList# list="yes" >cfsqltype="_____">)
Ok, I assumed all the cfqueryparam code had to go if I was using a session variable. Now I have this and it works: WHERE r.regionID IN (<cfqueryparam value="#Session.regionList#" cfsqltype="cf_sql_numeric" list="yes">) Thank you everyone. It was an intense and fruitful thread :-) Roberto ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234144 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
