Ok guys.. Thinking caps: ON
Have an nvarchar field in the database with data like: 1,3,9,12,2,51
Have a formfield with single number (not digit) data, like: 1 or 12 --
single whole numbers, maybe more than 1 digit.
Now, would like to do something like this:
SELECT EmailAddr, RecipientID
FROM SupportEmailRecipient
WHERE SubjectID IN ('#FORM.SubjectID#)
It ain't workin... Need to see if the data from the formfield is IN the data
in the table's record.
Help?
TTAIA
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
