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
usingan 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."
-------------------------------------------------
