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> > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
