Re: [cx-oracle-users] Prepared Statement

[Anthony T. <ant...@gm...>]

First,

cursor.prepare("select * from table where id = :id")

Then,

cursor.execute(None, id = 15)
cursor.execute(None, id = 16)

Or,

cursor.execute(cursor.statement, id = 15)
cursor.execute(cursor.statement, id = 16)

Hope that helps.

On Thu, Jul 31, 2008 at 6:27 AM, Daniel Sonnick <Dan...@ce...> wrote:
> Hi,
>
>
>
> I can't figure out how prepare works.
>
>
>
> When I have e query like select * from table where id = 15 and I want to use
> prepared statements, how do I do it?
>
>
>
> e.g. like this?
>
>
>
> Cursor.prepare("select * from table where id = :id")
>
> Cursor.execute("15")
>
> Cursor.execute("16")
>
>
>
> Or how dows it work ?
>
>
>
> Many thanks
>
>
>
> daniel
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>