List into Query?

[Newsgroup_User]

This should be simple, but I can't wrap my head around it.

A user inputs their zip code into a page. A list of nearby zip codes is
returned from the database, separated by commas. No problem, that part's
done.

I want to take that list of zip codes and blend it with the next query that
takes place.

The current query takes two search criteria and returns results from the
database. But I want to tell the query that each record returned from the
database must contain one of the zip codes in the list that was just
generated. I'm using MySQL if it matters.

--
Bill

[cf_dev2]

Try a where in clause ..

WHERE ZipCode IN (
<cfqueryparam cfsqltype="cf_sql_varchar" value="#ListOfZipCodes#" list="yes">
)
AND
.... other conditions.....

[Newsgroup_User]

"cf_dev2" <webforumsuser@macromedia.com> wrote in message
news:eju47d$bkq$1@forums.macromedia.com...
> Try a where in clause ..
>
> WHERE ZipCode IN (
> <cfqueryparam cfsqltype="cf_sql_varchar" value="#ListOfZipCodes#"
> list="yes">
> )
> AND
> .... other conditions.....



That worked perfectly. Thanks!