What DataType is r_id?
Do you mean to have a trailing space on the value? ('10001 ')
Just thinking out loud...
Steve
At 03:59 PM 5/28/2002 -0400, James Taavon wrote:
>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>
>>
>>
>
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
