RTFM on cfqueryparam, you need to supply the 'value' and 'cfsqltype' as
attributes to cfqueryparam:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b20.htm#wp11
02474
-------------------------------------------------------------
Hugo Ahlenius E-Mail: [EMAIL PROTECTED]
Project Officer Phone: +46 8 230460
UNEP GRID-Arendal Fax: +46 8 230441
Stockholm Office Mobile: +46 733 467111
WWW: http://www.grida.no
-------------------------------------------------------------
| -----Original Message-----
| From: Les Mizzell [mailto:[EMAIL PROTECTED]
| Sent: Tuesday, February 24, 2004 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) are CFSQLTYPE,LIST,MAXLENGTH,NULL,SCALE,SEPARATOR,VALUE.
|
|
| This one works:
|
| COMMENTS = <cfqueryparam cfsqltype="cf_sql_varchar"
| value="#FORM['COMMENTS_#thisID#']#' null="false" />,
|
|
| Interesting. Learn something every day - despite the ever ticking age
| clock. Heh...
|
| Thanks so much for the input!
|
| --
| Les Mizzell
| ------------------------------------------
| Skill without imagination is craftsmanship
| and gives us many useful objects such as
| wickerwork picnic baskets. Imagination
| without skill gives us modern art.
| ------------------------------------------
|
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
