I would like to know what the code

[adamsoderqvist]

I would like to know what the code to update a DB should look like, using the objConnection.Execute command!

This is what I have to ecxecute a delete task:

Dim strSQL
strSQL = "DELETE FROM tblArtiklar WHERE ArtID=" & Request.QueryString("ArtID")

'Execute...
objConn.Execute strSQL

objConn.Close
Set objRS = Nothing

...but what should the UPDATE syntax be, using SQL commands?

 

[JuanitaC]

Update would look something like this:

strSQL = "UPDATE table SET column='" & value & "',"
strSQL = strSQL & " column='" & value & "'"
strSQL = strSQL & " WHERE column = '" & value & "'"

'Execute...
objConn.Execute strSQL


Remove the single quotes for values that are number types.

 

[dds82]

UPDATE table_name SET col1=value1, col2=value2, ...
WHERE [condition];

 

[adamsoderqvist]

Cheers!

 

[adamsoderqvist]

OK, when I run this:

strSQL = "UPDATE tblMember SET LastLogin=#" & Date() & "#, LoginTime='" & Time() & "' WHERE UserName= '" & strUserName & "'"

'Execute...
objConn.Execute strSQL

It works, BUT: the database sets the day as month, and the month as day resulting in that July 1st 2002 will be presented as January 7th 2002!! -Why is this? Could it have to do with the "#" signs? (they has to be there in one way or another...)

When I run the old code:

objRS("LastLogin") = Date()
objRS("LoginTime") = Time()
objRS.Update

...the date is returned/inserted into the DB, correctly.

What to do?

 

[Guest_imported]

strSQL = "UPDATE tblMember SET LastLogin=#"& Date &"#, LoginTime=#"& Time &"# WHERE UserName='"& strUserName &"';"


Time is # also ! not « ' »

 

[adamsoderqvist]

I know, tried that as well.... but no - doesn't work. The date is still messed up. Suggestions?
(Note that the "date-reversion" only occurs when I update using the UPDATE-command in SQL, not with "objRS.Update"!)