Jim St.Cyr jstcyr at mediaone.net
Sat Feb 16 00:56:06 EST 2002

• Previous message (by thread): DCOracle syntax question
• Next message (by thread): Directed Acyclic Graph Representation
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

---

I have a query of the form

select * from table where key = 'key' and date = (select max(to_char(date))
from table where key = 'key')

Through SQL*Plus this executes fine.  When executing through DCOracle I get
an empty result.  I've tried both tag = 'query' and cursor.execute(query).
I think that either the subquery or the inline quotes is throwing things off
but am at a loss.

Any pointers would be appreciated.

Thanks.

Jim

---

• Previous message (by thread): DCOracle syntax question
• Next message (by thread): Directed Acyclic Graph Representation
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

---

More information about the Python-list mailing list