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> > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
