[sqlalchemy] Re: in_( bindparam(list) ) ?
On Oct 13, 2008, at 6:41 AM, [EMAIL PROTECTED] wrote:
why i cannot give in_() a bindparam?
q.filter( x.in_( somelistorset )) works
q.filter( x.in_( bindparam('somename') )) fails
...
File sqlalchemy/sql/expression.py, line 1368, in _in_impl
for o in seq_or_selectable:
TypeError: '_BindParamClause' object is not iterable
is this possible or not ?
or sending a list/tuple/iterable as bindparam-value is not supported?
is this a resend? I answered a week ago (hm, GG didnt
deliver ? )should be x.in_([bindparam('somename')])
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Re: in_( bindparam(list) ) ?
On Oct 13, 6:41 am, [EMAIL PROTECTED] wrote:
why i cannot give in_() a bindparam?
q.filter( x.in_( somelistorset )) works
q.filter( x.in_( bindparam('somename') )) fails
...
File sqlalchemy/sql/expression.py, line 1368, in _in_impl
for o in seq_or_selectable:
TypeError: '_BindParamClause' object is not iterable
is this possible or not ?
or sending a list/tuple/iterable as bindparam-value is not supported?
ciao
svil
Just wrap your bindparam with brackets.
Wayne
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Re: in_( bindparam(list) ) ?
On Oct 13, 10:21 am, Michael Bayer [EMAIL PROTECTED] wrote:
On Oct 13, 2008, at 6:41 AM, [EMAIL PROTECTED] wrote:
why i cannot give in_() a bindparam?
q.filter( x.in_( somelistorset )) works
q.filter( x.in_( bindparam('somename') )) fails
...
File sqlalchemy/sql/expression.py, line 1368, in _in_impl
for o in seq_or_selectable:
TypeError: '_BindParamClause' object is not iterable
is this possible or not ?
or sending a list/tuple/iterable as bindparam-value is not supported?
is this a resend? I answered a week ago (hm, GG didnt
deliver ? ) should be x.in_([bindparam('somename')])
I have to turn off the caching proxy for this group, you reply too
fast.
Wayne
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Re: in_( bindparam(list) ) ?
On Monday 13 October 2008 17:21:31 Michael Bayer wrote:
On Oct 13, 2008, at 6:41 AM, [EMAIL PROTECTED] wrote:
why i cannot give in_() a bindparam?
q.filter( x.in_( somelistorset )) works
q.filter( x.in_( bindparam('somename') )) fails
...
File sqlalchemy/sql/expression.py, line 1368, in _in_impl
for o in seq_or_selectable:
TypeError: '_BindParamClause' object is not iterable
is this possible or not ?
or sending a list/tuple/iterable as bindparam-value is not
supported?
is this a resend? I answered a week ago (hm, GG didnt
deliver ? )
didnt...
should be x.in_([bindparam('somename')])
but that is a list containing one param.
i want the whole list to be a parameter.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Re: in_( bindparam(list) ) ?
Michael Bayer wrote:
On Oct 13, 2008, at 10:58 AM, [EMAIL PROTECTED] wrote:
On Monday 13 October 2008 17:21:31 Michael Bayer wrote:
On Oct 13, 2008, at 6:41 AM, [EMAIL PROTECTED] wrote:
why i cannot give in_() a bindparam?
q.filter( x.in_( somelistorset )) works
q.filter( x.in_( bindparam('somename') )) fails
...
File sqlalchemy/sql/expression.py, line 1368, in _in_impl
for o in seq_or_selectable:
TypeError: '_BindParamClause' object is not iterable
is this possible or not ?
or sending a list/tuple/iterable as bindparam-value is not
supported?
is this a resend? I answered a week ago (hm, GG didnt
deliver ? )
didnt...
should be x.in_([bindparam('somename')])
but that is a list containing one param.
i want the whole list to be a parameter.
yeah does PG even support that ? im assuming PG
as ANY(array[])
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Re: in_( bindparam(list) ) ?
On Oct 13, 2008, at 10:58 AM, [EMAIL PROTECTED] wrote:
On Monday 13 October 2008 17:21:31 Michael Bayer wrote:
On Oct 13, 2008, at 6:41 AM, [EMAIL PROTECTED] wrote:
why i cannot give in_() a bindparam?
q.filter( x.in_( somelistorset )) works
q.filter( x.in_( bindparam('somename') )) fails
...
File sqlalchemy/sql/expression.py, line 1368, in _in_impl
for o in seq_or_selectable:
TypeError: '_BindParamClause' object is not iterable
is this possible or not ?
or sending a list/tuple/iterable as bindparam-value is not
supported?
is this a resend? I answered a week ago (hm, GG didnt
deliver ? )
didnt...
should be x.in_([bindparam('somename')])
but that is a list containing one param.
i want the whole list to be a parameter.
yeah does PG even support that ? im assuming PG
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
