Syntax error in update query vb 6

[case81]

hey all,

im getting a syntax error for this query:

sqlupdate = "UPDATE teams SET day='yes' WHERE tid=" & teamid
rsTeams.open sqlstr,dbcon

any ideas as to what could be causing this? im confused.
Thanks

 

[MikeCox]

Did you try putting ur field names in brackets? Your field 'day' may be a reserved word somewhere...

sqlupdate = "UPDATE teams SET [day]='yes' WHERE [tid]=" & teamid

Also, I'm assuming 'tid' is a numeric field, not text cuz you left the quotes off.

HTH!

~Mike
Any man willing to sacrifice liberty for security deserves neither liberty nor security.

-Ben Franklin

 

[case81]

Thanks Mike,

That didnt work but i've found a work around, thanks for replying though