Hope I can describe it clearly...
I defined a custom type named NormalDate,which used to convert Integer Type
in Oracle to String Date.
if I run the statement below in myproject.tests.model I can get what I want
successfully.
crew = DBSession.query(CrewMember).from_statement(text("SELECT * from
crew_member where " +
"rtrim(crew_member.lastname)
|| rtrim(crew_member.firstname) " +
" like '%" + crew_name +
"%'", typemap = {'birthday' : NormalDate})).first()
but if I run the same statement in myproject.controllers ,the (typemap) not
work..the birthday attribution is still Integer type.
I'm sure they're the same..the same DBSession..the same query...the same
text() method
what's wrong with it on earth....?
any suggestions is welcome.~
--
Rita Liang
--
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en.