Why can't use cursor.nextset() in adodbapi package?

2005-01-24 Thread nightmarch
I want use crsr.nextset() , But I got errors like following: >>> connStr = "Provider=MSDAORA.1;Password=jmpower;User ID=jmpower;Data Source=jmgis_agps3;Persist Security Info=True" >>> import adodbapi >>> conn= adodbapi.connect( connStr ) >>> crsr = conn.cursor() >>> sql = "select * from wjtmp" >>

I want update one record using ADO,but I can't ,why?

2005-01-24 Thread nightmarch
I want update one record ,but I can't ,why? code like following: ##- import win32com.client as wc def main(): conn = wc.Dispatch(r'ADODB.Connection') rs = wc.Dispatch(r'ADODB.Recordset') connStr = "Provider=MSDAORA.1;Password=jm

Re: Why can't use cursor.nextset() in adodbapi package?

2005-01-24 Thread nightmarch
Mon, 24 Jan 2005 17:00:39 GMT, Dennis Lee Bieber <[EMAIL PROTECTED]> wrote: > On Mon, 24 Jan 2005 17:18:05 +0800, nightmarch <[EMAIL PROTECTED]> > declaimed the following in comp.lang.python: > > > >>> sql = "select * from wjtmp" > > >>&

Re: I want update one record using ADO,but I can't ,why?

2005-01-25 Thread nightmarch
sg like following: ##errorMsg On Tue, 25 Jan 2005 10:25:00 -0800, Robert Brewer <[EMAIL PROTECTED]> wrote: > nightmarch wrote: > > I want update one record ,but I can't ,why? > > > > code like following: > > > > ##