
October 4th, 1999, 06:46 PM
|
|
Guest
|
|
Posts: n/a
Time spent in forums:
Reputation Power:
|
|
|
For some reason when I am doing a REPLACE query, the record I am sending to the server just gets added to the end of the database as a new record, rather than replacing the one with the same uniqueid. I've checked over my source very carefully, and I can't see the bug - it IS getting the right uniqueID, it just refuses to REPLACE it.
REPLACE into users (name,email,id) VALUES ('Nice Guy','nil@nil.nil',42);
Why would this not replace record ID 42? the 'id' field is set to auto_increment primary_key.
This is driving me insane. Any help out there?
Gabe
------------------
>>>---------->
|