Thanks for your quick answer.
This table has an auto-increment integer primary key, and still....
I am trying to recover by creating an identical table and transfering all the
data to the same. I hope it helps.
Egbert
DJ Anubis <[EMAIL PROTECTED]> wrote: Egbert Eissing a écrit :
> I have done some additional research on
> SELECT LAST_INSERT_ID();
> When I execute the select not from within Knoda, but from
> a mysql command line prompt it returns 11000+ '0's, i.e.
> a 0 for every record in the table. The problem is obviously with
> the mysql background database, and not with Knoda.
>
> Thanks for your answer.
> Egbert
Well, I only see this behaviour on tables without an integer auto
increment primary key.
With MySQL, as well as with SQLite3, only tables with an integer auto
increment primary key return a valid result.
Wgen using PostgreSQL, only tables with a serial integer type or with a
sequence attached can be queried to return equivalent results. (This is
what makes datanase abstractor authors have some headaches) :)
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Hk-classes-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
---------------------------------
Yahoo! Answers - Get better answers from someone who knows. Tryit now.-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Hk-classes-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
