On Wed, 2007-06-06 at 20:55 +0200, Dieter Maurer wrote:
> >As Marc-Andre pointed out, parameter binding is only for
> >scalar values.
>
> Then it must raise an exception but not behave inconsistently (such
> as adding a ',' for one element lists but not adding a comma for lists
> with more than 1
Carsten Haese wrote at 2007-6-5 13:40 -0400:
>On Tue, 2007-06-05 at 19:21 +0200, Dieter Maurer wrote:
>> Roger Doger wrote at 2007-6-4 09:46 -0500:
>> >The following use of the API with MySQL works fine
>> >
>> >> items = [1, 2]
>> >> execute('SELECT * from table1 WHERE field1 IN %s', (items,))
>>
On Tue, 2007-06-05 at 19:21 +0200, Dieter Maurer wrote:
> Roger Doger wrote at 2007-6-4 09:46 -0500:
> >The following use of the API with MySQL works fine
> >
> >> items = [1, 2]
> >> execute('SELECT * from table1 WHERE field1 IN %s', (items,))
> >resultant query string: SELECT * from table1 WHERE
Roger Doger wrote at 2007-6-4 09:46 -0500:
>The following use of the API with MySQL works fine
>
>> items = [1, 2]
>> execute('SELECT * from table1 WHERE field1 IN %s', (items,))
>resultant query string: SELECT * from table1 WHERE field1 IN ('1', '2')
>
>By contrast, the following yields the messag
On 2007-06-04 16:46, Roger Doger wrote:
> The following use of the API with MySQL works fine
>
>> items = [1, 2]
>> execute('SELECT * from table1 WHERE field1 IN %s', (items,))
> resultant query string: SELECT * from table1 WHERE field1 IN ('1', '2')
>
> By contrast, the following yields the mess
The following use of the API with MySQL works fine
> items = [1, 2]
> execute('SELECT * from table1 WHERE field1 IN %s', (items,))
resultant query string: SELECT * from table1 WHERE field1 IN ('1', '2')
By contrast, the following yields the message "error in your SQL syntax"
> items = [1]
> exec
