><cfquery datasource="#datasource#">
> UPDATE mytable SET field1 = <cfqueryparam value="#filesize.size#"
>cfsqltype="CF_SQL_NUMERIC"> AND field2_BLOB = <cfqueryparam
>value="#doc_blob#" cfsqltype="CF_SQL_LONGVARCHAR"> WHERE field3 =
>'#field3#'
>
> </cfquery>
>
>
>I am getting the error sql not properly terminated. Is there something
>special I need to do to insert into a blob?
Your UPDATE statment is wrong. You separate mutiple fields to set by a
comma, not the AND keyword. Your query should be (note that I removed the
cfqueryparam tags only for clarity):
<cfquery datasource="#datasource#">
UPDATE mytable
SET field1 = #filesize.size#,
field2_BLOB = #doc_blob#
WHERE field3 = '#field3#'
</cfquery>
Regards,
Dave.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
