steve wrote... We are using php to connect to a local MS SQL database, and all seems to be fine. We are connecting to several tables within the same database, and are able to insert, update, delete, etc. However, there is one table that refuses to let us update, and we can not figure out why.
We get no errors from the script, but no records updated. If I echo out the sql statement, connect to the database with Access as the same user, and copy/paste the query into Access, the update works. Tim responds: One thing you might check is if the table in question has a primary key. In some situations the lack of a primary key will prevent DBMSs from updating rows (i.e. it doesn't have any way to lock the record). This problem usually doesn't throw an error (speaking from experience). ____ The WDVL Discussion List from WDVL.COM ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.