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: 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.
>
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.