On 05/06/2018 11:05 PM, tango ward wrote:
Yes, my apologies.
May I also ask if there's a limitation for the number of timestamp with
timezone fields in a table?
On Mon, May 7, 2018 at 1:37 PM, David G. Johnston
<david.g.johnston@xxxxxxxxx <mailto:david.g.johnston@xxxxxxxxx>> wrote:
Please keep replies on-list, don't top-post, and double-check that
the database table doesn't somehow have an integer column where you
think its text.
On Sunday, May 6, 2018, tango ward <tangoward15@xxxxxxxxx
<mailto:tangoward15@xxxxxxxxx>> wrote:
Yeah, the error doesn't really explain much. I have tried
putting the string formatter in ' ', still no good.
On Mon, May 7, 2018 at 12:14 PM, David G. Johnston
<david.g.johnston@xxxxxxxxx <mailto:david.g.johnston@xxxxxxxxx>>
wrote:
On Sunday, May 6, 2018, tango ward <tangoward15@xxxxxxxxx
<mailto:tangoward15@xxxxxxxxx>> wrote:
Hi,
There's a mistake in the code, my bad.
I updated the code into
|cur_p.execute(""" INSERT INTO a_recipient (created, mod,
agreed, address, honor) VALUES (current_timestamp,
current_timestamp, current_timestamp, %s, %s)""",('', ''))
|
The code still won't work. The address and honor fields
are textfields in Django models.py.
Not sure but I'm thinking you at least need to add single
quotes around the %s symbols. That doesn't really explain
the integer input error though I'm not familiar with the
exact features of the execute method in Python.
They do not need to be quoted:
http://initd.org/psycopg/docs/usage.html#passing-parameters-to-sql-queries
David J.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
