RE: Single Quotes in Comment Fields Problem

02:40 | To: CF-Talk | Subject: Re: Single Quotes in Comment Fields Problem | | OK, | | This one errors out: | COMMENTS = cfqueryparam name=#form[comments_#thisId#]# | | Attribute validation error for tag CFQUERYPARAM. | The tag does not allow the attribute(s) NAME. The valid | attribute(s

Re: Single Quotes in Comment Fields Problem

Hugo Ahlenius wrote: RTFM on cfqueryparam, you need to supply the 'value' and 'cfsqltype' as attributes to cfqueryparam: I did!I did RTFM! I just didn't understand how to work it back into the evaluate statement I was using to combine the field variable names along with the record id

Re: Single Quotes in Comment Fields Problem

I just didn't understand how to work it back into the evaluate statement I was using to combine the field variable names along with the record id numbers to updte multiple rows. I recently ran into this issue and found that the Evaluate function can cause problems in query statements if you

Single Quotes in Comment Fields Problem

Stupid Question, but can't seem to find a solution that works properly... Got a formthat updates a SQL Server database with a several multiline text fields. Stuff like Ted's 8x12 brochure still needs a little work gets entered into these fields I'm updating multiple rows by appending

RE: Single Quotes in Comment Fields Problem

, February 23, 2004 4:37 PM To: CF-Talk Subject: Single Quotes in Comment Fields Problem Stupid Question, but can't seem to find a solution that works properly... Got a formthat updates a SQL Server database with a several multiline text fields. Stuff like Ted's 8x12 brochure still needs

Re: Single Quotes in Comment Fields Problem

Barney Boisvert wrote: Use CFQUERYPARAM.You can also use some trickery with escaping various quotes and such, but CFQUERYPARAM is far preferable, since it also helps protect against numerous other bad things. Hmmm... Sorry, not 100% sure how to do this, expecially since I'm updating

RE: Single Quotes in Comment Fields Problem

UPDATE INT_PROJECT SET URGENCY = cfqueryparam cfsqltype=cf_sql_varchar value=#FORM['URGENCY_#thisID#']#' null=false /, -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 5:01 PM To: CF-Talk Subject: Re: Single Quotes in Comment Fields

RE: Single Quotes in Comment Fields Problem

SET URGENCY = cfqueryparam name=#form[urgency_#thisId#]#, COMMENTS = cfqueryparam name=#form[comments_#thisId#]#, -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, 24 February 2004 1:01 p.m. To: CF-Talk Subject: Re: Single Quotes in Comment Fields Problem

Re: Single Quotes in Comment Fields Problem

OK, This one errors out: COMMENTS = cfqueryparam name=#form[comments_#thisId#]# Attribute validation error for tag CFQUERYPARAM. The tag does not allow the attribute(s) NAME. The valid attribute(s) are CFSQLTYPE,LIST,MAXLENGTH,NULL,SCALE,SEPARATOR,VALUE. This one works: COMMENTS =

RE: Single Quotes in Comment Fields Problem

: Single Quotes in Comment Fields Problem OK, This one errors out: COMMENTS = cfqueryparam name=#form[comments_#thisId#]# Attribute validation error for tag CFQUERYPARAM. The tag does not allow the attribute(s) NAME. The valid attribute(s) are CFSQLTYPE,LIST,MAXLENGTH,NULL,SCALE,SEPARATOR,VALUE

RE: Single Quotes in Comment Fields Problem

Oops sorry ;-) -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, 24 February 2004 1:40 p.m. To: CF-Talk Subject: Re: Single Quotes in Comment Fields Problem OK, This one errors out: COMMENTS = cfqueryparam name=#form[comments_#thisId#]# Attribute validation

Re: Single Quotes in Comment Fields Problem

Les, On Monday, February 23, 2004, 8:39:51 PM, you wrote: LM COMMENTS = cfqueryparam cfsqltype=cf_sql_varchar LM value=#FORM['COMMENTS_#thisID#']#' null=false /, An alternate way to provide the form value: value=#FORM['COMMENTS_'thisID]# ~ Ubqtous ~ [Todays Threads] [This Message]