In SQL 7 you need to specifie a table in a DB like "DATABASE..TABLE" double dot I try your exemple and it's work on my SQL 7 using the ".." but using a single dot give me this error : Invalid object name 'database.table'.
What is the database you use ? Do you have a trigger on this table ? Yanik Lupien -----Message d'origine----- De : James Taavon [mailto:[EMAIL PROTECTED]] Envoy� : 28 mai, 2002 13:03 � : SQL Objet : RE: ODBC Error Code = S1010 (Function sequence error) i dont understand your reply? -----Original Message----- From: Yanik Lupien [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 12:55 PM To: SQL Subject: RE: ODBC Error Code = S1010 (Function sequence error) lsardba..tbl_response -----Message d'origine----- De : James Taavon [mailto:[EMAIL PROTECTED]] Envoy� : 28 mai, 2002 12:52 � : SQL Objet : 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> ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
