duh... forgot that queryparam encapsulates everything in singlequotes....
On 9/28/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Couldn't you just use cfqueryparam and use the list functionality built into
that tag? It'd be a lot more secure and it would handle all that for you...
SELECT * FROM whatever where email in (<cfqueryparam cfsqltype="CF_SQL_VARCHAR" list="Yes" value="<[EMAIL
PROTECTED]>,<[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>" separator=",">)
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Steven Ross
Sent: Thursday, September 28, 2006 11:05 AM
To: ACFUG ColdFusion Discussion
Subject: [ACFUG Discuss] regex / quotedvaluelist question
Trying to find out if this is possible using regex? Would I need to
use backreferences to accomplish this? I'd like to search the
following string:
<cfset string = "<[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>"
and produce this:
'<[EMAIL PROTECTED]>', '<[EMAIL PROTECTED]>',
'<[EMAIL PROTECTED]>'
The reason is that i want to use it in an "IN" clause... I thought i
might be able to use QuotedValueList but, looks like that wont work...
is that right?
--
Steven Ross
web application & interface developer
http://www.zerium.com
[mobile] 404-488-4364
[fax] 928-484-4364
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?falogin.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
--
Steven Ross
web application & interface developer
http://www.zerium.com
[mobile] 404-488-4364
[fax] 928-484-4364
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
