From: Timothy J Hitchens <tim@hitcho.com.au>
To: pgsql-interfaces@postgresql.org
Subject: Timestamp Update with PHP
Date: Sat, 17 Feb 2001 08:56:10 +1000
Message-ID: <DGEBJCBBIECKHBIGFEJHAEMKGBAA.tim@hitcho.com.au> (raw)
I am having trouble updating a timestamp field inside my database whenever I
use
the normal udpate xyz set x = now() etc etc I get must use case I use cast
and I get a ph error for the =...
ERROR: Unable to identify an operator '=' for types 'bpchar' and 'numeric'
You will have to retype this query using an explicit cast
Does anyone have an example of an update for a timestamp field using php.
I am really trying to use this with PHP and everytime I updated the record
because of a certain state I update the timestamp field.
Thanks..
Timothy Hitchens (Hitcho)
Web Evangelist/Technologist
Voice: +61 7 3396 3500
Fax: +61 7 3396 2633
Cell: +61 419 521 440
SMS: tim.sms@hitcho.com.au (subject only)
E-Mail: tim@hitcho.com.au
URL: http://www.hitcho.com.au/
-------------------------------------------------
"Everyone is born into this world
with two things freewill and potential
what we do from then on is totally
up to us. Let's all start today and
make a difference in this world."
-------------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tim@hitcho.com.au
Subject: Re: Timestamp Update with PHP
In-Reply-To: <DGEBJCBBIECKHBIGFEJHAEMKGBAA.tim@hitcho.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox