[DB-SIG] query - prepared statment

2006-02-10 Thread python eager
Hi All,     How to use prepared statment. Can u give one example  for insert, delete and update statments. please.     Thank you     regards  Python Eager Yahoo! Mail Use Photomail to share photos without annoying attachments.___ DB-SIG maillist - D

Re: [DB-SIG] query - prepared statment

2006-02-10 Thread Carsten Haese
On Fri, 2006-02-10 at 04:07, python eager wrote: > Hi All, > > How to use prepared statment. Can u give one example for insert, > delete and update statments. please. The DB-API standard does not define a separate method for preparing a statement. Preparing the statement is part of the cur

Re: [DB-SIG] reg cursor.fetchall()

2006-02-10 Thread Andy Dustman
On 2/8/06, Andy Todd <[EMAIL PROTECTED]> wrote: > Sadly cx_Oracle doesn't offer different cursor classes like, for > instance, MySQLdb; > > http://dustman.net/andy/python/MySQLdb_obsolete/doc/MySQLdb-4.html#usage > > So you can't refer to cursor results as dictionaries or other sequence > types.

Re: [DB-SIG] query - prepared statment

2006-02-10 Thread M.-A. Lemburg
Carsten Haese wrote: > On Fri, 2006-02-10 at 04:07, python eager wrote: >> Hi All, >> >> How to use prepared statment. Can u give one example for insert, >> delete and update statments. please. > > The DB-API standard does not define a separate method for preparing a > statement. Preparing

Re: [DB-SIG] query - prepared statment

2006-02-10 Thread David Rushby
--- "M.-A. Lemburg" <[EMAIL PROTECTED]> wrote: > Perhaps we should something like this to the list of standard > DB-API extensions ?! > > This is what we have in mxODBC 2.1: > > cursor.prepare(operation) > >Prepare a database operation (query or command) statement for >later execution an

Re: [DB-SIG] query - prepared statment

2006-02-10 Thread Carsten Haese
On Fri, 10 Feb 2006 23:15:36 +0100, M.-A. Lemburg wrote > Carsten Haese wrote: > > Apparently cx_Oracle implements a non-standard prepare() method that > > prepares a query string for later execution by either passing the same > > string or None to execute(). > > Perhaps we should something like t

Re: [DB-SIG] query - prepared statment

2006-02-10 Thread Carsten Haese
On Fri, 10 Feb 2006 16:38:09 -0800 (PST), David Rushby wrote > --- "M.-A. Lemburg" <[EMAIL PROTECTED]> wrote: > > Perhaps we should something like this to the list of standard > > DB-API extensions ?! > > > > This is what we have in mxODBC 2.1: > > > > cursor.prepare(operation) > > > >Prepar