...

Syntax error in UPDATE statement

Brett Bretterso
11-15-2005, 09:16 PM
I'm building a massive employee database system in asp.net. I'm currently testing it and I got the error in the Title when I tried to run this query. But when I tried running it directly in my database rather than through my page it worked just fine. Any ideas?

update employees set fName='pizza', lName='head', rank='peon', payType='never', payRate=0, address='pizza hut', city='anytown', state='DC', zip=55555, pPhone='(555) 555-5555', sPhone='(555) 555-6666', email='pizzahead@pizzahut.com', current=TRUE where id=1

Brett Bretterson

Brandoe85
11-15-2005, 11:57 PM
You might want to try putting quotes around true, and square brackets around current, although i'm not sure in access, in Sql Server current is a reserved word:
[current] = 'TRUE'

Good luck;



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum