RE: [PHP-DB] Can't Insert more than 1 record
| From: | Alexa Kirk | Date: | Fri, 04 Apr 2003 15:50:55 +0000 |
| Subject: | RE: [PHP-DB] Can't Insert more than 1 record | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26833@lists.php.net to get a copy of this message | ||
If you are violating a primary key, try creating a sequence, and then
passing this sequence name (i.e. nID.NextVal) as your parameter in the
values of your query. This will automatically give you a new unique
number in the sequence you created.
Lex
-----Original Message-----
From: Keven Jones [mailto:keven_jones@hotmail.com]
Sent: Thursday, April 03, 2003 5:18 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Can't Insert more than 1 record
Hello All,
I am having a problem inserting records
into my Database. I am passing fields
from a FORM to my php program that adds
1 record to my DB. It will create the
first attempt just fine, however any
attempt after the 1st fails. I have
to delete the existing row in order
to add a new record.
Anyone know what I am doing incorrectl?
KJ
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php