Re: Not able to select from Oracle view

On Mon, Mar 9, 2009 at 3:06 PM, Brandon Taylor wrote: > > Hi Alex, thanks for the response. > > I see that Django is trying to select a property that doesn't exist > from this view... > > SELECT "LU_CSU_CODE"."ID", "LU_CSU_CODE"."DEPARTMENT", > "LU_CSU_CODE"."TITLE" FROM "LU_CSU_CODE" ORDER BY > "

Re: Not able to select from Oracle view

Hi Alex, thanks for the response. I see that Django is trying to select a property that doesn't exist from this view... SELECT "LU_CSU_CODE"."ID", "LU_CSU_CODE"."DEPARTMENT", "LU_CSU_CODE"."TITLE" FROM "LU_CSU_CODE" ORDER BY "LU_CSU_CODE"."DEPARTMENT" ASC There is no field LU_CSU_CODE.ID Here

Re: Not able to select from Oracle view

On Mon, Mar 9, 2009 at 2:38 PM, Brandon Taylor wrote: > > Hi everyone, > > Is there something special I need to know in order to select records > from a view in Oracle? My user has select permissions on the schema in > question. > > When I output the SQL from the connection, everything looks in or