Assuming zip in the database is number field then it should work without the
single quotes around the variable. I would use a cfqueryparam though:
WHERE ZIP IN (<cfqueryparam value="#Variables.ReturnedZIPS#"
cfsqltype="cf_sql_numeric" list="yes" />)
On 8/24/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]>
wrote:
>
> I forget how to do this. ReturnedZIPs is a variable with comma delimted
> zip codes.
> I tried valuelist and got an error. Any help would be great thanks.
>
> <cfquery name="get_stores" datasource="#datasource#">
> select *
> from tblstores_import
> where zip IN ('#ReturnedZIPs#')
> </cfquery>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287081
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
