Re: Any SELECT returns no results via Django

On Dec 20, 1:41 am, Gloria W <[EMAIL PROTECTED]> wrote: > I am boggled. A SELECT from the MySql command line works just fine. > But within Django, it returns nothing. It doesn't matter what SQL > statement I issue. > > Here is my syntax: > > from django.db import connection > cursor = connect

Re: Any SELECT returns no results via Django

On Dec 20, 1:41 am, Gloria W <[EMAIL PROTECTED]> wrote: > I am boggled. A SELECT from the MySql command line works just fine. > But within Django, it returns nothing. It doesn't matter what SQL > statement I issue. > > Here is my syntax: > > from django.db import connection > cursor = connect

Re: Any SELECT returns no results via Django

More info on this: I am connecting to the db via an ssh tunnel. In the settings-*.py files, I use DATABASE_HOST = '127.0.0.1' Works like a charm, except with the connection module. It is probably not connecting. Help! Gloria On Dec 19, 7:41 pm, Gloria W <[EMAIL PROTECTED]> wrote: > I am boggled.

Any SELECT returns no results via Django

I am boggled. A SELECT from the MySql command line works just fine. But within Django, it returns nothing. It doesn't matter what SQL statement I issue. Here is my syntax: from django.db import connection cursor = connection.cursor() cursor.execute("use editorial_production_2007_12_14; SEL