Hi,
I have some variables in form which may or may not be defined. Now I want to
use these variables in IN clause of a SQL query. i.e Select * from <tablename>
where <condition> and column IN ('#form.var1$#','#form.var2#'..).
Is there any function in coldfusion to convert the form variables into quoted
value list. I know there is a function QuotedValueList() to convert query
column values. Is there anything similar to this for form variables?
Thanks in advance.
Regards,
Vineet Garg.
This message and the information contained herein is proprietary and
confidential and subject to the Amdocs policy statement,
you may review at http://www.amdocs.com/email_disclaimer.asp
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4814
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15