First off, here is my code..
<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? Thanks in advance Brian Yager President - North Alabama Cold Fusion Users Group http://www.nacfug.com Ground-Based Midcourse Defense JPO Contractor CSC (256)313-9668 [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4