Update record without a form in Dreamweaver MX

I'm new to ASP so I'm using DWMX as a crutch. It created the db connection and recordset code for me and all I want to do is have the page update the db with the result of a variable.

In plain English, I'm trying to update a field called Score in the table quizOne with the results of the variable score where the username field matches the session variable MM_Username. The recordset is called update_score.

Based on other tutorials and forums, I tried this:



and also..



I get either interminated string constant errors, or expected end of statement, or expected ')' regardless of how I try to run this.

Any help would be greatly appreciated!

try this..

<%
Dim sql_update
sql_update = "update quizOne set score = '" & score & "'" & _
"where username = '" & Session("MM_Username") & "'"

update_score.Execute sql_update
%>

always check your quotes..

update_score("(update_score.Fields.Item("score").Value)") = " & score & "

Double quotes inside Double quotes!
try replacing the inner ones with ' (single quote)

Thanks for the tips. I tried the first method and it comes up with:
Object doesn't support this property or method: 'Execute'

I updated the MDAC and it still is coming up with that error. Any ideas?

try this..

<%
Dim sql_update
sql_update = "update quizOne set score = '" & score & "' " & _
"where username = '" & Session("MM_Username") & "'"

update_score.Execute sql_update
%>

always check your quotes.. <-- silly me
now i was the one you forgot the space between score & "' " & _ hehehe

Still gives me this..

Object doesn't support this property or method: 'Execute'

I think everything is right but it won't let me use that execute function it seems.

Hmm..

what object is update_score by the way?
is it a recordset or a connection object?

update_score is a recordset

dreamweaver sets it as a variable