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
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
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
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
, 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
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
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
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
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 =
: 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
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
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]
12 matches
Mail list logo