Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
marting
Starting Member
1 Post |
 Posted - 2004-09-24 : 08:44:56
|
| Hi GuysCan anyone help with this annoying error following a pretty simple update statement. This is my sql statement: SqlText = "UPDATE Owners SET Owners_Username = '"&a&"', SET Owners_password = '"&b&"', SET Owners_pin = '"&c&"', SET Owners_Firstname = '"&d&"', SET Owners_Lastname = '"&e&"', SET Owners_Coname = '"&f&"', SET Owners_Cotype = '"&g&"', SET Owners_CoUrl = '"&h&"', SET Owners_paymentname = '"&i&"', SET Owners_paymentadd1 = '"&j&"', SET Owners_paymentadd2 = '"&k&"', SET Owners_paymenttown = '"&l&"', SET Owners_paymentCounty = '"&m&"', SET Owners_paymentCounty = '"&n&"', SET Owners_add1 = '"&o&"', SET Owners_add2 = '"&p&"', SET Owners_Town = '"&q&"', SET Owners_County = '"&r&"', SET Owners_postcode = '"&s&"', SET Owners_Daytime = '"&t&"', SET Owners_Evening = '"&u&"', SET Owners_Email = '"&v&"' WHERE Owners_id = '"&z&"';"and this is the error I'm getting:Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement. /yourstrolley/ownersdetails_update.asp, line 53I really can't see what the problem is but I'm sure it just takes an outsider to see it clearly! Thanx in advance.Martin |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-09-24 : 09:11:29
|
you don't need SET for every column:SET Owners_Username = '"&a&"', Owners_password = '"& ...Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
|
|
UPDATE statement