ADO and COM contants
b.ambrosius at hccnet.nl
Mon Mar 1 16:32:58 CET 2004
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
understands. But there is no Null and no Nothing constant. I'll try your
and use None.
Douglas Savitsky mailed me saying that they should show up as
and win32com.client.constants.Nothing. At least the should be in the file
generates. They don't.
Roger Upole <rupole at hotmail.com> schreef in berichtnieuws
4040e17c_1 at 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.
> "Boba" <b.ambrosius at hccnet.nl> wrote in message
> news:403e4207$0$12847$3a628fcd at reader1.nntp.hccnet.nl...
> > Hi,
> > I'm using python as the language in ASP pages to query a database ussing
> > com interface. I want to do a parameter query and I have to use
> > like Null and Nothing. Does anyone know how to use the constants in
> > 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