Dear listmembers,
Help. Sorry for the possible OT (it's a CF site) but I'm really stuck. I
have an issue between SQL syntax and whether or not to use a list or
straight form value in the query. I have not been able to get it working
either way so far.
I have a form that submits to an action page. the form has a multiple
select for states. The value carried when multiple are selected is like
this CA,AR,AK etc. This field is named 'EmailState' on the form. On the
action page I want to select entries from tables where addresses are in
the states selected.
My membership (IN) filter is not returning the desired values...but I
was certain it was correct (below). Also, should I put this into a list
before using it in the query? I would greatly appreciate any fresh
thoughts or input. Here is my query, the database is SQL Server 2000 and
CF5.
SELECT Subscribers.SubscriberID, Subscribers.EMail
FROM (Subscribers INNER JOIN SubscriberAddress ON
(Subscribers.SubscriberID = SubscriberAddress.ASubscriberID))
WHERE SubscriberAddress.state IN ('#FORM.EmailState#')
Best Regards,
Tony Gruen
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
