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,
I want to take that list of zip codes and blend it with the
next query that
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
generated. I'm using MySQL if it matters.
"cf_dev2" <firstname.lastname@example.org> wrote in
> Try a where in clause ..
> WHERE ZipCode IN (
> <cfqueryparam cfsqltype="cf_sql_varchar"
> .... other conditions.....