hmmm, I usually use HTMLEditFormat() with no issues.
can ditch the evals too
<cfif form["MOD_DESC_#myIDX#"] NEQ ''>
MOD_DESC =
<cfqueryparam
cfsqltype="CF_SQL_VARCHAR"
value="#form["MOD_DESC_#myIDX#"]#">,
<cfelse> NULL </cfif>
Doug
On Wed, 27 Oct 2004 16:09:46 -0400, Les Mizzell <[EMAIL PROTECTED]> wrote:
> This seems to be working best:
>
> 1. To display data in the form:
>
> <cfset quote ='"'>
> <input value="#Replace(AOS_145OP.MOD_DESC,QUOTE,""","ALL")#">
>
> Using this will correctly display either of these values in the database:
> "32" (12"-32" adjustable)
> - or -
> 32" (12"-32" adjustable)
>
>
> 2. Updating the database (multiple rows)
>
> <cfif #evaluate("MOD_DESC_#myIDX#")# NEQ ''>
> MOD_DESC =
> <cfqueryparam
> cfsqltype="CF_SQL_VARCHAR"
> value="#evaluate("MOD_DESC_#myIDX#")#">,
> <cfelse> NULL </cfif>
>
> Unless somebody has a better more compact way to do that, this is what
> I'm going with...
>
> --
> Les Mizzell
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182763
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
