Roberto,
Keep the Where the clause the same as it was before:
WHERE r.regionID IN (<cfqueryparam value=#Session.regionList# list="yes"
cfsqltype="_____">)
As long as the variables. session.regionList is comma-delimeted, otherwise,
WHERE r.regionID IN (<cfqueryparam value=#Session.regionList# list="yes"
separator="myDelimeter" cfsqltype="_____">)
You're definately close to solving this.....
hth
Charlie Hanlon
----- Original Message -----
From: "Roberto Perez" <[EMAIL PROTECTED]>
To: "CF-Talk" <[email protected]>
Sent: Friday, March 03, 2006 4:57 PM
Subject: Re: using WHERE with ValueList?
> At 04:31 PM 3/3/2006, you wrote:
>>Sure....set a var called SESSION.RegionList =
>>ValueList(myquery.myColumn) (when
>>needed).....then always use the session var in your IN clause without the
>>ValueList() function
>
>
> Mmm... that didn't work, it's the same issue I was having when I
> started: it runs, but it does not find any match (recordCount returns
> 0). This is the WHERE clause:
>
> WHERE r.regionID IN ('#Session.regionList#')
>
> I can always add a previous query to get all regions for a given
> user, and plug that in with the myQuery.myColumn format, but if I can
> save a query, I'd like to.
>
> Thanks,
>
> Roberto
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234142
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
