Re: [GENERAL] Suggestion for parameterized queries

2005-03-01 Thread Sebastien FLAESCH
Richard Huxton wrote: Sebastien FLAESCH wrote: Hi, Parameterized queries (PREPARE/EXECUTE), is a great thing, but it would even be better if the DECLARE CURSOR could use a PREPAREd statement, to declare a "server-side" cursor with a parameterized query, to use the benefits of DECLAREd cursors (n

Re: [GENERAL] Suggestion for parameterized queries

2005-02-28 Thread Richard Huxton
Sebastien FLAESCH wrote: Hi, Parameterized queries (PREPARE/EXECUTE), is a great thing, but it would even be better if the DECLARE CURSOR could use a PREPAREd statement, to declare a "server-side" cursor with a parameterized query, to use the benefits of DECLAREd cursors (no fetching of all the

[GENERAL] Suggestion for parameterized queries

2005-02-28 Thread Sebastien FLAESCH
Hi, Parameterized queries (PREPARE/EXECUTE), is a great thing, but it would even be better if the DECLARE CURSOR could use a PREPAREd statement, to declare a "server-side" cursor with a parameterized query, to use the benefits of DECLAREd cursors (no fetching of all the result set on the client, us

[GENERAL] Suggestion for parameterized queries

2005-02-28 Thread Sebastien FLAESCH
Hi, Parameterized queries (PREPARE/EXECUTE), is a great thing, but it would even be better if the DECLARE CURSOR could use a PREPAREd statement, to declare a "server-side" cursor with a parameterized query, to use the benefits of DECLAREd cursors (no fetching of all the result set on the client