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 <mbuckn...@usgs.gov> wrote:
> 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 <dmitry.ma...@gmail.com> wrote:
>
>
>
>
>
>
>
> > 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 <mbuckn...@usgs.gov> wrote:
>
> > > I'm having another strange problem. I'm executing SQL statements
> > > directly rather than using the ORM and it is working fine except when
> > > I query one particular view. Then the query returns nothing. I can
> > > execute the same query from python by using the cx_Oracle module
> > > directly and it returns what I expect. Below is an example of what I'm
> > > doing in the Django code (within a view):
>
> > > cursor = connection.cursor()
> > > cursor.execute('SELECT account_number FROM vw_billed_summary_fact
> > > WHERE ippa=\'col11-emnj00-1147\'')
>
> > > This should produce a single row and instead produces no rows. I've
> > > tried using the COUNT aggregate to return the number of rows and this
> > > also returns zero. I don't get errors ... just no data.
>
> > > If I run a little python script that creates the connection directly
> > > using cx_Oracle and execute the query I get the expected result.
>
> > > Note that queries on other views and tables in the database work. Any
> > > thoughts on what I'm doing wrong?
>
> > > Thanks.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
