Actually, it doesn't do that at all. It just doesn't require the
delimiter for the values due to the nature of how the data is processed.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
"[T]he people can always be brought to the bidding of the leaders.
This is easy. All you have to do is to tell them they are being
attacked, and denounce the pacifists for lack of patriotism and
exposing the country to danger. It works the same in every country."
--Hermann Goering, Hitler's Reich-Marshall at the Nuremberg Trials
On Sep 28, 2006, at 11:24 AM, Steven Ross wrote:
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]>,<239984
[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
-------------------------------------------------------------
-------------------------------------------------------------
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
-------------------------------------------------------------
