Ahhh -- if Matthew is right, Just replace #url.lid# with #trim(url.lid)# Actually, a good rule of thumb is to use #trim()# OFTEN ... Wherever a spurious space could cause a problem.
On 5/28/02 2:05 PM, "Matthew Todd" <[EMAIL PROTECTED]> wrote: > 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> >>> >>> ______________________________________________________________________ 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
