On Sep 27, 2007, at 4:11 PM, Eric N wrote:
> > I'm wondering if SqlAlchemy is quoting the parameter when it is bound > or if anyone has any other suggestions as to why I am not getting any > results. we're not quoting anything when its bound...what gets returned from convert_bind_param is what gets sent as a bind param to cursor.execute (). your custom type class seems fine. what you should do here first is make a short program using DBAPI only (which DBAPI are you using ? the three available for MS-SQL vary widely in their functionality), and try to get the query to work using a straight cursor.execute(). there could be issues with comparisons to binary fields or with the DBAPI's ability to bind a binary field; a call to setinputsizes() may even be needed. once its determined exactly what your DBAPI needs (or if its possible at all). any additional data massaging needed on the SQLAlchemy side can then be addressed. as a last resort you can inject direct text into a SQL statement using a string...with ORM it would look like query.filter ("section_OID=0x08C82B7C6A844743") . --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---