; [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
> -Original Message-
> From: Dave Carter [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 9:49 AM
> To: [EMAIL PROTECTED]
> Subject: LAST_INSERT_ID Issues
>
>
>
>
>
>
>
> This does not return any results
>
> SELECT LAST_INSERT_ID() F
This does not return any results
SELECT LAST_INSERT_ID() FROM tablename;
there is an indexed, auto-incrementing field in the table, but it refuses to
show any results. I don't understand the manual's text, so any help would be
appreciated.
Dave Carter
Chief Web Architect
Accelerated Busin
