Hi Tim, I'll check, but I'm almost positive there is a primary key because this is a main "Customer" table which identifies all the important info about the clients.
steve On Nov 20, 2008, at 9:35 AM, Furry, Tim wrote: > 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] > dl.sparklist.com or > use the web interface http://e-newsletters.internet.com/ > discussionlists.html/ > Send Your Posts To: [email protected] > 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. > ____ 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: [email protected] 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.
