no, i dont think so... i tried it and it did not work either. it has worked in the past, i think. Database is DB2/NT right now, will be on SQL 2000 soon.
-----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> > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
