James, Check your where clause, it looks like there is a space at the end of the number.
this: SQL = "update lsardba.tbl_response set final_doc = 'update.doc' where r_id = '10001 '" should probably be this: SQL = "update lsardba.tbl_response set final_doc = 'update.doc' where r_id = '10001'" Matthew >From: "James Taavon" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: SQL <[EMAIL PROTECTED]> >Subject: RE: ODBC Error Code = S1010 (Function sequence error) >Date: Tue, 28 May 2002 15:59:12 -0400 > >here is the full error: > >ODBC Error Code = S1010 (Function sequence error) > >[Microsoft][ODBC Driver Manager] Function sequence error > >SQL = "update lsardba.tbl_response set final_doc = 'update.doc' where r_id >= >'10001 '" > >Data Source = "LSARPROD" > >The error occurred while processing an element with a general identifier of >(CFQUERY), occupying document position (15:1) to (15:49) in the template >file c:\inetpub\wwwroot\lsar_remote_05232002\final_upload.cfm. > > > > > >-----Original Message----- >From: Dina Hess [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, May 28, 2002 3:12 PM >To: SQL >Subject: Re: ODBC Error Code = S1010 (Function sequence error) > > >james, > >did you mean this? > ><cfquery name="UpdateFile" datasource="lsarprod"> >update tbl_response >set final_doc = '#CFFILE.ServerFile#' >where r_id = '#url.lid#' ></cfquery> > >per forta's WACK, the CFFILE scope would access <CFFILE> process >details when ACTION="upload". > >~ dina > > > > >----- Original Message ----- >From: "James Taavon" <[EMAIL PROTECTED]> >To: "SQL" <[EMAIL PROTECTED]> >Sent: Tuesday, May 28, 2002 11:52 AM >Subject: ODBC Error Code = S1010 (Function sequence error) > > > > I got this error while doing a simple update query. never have >seen it > > before. > > > > ODBC Error Code = S1010 (Function sequence error) > > > > > > References this query: > > > > <cfquery name="UpdateFile" datasource="lsarprod"> > > update lsardba.tbl_response > > set final_doc = '#File.ServerFile#' > > where r_id = '#url.lid#' > > </cfquery> > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
