Whats wrong in this SQL query?

[Fredde]

I'm a beginner to ASP/SQL and I just can't seem to figure out what's wrong with this SQL statement where I try to update the column "proj1" in the table "hours" with the integer "P1". I keep getting "SQL statment error"!?

sql = "UPDATE hours FIELDS (proj1) VALUE ('"&p1&"') WHERE (Ar="& Datepart("yyyy",Date) &" AND Week="& Session("Week&quot &" AND Namn='" & Session("Login&quot& "');"

/fredde

 

[Tim1]

Hiya Fredde,

The command you need is:
sql = "UPDATE hours
SET proj1 = p1
WHERE (Ar="&
Datepart("yyyy",Date) &" AND Week="& Session("Week&quot &" AND
Namn='" & Session("Login&quot& "');"

HTH

Tim