I can't believe I missed that! Thanks forthe help..It's spinningaway now! :)
Brian ----- Original Message ----- From: "Dave Carabetta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 27, 2003 10:50 AM Subject: Re: getting error inserting inot a BLOB > ><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
