WHERE zip IN (#listQualify(returnedZips, "'")#)
that second argument of listQualify is a single quote enclosed by double quotes.
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>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287083
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
