I have a form with a multi select drop down list allowing the user to select
more than one city from the form select list
The resulting output values contained in the form field city are melb,syd
I am trying to query a table to find records who's city value is either melb
or syd as an example however I continue to get 0 results
<CFQUERY datasource="#ds#" username="#un#" password="#pw#" NAME="records">
select *
from properties
where city in ('#form.city#')
</CFQUERY>
Regards
Claude Raiola
B.Econ (Acc), B.Hot.Mngt.
Websites:
www.AustralianAccommodation.com
www.SAMARIS.NET
www.WebSiteSolutions.com.au
Mobile: 0414 228 948
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
