[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: ', '<[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 -
RE: [ACFUG Discuss] regex / quotedvaluelist question
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 () -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: ', '<[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?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 -
Re: [ACFUG Discuss] regex / quotedvaluelist question
Youa re trying to remove the cfset text?TeddyOn 9/28/06, Steven Ross <[EMAIL PROTECTED]> wrote: Trying to find out if this is possible using regex? Would I need touse backreferences to accomplish this? I'd like to search the following 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 imight be able to use QuotedValueList but, looks like that wont work... is that right?--Steven Rossweb application & interface developerhttp://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.edituserformFor more info, see http://www.acfug.org/mailinglistsArchive @ http://www.mail-archive.com/discussion%40acfug.org/List hosted by http://www.fusionlink.com--- Blog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.org - 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 FusionLink -
Re: [ACFUG Discuss] regex / quotedvaluelist question
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 (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: ', '<[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 -
Re: RE: [ACFUG Discuss] regex / quotedvaluelist question
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 () -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: ', '<[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 -
RE: RE: [ACFUG Discuss] regex / quotedvaluelist question
There's yet another solution, should you ever need to solve that sort of problem with something other than input to a SQL (where CFQUERYPARAM is best). Recalling your original need, starting with this: > > and produce this: > > '<[EMAIL PROTECTED]>', '<[EMAIL PROTECTED]>', > '<[EMAIL PROTECTED]>' This could be done with the often-missed function listqualify, instead: , <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>","'")> #string# /charlie http://www.carehart.org/blog/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross Sent: Thursday, September 28, 2006 11:25 AM To: discussion@acfug.org Subject: Re: RE: [ACFUG Discuss] regex / quotedvaluelist question duh... forgot that queryparam encapsulates everything in singlequotes - 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 -