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]
I forget how to do this. ReturnedZIPs is a variable
with comma delimted zip codes.
where zip IN (#preserveSingleQuotes(listQualify(ReturnedZIPs, '))#)
Not tested, but should either work or get you on the right track.
-Justin Scott
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
ooh that's better than mine. cfqueryparam for the win.
On 8/24/07, Aaron Rouse [EMAIL PROTECTED] wrote:
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
4 matches
Mail list logo