I'm not sure how to check this. There are many other tables and views
in the database which I have no trouble retrieving data from. I can
use SQL Developer to execute the query on the view using the same
username, password, and database name. When I used cx_Oracle directly,
I am creating the connec
I'm starting to doubt this is a Django issue. Double check that you
are connecting to the database/schema you *think* you are connecting
to and you are using the use account you *think* you are using :)
D.
On Oct 19, 11:46 am, msbuck wrote:
> I just tried it and it doesn't. If I try an aggregat
I just tried it and it doesn't. If I try an aggregate query such as
using COUNT(account_number) without the Where clause, I get a row with
0 in it (there are thousands of account_numbers).
Thanks for the suggestion.
On Oct 19, 1:30 pm, dmitry b wrote:
> see if a pamaterized query works:
>
> c
see if a pamaterized query works:
cursor.execute('SELECT account_number FROM vw_billed_summary_fact
WHERE ippa=%s', ['col11-emnj00-1147'])
d.
On Oct 19, 8:25 am, msbuck wrote:
> I'm having another strange problem. I'm executing SQL statements
> directly rather than using the ORM and it is wor
4 matches
Mail list logo