I solved it thanks for all your help though.
On Monday, July 14, 2014 9:44:31 AM UTC-6, G Z wrote:
>
> Thomas,
>>
>
> We are using an oracle database setup, we have a development database and
> a production database, the production database is for billing.
> The databases have the sane TNS resolver name of DB1. To test that it was
> using the correct settings.py file I removed the database information
> from it and it is using the settings.py file that I thought it was.
> However when I log into the development database and run the query im using
> with
> django it will return what im seeing on my django page although my django
> settings file is pointed to my other database and I even have to use the
> login associated
> with the production database, the weird part is that the data returned is
> still the development database. I'm running in debug mode, manage.py
> runserver. However the production database
> right now has no write privileges only read privileges so that should not
> be affecting the query. I even output the exact query that im using to the
> webpage and run seperately in each database
> it returns the correct data when im manually logged into the production
> database. The app was first synced on the development database.
>
> select customer_name,
> substr(decode(vcd_managed,'Y',vm_name,'N',vm_group_name || ' ' ||
> vm_display_name),1,100) vm_name, cpu_ghz_hours,ram_gb_hours, guest_os from
> customers a, vm_groups b, vms c, vm_compute_usage_histories d,
> vm_compute_histories e, guest_os f where a.customer_id = b.customer_id and
> b.vm_group_id = c.vm_group_id and c.vm_id = d.vm_id and trunc(d.datetime) =
> to_date('01-Jun-2014', 'DD-MON-YY') and a.customer_id != 24 and inactive =
> 'N' and cpu_ghz_hours > 0 and e.datetime = (select max(datetime) from
> vm_compute_histories g where c.vm_id = g.vm_id) and e.vm_id = c.vm_id and
> e.guest_os_id = f.guest_os_id order by 1,2
>
> there is the query that im running.
>
> when i sync the db it syncs just fine. I'm not sure how this is even
> possible.
>
--
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/1c216d00-bcd6-475e-8c2d-152721defda5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
