Hi I have been getting an error for the past few days in my UPDATE statement and I can't see where Im going wrong...any help would be great thanks...

MySql="Update Calendar Set booked = true, UID= " & Session("id") & ", treatment ='" & request.form("treatment") & "', Comments='" & request.form("comments") & "' Where id=" & id
my_conn.execute(MySql)

What error do you get exactly?

To help diagnosing the problem, try this:

MySql="Update Calendar Set booked = true, UID= " & Session("id") & ", treatment ='" & request.form("treatment") & "', Comments='" & request.form("comments") & "' Where id=" & id
Response.Write(MySql)
Response.End
my_conn.execute(MySql)

That outputs your SQL statement to the browser. Then copy and paste the statement in the query designer of your database, to see where it breaks.

If that doesn't help, can you post the outcome of the Response.Write statement?

Cheers,

Imar