|
query: msg#00073python.db.psycopg.devel
i'm migrating from pypgsql to psycopg, and psycopg has an issue with this query string. curpg.execute("""SELECT till_name,till_float FROM till_config JOIN transactions USING (id) WHERE for_venue = %s""",(Venue)) the error is as follows psycopg.ProgrammingError: ERROR: syntax error at or near "Cow" at character 102 SELECT till_name,till_float FROM till_config JOIN transactions USING (id) WHERE for_venue = Mad Cow now i understand why it's erroring on that sql, but why isn't psycopg quoting it for me? |
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: sslmode: 00073, jerickso-+gj3SL0yWyjQT0dZR+AlfA |
|---|---|
| Next by Date: | Re: query: 00073, Matt Goodall |
| Previous by Thread: | Freeze and Release?i: 00073, Peter Fein |
| Next by Thread: | Re: query: 00073, Matt Goodall |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |