Thanks for the thoughts Zach.
It is definitely a table, not a view.
We did try pasting on of the sql staements into our interface, and
the update worked fine.
This means the actual syntax is correct and the table is up-dateable.
Just can't get it to work from within php...
steve
On Dec 8, 2008, at 4:04 PM, Zachary Kent wrote:
I would be sure that the "table" that you are trying to update is an
actual table and not a view. Also, as someone else suggested, put a
breakpoint in your code where the final sql query string is created,
copy that query and run it against the db using Management Studio.
You will get an error message there if there is one.
Zach
On Wed, Nov 19, 2008 at 10:04 AM, steve miller <[EMAIL PROTECTED]>
wrote:
Hi all,
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.
We have looked at the table in every way we know how to look, and
we can't
find anything that would stop php from doing updates.
The table is part of a purchased application and is a very
important one, so
we are wondering if there could be some restrictions defined
somewhere.
Any thoughts on where to look?
Any special log somewhere that might tell us why the updates
aren't working?
Any help appreciated.
steve
____ 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.
