Tom Burdick wrote: > Ok, here's a small test. It actually works fine when using sqlite, but > not when using postgresql. I want it to work with postgresql! > > This probably helps more than the description above. > > http://www.pylonshq.com/pasties/fe6a2857f3f72d499914caabce0d41bc > > -Tom > > On Nov 23, 10:33 am, Tom Burdick <thomas.burd...@gmail.com> wrote: > >> I would like to present my users a simple search box that searches a >> table. >> >> I have issues getting DataError when using the text input and trying >> to do filter against a column that is an integer only column. >> >> I want to have some code that takes a particular sqlalchemy column >> object and attempts to convert a string to the column type so that it >> can be used for filtering. Is there some way of doing this? >> >> I tried something like... (key word is like here, I know it probably >> isn't exactly correct) >> >> myval = '10' >> myval = mytable.c.some_id.type(myval) >> >> I get an exception DataError. >> >> I don't really understand how I could do what I want with pure >> introspection like I do now. >> >> -Tom >>
You can use sqlalchemy.cast() to coerce the type on the DB side: coerced_teststr = cast(teststr, column.type) records = session.query(History).filter(column==coerced_teststr) -Conor -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=.