I got these imported tables from an external source so I need to
access the data using connection.
The problem I have is getting at the data in more than 1 table with
one dict the pure sql call would be something like
select * from yw_basics ywb left join yw_next ywn on ywb.id = ywn.id
where ywn.field = 0
def dictfetchall(cursor):
desc = cursor.description
return [
dict(zip([col[0] for col in desc], row))
for row in cursor.fetchall()
]
def secondhand(request):
from django.db import connection, transaction
cursor = connection.cursor()
cursor.execute("SELECT * from yw_basics")
stuff = dictfetchall(cursor)
I tried adding the sql call above into the cusor.execute and failed
miserably so any clues would be gratefully received.
--
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.
