Thanks Dina,

Thats what I meant (&). I tried htmlEditFormat and still get an error on the &.

Dan

On Mon, 18 Oct 2004 07:58:49 -0700, Dina Hess <[EMAIL PROTECTED]> wrote:
> try htmleditformat(); and it's "&gt;" not "@gt;"
>    ----- Original Message -----
>    From: Dan O'Keefe
>    To: CF-Talk
>    Sent: Monday, October 18, 2004 7:33 AM
>    Subject: Execute Query string w CFQUERYPARAM
>  
>    I have a variable that contains the following:
>  
>    Insert into tblProducts (product,c_productDesc,active)
>    Values
>    <cfqueryparam cfsqltype='CF_SQL_INTEGER' value='new Product name'>,
>    <cfqueryparam cfsqltype='CF_SQL_VARCHAR' value='new Product desc'>,
>    <cfqueryparam cfsqltype='CF_SQL_BIT' value='1'
>  
>    I want to execute this string inside a cfquery tag. 1st problem is,
>    when I am building the string and looping over an array, if I try to
>    use < and > in the string, my string ends up being empty. If I replace
>    that with @lt; and @gt;, the string is built OK, as displayed abouve,
>    but get an ODBC error on the @.
>  
>    I have played around with evaluating and DE, but cannot get past this
>    point. Is this possible?
>  
>    ----------------
>    Dan O'Keefe________________________________
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to