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.
