Dennis,
FWIW, Your test script runs ok for me with sqlite and the latest svn
trunk. You might want try running it with the trunk+PG.
Sean
On Mon, 2006-05-08 at 16:45 -0600, Dennis Muhlestein wrote:
> On 5/8/06, Michael Bayer <[EMAIL PROTECTED]> wrote:
> im not able to reproduce this problem, i can send unicode()
> into
> get_by or SQL constructs directly no problem. i also dont
> immediately see anything that could cause it to construe a
> unicode
> string as anything other than a literal value (unless the
> unicode()
> function on your end is being clobered by something?) can you
> attach
> a fully working test case ?
>
> I'm using Postgresql 8.1.3 on Linux. The attached test case produces
> the following output on both of my machines:
>
> ____SNIP_____
> > python test.py
> working: dennis
> Traceback (most recent call last):
> File "test.py", line 30, in ?
> t=Test.get_by(username=unicode('dennis'))
> File "build/bdist.linux-i686/egg/sqlalchemy/mapping/mapper.py", line
> 258, in get_by
> File "build/bdist.linux-i686/egg/sqlalchemy/mapping/query.py", line
> 58, in get_by
> File "build/bdist.linux-i686/egg/sqlalchemy/mapping/query.py", line
> 137, in select_whereclause
> File "build/bdist.linux-i686/egg/sqlalchemy/mapping/query.py", line
> 213, in _select_statement
> File "build/bdist.linux-i686/egg/sqlalchemy/sql.py", line 473, in
> execute
> File "build/bdist.linux-i686/egg/sqlalchemy/sql.py", line 378, in
> execute
> File "build/bdist.linux-i686/egg/sqlalchemy/sql.py", line 355, in
> execute
> File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line 646, in
> execute_compiled
> File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line 641, in
> proxy
> File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line 692, in
> execute
> File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line 712, in
> _execute
> sqlalchemy.exceptions.SQLError: (ProgrammingError) ERROR: column
> "dennis" does not exist
>
> SELECT test.username AS test_username, test.id AS test_id
> FROM test
> WHERE test.username = dennis
> LIMIT 1 'SELECT test.username AS test_username, test.id AS test_id
> \nFROM test \nWHERE test.username = %(test_username)s \n LIMIT
> 1' {'test_username': u'dennis'}
> _____END SNIP_________
>
> Let me know if you need any additional information about my
> environment or library versions. (SQLAlchemy 0.1.7)
>
> Thanks
> -Dennis
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
