Hi, I'm using SA 0.4.6 and I'm having trouble using the result of a database function / stored procedure in an UPDATE statement (being constructed with SQL expression lang). This happens to be for using PostGIS columns; however, that is not relevant to the problem here. I have tried doing some searching on this in the manual and in user group, but have not found an answer.
A simplified version of my python code looks like this: mytable.update(mytable.c.id==idvar, {'geocolumn': func.GeomFromText(wkt, 4326)}) The function is being quoted and some other weird stuff is happening, such that I have result SQL that looks like: UPDATE mytable SET geocolumn = E'GeomFromText(''GeomFromText(:GeomFromText_1, :GeomFromText_2)'', 4326)' WHERE id = 1 So, without having looked into this more deeply (within SA), it would appear that I need to tell SA to treat my parameters to the func as literals (?) and somehow tell it to not escape the function itself (?)., Is there a better / correct way to do this? I'd be happy to write up some instructions for the "Functions" section of the manual if there is a solution or best-practice for this (will need some guidance on how to submit that documentation). Thanks in advance! Hans --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---