faqts : Computers : Programming : Languages : PHP : Database Backed Sites : MSSQL

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

8 of 25 people (32%) answered Yes
Recently 4 of 10 people (40%) answered Yes

Entry

mssql "UPDATE [...] WHERE [...]" updates ALL records in my table!

Mar 21st, 2001 09:00
Jay Jimenez, Michael O\'Shea, Ben Udall,


Check your WHERE [...] clause...
you might have something there that is common to all the fields or an 
actual SQL error by improperly replacing a variable.
Those areusually where I mess up.
Hope this helps...
[email protected]