just some ideas.
> Here is an example of a properly interpreted row using the
> dbutils.OID class:
> " 08C82B7C6A844743::SDRAM::64Mb::Marketing::0C::70C::DC Electrical
> Characteristics::::"
>
> Here is the binding statement being generated by SqlAlchemy:
> 2007-09-27 13:32:12,444 INFO sqlalchemy.engine.base.Engine.0x..cL
> {'spec_section_symbols_section_OID': '\x08\xc8+|j\x84GC'}
> I know in Perl I have to format the query without quotes or I don't
> get any results. Something like this:
> "select * from table where section_OID=0x08C82B7C6A844743"
the dict shows that your value is sent/assumed a raw byte-string,
while what u're suggesting in the perl example is that the server
expects a sort of hexadecimal longint representation. Are these
equivalent? maybe u need to convert from one to another?
> I am not receiving any type of error, just an empty result set. I
> have verified that the OID is being interpreted correctly by
> running an interactive sql statement on the interpreted value
> shown.
>
> 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.
insert one row via sqlalchey with OID=aabbccddeeff and see what u get.
may give u idea of what conversion happens on the way.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
