Roberto,
Yes, the value you use for the attribute 'cfsqltype' is directly related
to the datatype of the field 'regionID'. I am not the expert regarding the
performance issue, but I would assume you will take a hit if the list of IDs
grows too large.
Charlie Hanlon
----- Original Message -----
From: "Roberto Perez" <[EMAIL PROTECTED]>
To: "CF-Talk" <[email protected]>
Sent: Friday, March 03, 2006 3:48 PM
Subject: Re: using WHERE with ValueList?
> At 02:24 PM 3/3/2006, Bryan Stevenson wrote:
>
>> suspect you need to use IN instead of CONTAINS
>>
>>v.regionID IN (<cfqueryparam value="#valuelist(getRegions.regionID)##"
>>cfsqltype="cf_sql_numeric" list="yes">)
>
>
> Thanks, I stripped the extra numeral sign and it worked perfectly.
> Any known performance issues if my list has around 50 items?
>
> Also, my list is numeric. Would this work if I had alphanumeric
> characters? (I'm wondering whether the "cf_sql_numeric" part may
> affect data type)
>
> Thanks again,
>
> Roberto
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234127
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
