; [EMAIL PROTECTED]
Subject: Re: LAST_INSERT_ID Issues
At 9:48 AM -0400 5/25/01, Dave Carter wrote:
>This does not return any results
>
>SELECT LAST_INSERT_ID() FROM tablename;
It doesn't return *any* results? Or do you mean it returns 0?
FROM tablename is superfluous here; t
query
>
>-Original Message-
>From: Billy Passauer [mailto:[EMAIL PROTECTED]]
>Sent: Friday, May 25, 2001 10:18 AM
>To: Dave Carter
>Subject: RE: LAST_INSERT_ID Issues
>
>
>> -Original Message-
>> From: Dave Carter [mailto:[EMAIL PROTECTED]]
>&
At 9:48 AM -0400 5/25/01, Dave Carter wrote:
>This does not return any results
>
>SELECT LAST_INSERT_ID() FROM tablename;
It doesn't return *any* results? Or do you mean it returns 0?
FROM tablename is superfluous here; the most recent AUTO_INCREMENT value
is maintained on a per-connection basi
://www.abti.cc
717.464.2970
Filter Lovin: sql, database, query
-Original Message-
From: Billy Passauer [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 10:18 AM
To: Dave Carter
Subject: RE: LAST_INSERT_ID Issues
> -Original Message-
> From: Dave Carter [mailto:[EMAIL PRO
Hello Dave,
If your auto-incrementing field in your table are Account_ID for exemple,
try :
Select Account_ID From tablename Where Account_ID = LAST_INSERT_ID();
This work fine for me
Bye
Ghislain Proulx
Web Programmer
Groupe Ordimax
http://www.ordimax.com
http://www.infoteck.qc.ca
> -O