RE: Is there a good way to do this?

One word - CFSCRIPT Also, when you refer to a cell in a query with square brackets it's Query[Field][Row] So it'd be GetReg[i][x] From: Mark W. Breneman [mailto:[EMAIL PROTECTED] I need to replace all single quotes with double single quotes in all of the fields of a query. I know that I

RE: Is there a good way to do this?

I haven't tried it, so take this with a grain or three of salt, but 2 things stand out: 1) Start x at 1, not 0, and 2) You probably have to use the Evaluate() function around the i[x] bit as in: replace(Evaluate(getreg.#i#[#x#]),', '',all) Again, untested. -- Mosh Teitelbaum evoch, LLC

Re: Is there a good way to do this?

You weren't too far off... cfoutput query=getreg cfloop index=i list=#columnlist# cfset temp= QuerySetCell(getreg,i, replace(getreg[i][currentrow],', '',all),currentrow) /cfloop /cfoutput Sorry for the wrap... I need to replace all single quotes with double single quotes in

RE: Is there a good way to do this?

, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 4:01 PM To: CF-Talk Subject: RE: Is there a good way to do this? One word - CFSCRIPT Also

RE: Is there a good way to do this?

: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 3:01 PM To: CF-Talk Subject: RE: Is there a good way to do this? One word - CFSCRIPT Also, when you refer to a cell in a query with square brackets it's Query[Field][Row] So it'd be GetReg[i][x] From: Mark W. Breneman [mailto

RE: Is there a good way to do this?

One word - CFSCRIPT Why? Outside of having a structtoquery() function... Also, when you refer to a cell in a query with square brackets it's Query[Field][Row] So it'd be GetReg[i][x] From: Mark W. Breneman [mailto:[EMAIL PROTECTED] I need to replace all single quotes with double

RE: Is there a good way to do this?

Why even create the temp variable?? cfset QuerySetCell(...) chris -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 1:14 PM To: CF-Talk Subject: Re: Is there a good way to do this? You weren't too far off... cfoutput query=getreg

RE: Is there a good way to do this?

I haven't tried it, so take this with a grain or three of salt, but 2 things stand out: 1) Start x at 1, not 0, and 2) You probably have to use the Evaluate() function around the i[x] bit as in: replace(Evaluate(getreg.#i#[#x#]),', '',all) Again, untested. This should work, but

RE: Is there a good way to do this?

One word - CFSCRIPT Why? Speed and WhiteSpace I know CFMX levels the speed between CF tags and CFSCRIPT but it's easier to read and easier if the code is running on CF5 and CFMX As for WhiteSpace, I know that CFSETTING can get rid of that, but most people tend to not use it...

RE: Is there a good way to do this?

PROTECTED] Sent: Tuesday, June 10, 2003 3:26 PM To: CF-Talk Subject: RE: Is there a good way to do this? Why even create the temp variable?? cfset QuerySetCell(...) chris -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 1:14 PM To: CF-Talk

RE: Is there a good way to do this?

Oops... forgot to remove the temp= ... heh. :) Why even create the temp variable?? cfset QuerySetCell(...) chris -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 1:14 PM To: CF-Talk Subject: Re: Is there a good way to do this? You

RE: Is there a good way to do this?

One word - CFSCRIPT Why? Speed and WhiteSpace I know CFMX levels the speed between CF tags and CFSCRIPT but it's easier to read and easier if the code is running on CF5 and CFMX As for WhiteSpace, I know that CFSETTING can get rid of that, but most people tend to not use it...

RE: Is there a good way to do this?

To: CF-Talk Subject: RE: Is there a good way to do this? I haven't tried it, so take this with a grain or three of salt, but 2 things stand out: 1) Start x at 1, not 0, and 2) You probably have to use the Evaluate() function around the i[x] bit as in: replace(Evaluate(getreg.#i

RE: Is there a good way to do this?

W. Breneman [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 4:50 PM To: CF-Talk Subject: RE: Is there a good way to do this? To be honest, I was not sure if I needed to or not. I thought about it for a sec and decided that I was sure it would work with the temp variable

RE: Is there a good way to do this?

Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 4:19 PM To: CF-Talk Subject: RE: Is there a good way to do this? When using a CFSET tag, you only need the variable part if you want

RE: Is there a good way to do this?

IIRC, this was new to CF5. Doug -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 5:34 PM To: CF-Talk Subject: RE: Is there a good way to do this? That seems too simple. :-) Did it work that way in CF 3? (The ver I learned cf in) I seem

RE: Is there a good way to do this?

PROTECTED] Sent: Tuesday, June 10, 2003 4:28 PM To: CF-Talk Subject: RE: Is there a good way to do this? I haven't tried it, so take this with a grain or three of salt, but 2 things stand out: 1) Start x at 1, not 0, and 2) You probably have to use the Evaluate() function around

RE: Is there a good way to do this?

: 360.647.5351 www.audiencecentral.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 2:38 PM To: CF-Talk Subject: RE: Is there a good way to do this? IIRC, this was new to CF5. Doug -Original Message- From: Mark W. Breneman