problem with primary key

2000-07-12 Thread gregg Kachel
Hi, haveing a crisis here. Everything was working fine earlier, now all of a sudden when I try to do an update on my membership page I get the following error. SQL operation updated no rows. The SQL operation affected no rows.Either the Key value has changed or the row has been deleted. The pri

RE: problem with primary key

2000-07-12 Thread Mark Warrick
: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- > -Original Message- > From: gregg Kachel [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 12, 2000 9:07 AM > To: [EMAIL PROTECTED] > Subjec

Re: problem with primary key

2000-07-12 Thread Daslweb - Greg
Please check the database to see if empty. - Original Message - From: "gregg Kachel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 12, 2000 9:06 AM Subject: problem with primary key > Hi, haveing a crisis here. Everything was working fin

RE: problem with primary key

2000-07-13 Thread Anthony Geoghegan
Hi Greg, Do you have an index set besides your primary key? |SQL operation updated no rows. |The SQL operation affected no rows.Either the Key value has |changed or the |row has been deleted. | |The primary key is id, and I can't figure out why it suddenly |would stop Regards, Anthony Geoghega

Re: problem with primary key

2000-07-13 Thread Heather Haindel
Double check that your record actually exists. select id from table where id=x (where x is the id you are trying to update) --- gregg Kachel <[EMAIL PROTECTED]> wrote: > Hi, haveing a crisis here. Everything was working > fine earlier, now all of > a sudden when I try to do an update on my memb