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 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=.