Re: [PHP-DB] SQLite PRIMARY KEY.

2004-01-30 Thread Stuart Gilbert
Well, it appears I tried everything except JUST the word NULL.
Sorry for wasting your time.
Regards,
Stuart Gilbert.
Stuart Gilbert wrote:
I'm trying to get my PHP code to INSERT a new row and have the PRIMARY 
KEY field automatically set to the next available integer.
I read, somewhere, that if I send null as the primary key value then 
SQLite will automatically incrememnt it for me.

I've tried sending all sorts of things that I thought might work, but as 
yet I have not been able to get it right.

Can someone please help me?

Regards,
Stuart Gilbert.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[PHP-DB] SQLite PRIMARY KEY.

2004-01-30 Thread Stuart Gilbert
I'm trying to get my PHP code to INSERT a new row and have the PRIMARY 
KEY field automatically set to the next available integer.
I read, somewhere, that if I send null as the primary key value then 
SQLite will automatically incrememnt it for me.

I've tried sending all sorts of things that I thought might work, but as 
yet I have not been able to get it right.

Can someone please help me?

Regards,
Stuart Gilbert.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php