ADO and COM contants

Boba b.ambrosius at hccnet.nl
Thu Feb 26 14:05:44 EST 2004


Hi,
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 =
req.documentElement.selectSingleNode("//request_parDatBegin").text
 qryParm.Value = Null  # at least sometimes
 cmdQuery.Parameters.Append(qryParm)
#---------------
end code

Bob





More information about the Python-list mailing list