[freetds] SELECT @@IDENTITY AS InsertID
Shaun Craig
s.craig at andronics.com
Wed Oct 12 04:36:56 EDT 2005
find attached file, hopefully you mite spot something, must pop out to
dentist for a while, scary stuff!
Thompson, Bill D (London) wrote:
>Shaun,
>
>get us a TDSDUMP log file:
>
>export TDSDUMP=<filename>
>
>run the application.
>
>Post us the results.
>
>Bill
>
>
>-----Original Message-----
>From: freetds-bounces at lists.ibiblio.org
>[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Shaun Craig
>Sent: 12 October 2005 09:12
>To: FreeTDS Development Group
>Subject: Re: [freetds] SELECT @@IDENTITY AS InsertID
>
>
>Me again! Just got back to working on this problem, im now finding
>through running gdb debugging the following message:
>
>Program received signal SIGSEGV, Segmentation fault.
>0x4007d1c7 in buffer_transfer_bound_data (rowtype=Variable "rowtype" is
>not available.
>) at dblib.c:6460
>6460 memcpy(dest, &(dres.dt4),
>sizeof(TDS_DATETIME4));
>
>It seems that when i try to bind the insertid(int) to my variable its
>trying to bind a date for some reason.
>
>dbbind(dbconn, 1, INTBIND, (DBINT)0, (BYTE *)& InsertID);
>
>Any thoughts?
>
>Lowden, James K wrote:
>
>
>
>>>From: Shaun Craig
>>>Sent: Thursday, October 06, 2005 11:37 AM
>>>
>>>I break the query string up depending on how many statements are in
>>>
>>>
>>>
>>>
>>it,
>>
>>
>>
>>
>>>so for above i have 2, 1 for insert and 1 for select
>>>
>>>for ( x = 0; x < amount of statments + 1; x++ )
>>>{
>>> //first time around it will be the insert which inserts ok
>>> dbcmd(dbconn, statements[x])
>>> dbsqlexec(dbconn)
>>> dbresults(dbconn)
>>>
>>> if we find that the statement is a 'Select @@Identity..etc' we go
>>>
>>>
>>>
>>>
>>in
>>
>>
>>
>>
>>>here, we wont the first time but when we go around the second time we
>>>will go in.
>>> {
>>> // try bind select to variable
>>> dbbind(dbconn, 1, INTBIND, (DBINT)0, (BYTE *)& InsertID);
>>>
>>>
>>>
>>>
>>//its
>>
>>
>>
>>
>>>says its binding ok but what its binding i cant be sure!
>>>
>>> if (dbnextrow(dbconn) != NO_MORE_ROWS)
>>> journey_insert_id = InsertID;
>>> }
>>>}
>>>
>>>
>>>
>>>
>>In addition to Bill's advice, make sure you're checking the return code
>>
>>
>>from each db-lib call. And you might want to do some sanity checks
>with
>
>
>>dbcoltype(), dbnumcols(), dbcolname() to make sure the column you're
>>binding to is really the one you're expecting.
>>
>>BTW, re the pool server, I don't have anything for you. Someone more
>>familiar with the code (and/or more motivated) would need to look at
>>
>>
>it.
>
>
>>HTH.
>>
>>--jkl
>>
>>-----------------------------------------
>>The information contained in this transmission may be privileged and
>>confidential and is intended only for the use of the person(s) named
>>above. If you are not the intended recipient, or an employee or agent
>>
>>
>responsible
>
>
>>for delivering this message to the intended recipient, any review,
>>
>>
>dissemination,
>
>
>>distribution or duplication of this communication is strictly
>>
>>
>prohibited. If you are
>
>
>>not the intended recipient, please contact the sender immediately by
>>
>>
>reply e-mail
>
>
>>and destroy all copies of the original message. Please note that we do
>>
>>
>not accept
>
>
>>account orders and/or instructions by e-mail, and therefore will not be
>>
>>
>responsible
>
>
>>for carrying out such orders and/or instructions. If you, as the
>>
>>
>intended recipient
>
>
>>of this message, the purpose of which is to inform and update our
>>
>>
>clients, prospects
>
>
>>and consultants of developments relating to our services and products,
>>
>>
>would not
>
>
>>like to receive further e-mail correspondence from the sender, please
>>
>>
>"reply" to the
>
>
>>sender indicating your wishes. In the U.S.: 1345 Avenue of the
>>
>>
>Americas, New York,
>
>
>>NY 10105.
>>
>>
>>
>>
>>
>
>
>
>
--
Shaun Craig
Andronics Ltd.
Tel: 02871273118
Web: http://www.andronics.co.uk
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: tdsdump
Url: http://lists.ibiblio.org/pipermail/freetds/attachments/20051012/b50b30dd/tdsdump-0001.bat
More information about the FreeTDS
mailing list