Update Database

[ldoodle]

Nice easy one (if possible).

How would I put the following code on one line?

objConn.Execute "UPDATE [tblStyleSheet]" & " SET [LoginDate] = '" & strDate & "'" & " WHERE [UserName] = '" & strUserName & "';"
objConn.Execute "UPDATE [tblStyleSheet]" & " SET [LoginTime] = '" & strTime & "'" & " WHERE [UserName] = '" & strUserName & "';"

Thanks very much/...

[chrismartz]

objConn.Execute "UPDATE [tblStyleSheet] SET [LoginDate] = '" & strDate & "', [LoginTime] = '" & strTime & "' WHERE [UserName] = '" & strUserName & "';"

[Bullschmidt]

And for a related link:

Classic ASP Design Tips - Search Criteria on Multiple Fields
http://www.bullschmidt.com/devtip-searchcriteria.asp