... until the collector arrives ...

This "blog" is really just a scratchpad of mine. There is not much of general interest here. Most of the content is scribbled down "live" as I discover things I want to remember. I rarely go back to correct mistakes in older entries. You have been warned :)

2004-09-15

ADO and JScript

I had trouble trying to use a date parameter in a SQL statement using JScript and ADO.  Here is the answer:

var connection = new ActiveXObject("ADODB.Connection");
connection.ConnectionString = "Provider=...";
connection.Open();
var command = new ActiveXObject("ADODB.Command");
command.ActiveConnection = connection;
command.CommandText = "INSERT INTO ... VALUES (..., ?, ...)";
command.Parameters.Item(0).value = messageTime.getVarDate();

Blog Archive