><cfset ID = 1>
><cfset test="Hi, this line has a single quote [ ' ] in it. Didn't I tell
>you it did.">
>
><cfset updateValue = perserveSingleQuotes(test)>
>
><cfquery....>
> UPDATE table
> SET field = <cfqueryParam value="#updateValue#"
> cfsqltype="cf_sql_varchar">
> WHERE ID = <cfqueryParam value="#ID# cfsqltype="cf_sql_integer">
></cfquery>
Thanks for this info. When I try it, I run into one of two problems:
If I use this code:
<cfquery name="InsertData" datasource="#DSN2#">
INSERT INTO ArchivedStuff(Field1,Field2,Field3)
VALUES (<cfqueryparam value="#Field1#" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="#Field2#" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="#Field3#" cfsqltype="CF_SQL_VARCHAR">)
</cfquery>
I get this error: ODBC Error Code = S1104 (Invalid precision value)
Field 1 and 2 are both Text fields, and Field 3 is a memo. I also tried this:
<cfquery name="InsertData" datasource="#DSN2#">
INSERT INTO ArchivedStuff(Field1,Field2,Field3)
VALUES (<cfqueryparam value="#Field1#" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="#Field2#" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="#Field3#" cfsqltype="CF_SQL_LONGVARCHAR">)
</cfquery>
But then I get the error: ODBC Error Code = 37000 (Syntax error or access
violation)
Any idea what I'm doing wrong?
T
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
