ADO and COM contants

[Boba]

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

[Roger Upole]

You'll need to use makepy for the ADO library.
Once you create an instance of the object, the constants will
appear in win32com.client.constants, and then the code would
look like
cmdQuery.CommandType = win32com.client.constants.adCmdStoredProc

For null parameters, most of the time you can use None and win32com will
do the right thing.

hth
Roger

"Boba" <b.*********@hccnet.nl> wrote in message
news:40***********************@reader1.nntp.hccnet .nl...

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

[Boba]

Roger,

Thanks. You gave me more answer than I'd asked for. I think I solved the
problem with the
constants by adjusting the adovbs.inc file so that it contains constants
that python
understands. But there is no Null and no Nothing constant. I'll try your
suggestion
and use None.
Douglas Savitsky mailed me saying that they should show up as
win32com.client.constants.Null
and win32com.client.constants.Nothing. At least the should be in the file
that makepy
generates. They don't.

Bob Ambrosius
Roger Upole <ru****@hotmail.com> schreef in berichtnieuws
40********@127.0.0.1...

You'll need to use makepy for the ADO library.
Once you create an instance of the object, the constants will
appear in win32com.client.constants, and then the code would
look like
cmdQuery.CommandType = win32com.client.constants.adCmdStoredProc

For null parameters, most of the time you can use None and win32com will
do the right thing.

hth
Roger

"Boba" <b.*********@hccnet.nl> wrote in message
news:40***********************@reader1.nntp.hccnet .nl...

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