ADO and COM contants

Boba b.ambrosius at
Thu Feb 26 20:05:44 CET 2004

I'm using python as the language in ASP pages to query a database ussing the
com interface. I want to do a parameter query and I have to use constants
like Null and Nothing. Does anyone know how to use the constants in Python?

Part of the code:
 cmdQuery = win32com.client.Dispatch("ADODB.Command")
 cmdQuery.ActiveConnection = cnn
 cmdQuery.CommandText = "aStoredQuery"
 cmdQuery.CommandType = adCmdStoredProc

 # parameter: startdate
 qryParm = win32com.client.Dispatch("ADODB.Parameter")
 qryParm.Name = "parDateStart"
 qryParm.Type = adDBDate
 tmpDate =
 qryParm.Value = Null  # at least sometimes
end code


More information about the Python-list mailing list