I'm using some custom tags with this setup... so basically the html code is being sent to
this query template via the attributes.sql. Am I using the tag correctly?
<!--- OLD CODE
<cfquery name="caller.#attributes.qname#" datasource="#dadatasource#">
#PreserveSingleQuotes(attributes.sql)#
</cfquery>
--->
<!--- New Code with cfqueryparam. --->
<cfquery name="caller.#attributes.qname#" datasource="#dadatasource#">
<cfqueryparam value="#attributes.sql#">
</cfquery>
ERROR:
ODBC Error Code = S1001 (Memory allocation error)
[Microsoft][ODBC Microsoft Access Driver] System resource exceeded
----- Original Message -----
From: Jochem van Dieten
To: CF-Talk
Sent: Thursday, January 22, 2004 12:52 PM
Subject: Re: some errors...
Daniel Farmer said:
>
> I'm having a problem inserting code however when single quotes are
> present in the html. I tried preservesinglequotes around my SQL
> insert. But still I get an error...
Try cfqueryparam.
> ERROR
>
> ODBC Error Code = 37000 (Syntax error or access violation)
>
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
> operator) in query _expression_
Code?
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
