<cfset s=#FORM.SubjectID#>
<cfset s1=",">
<cfset s2="','">
<cfset p2=#Replace(s,s1,s2,"All")#>
SELECT EmailAddr, RecipientID
FROM SupportEmailRecipient
WHERE SubjectID IN ('#p2#')
��� Tony
> Tuesday, July 1, 2003, 2:58:55 PM, you wrote:
> LF> Ok guys.. Thinking caps: ON
> LF> Have an nvarchar field in the database with data like:
> 1,3,9,12,2,51
> LF> Have a formfield with single number (not digit) data,
> like: 1 or 12 --
> LF> single whole numbers, maybe more than 1 digit.
> LF> Now, would like to do something like this:
> LF> SELECT EmailAddr, RecipientID
> LF> FROM SupportEmailRecipient
> LF> WHERE SubjectID IN ('#FORM.SubjectID#)
> LF> It ain't workin... Need to see if the data from the
> formfield is IN the data
> LF> in the table's record.
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~~~~~~~~~~|
> 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/uns
> ubscribe.cfm?user=633.558.4
s. isaac dealey 972-490-6624
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
