I'm having trouble with django 1.6 running queries on a table I need to pull data from
When I run the following from shell CRMData.objects.filter(Incident_Date='2014-01-14') I get: DatabaseError: ORA-00904: "ODBC_EXTRACT_DAILY"."INCIDENT_DATE": invalid identifier I've run queries in sqlplus and the following works select * from odbc_extract_daily where incident_date='2014-01-14'; But the following doesn't select * from odbc_extract_daily where odbc_extract_daily.incident_date= '2014-01-14'; And returns the same DatabaseError: ORA-00904: "ODBC_EXTRACT_DAILY"."INCIDENT_DATE": invalid identifier I've had a look at core.py but can't for the life of me figure out how to change this behaviour - it's partially fatigue but it's making me pull my hair out!!! Please halp!! DatabaseError: ORA-00904: "ODBC_EXTRACT_DAILY"."INCIDENT_DATE": invalid identifier DatabaseError: ORA-00904: "ODBC_EXTRACT_DAILY"."INCIDENT_DATE": invalid identifier CRMData.objects.filter(Incident_Date='2014-01-14')CRMData.objects.filter(Incident_Date='2014-01-14') CRMData.objects.filter(Incident_Date='2014-01-14') CRMData.objects.filter(Incident_Date='2014-01-14') CRMData.objects.filter(Incident_Date='2014-01-14') -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/aef7df54-89a4-49f0-aee8-3ff994677d9f%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
