| From: | Bruce Young <hbrucey(at)yahoo(dot)com> |
|---|---|
| To: | PostgresPHP <pgsql-php(at)postgresql(dot)org> |
| Subject: | updating integer column |
| Date: | 2003-02-22 16:07:26 |
| Message-ID: | 20030222160726.91848.qmail@web10410.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
hi all, i have a table with an int8 column.
my PHP script should update a row with the new values in the form.
it works fine if i put a number in the field but gives this error if left
blank:
Warning: pg_exec() query failed: ERROR: Bad int8 external representation "" in
/home/httpd/htdocs/forms/manage/update_profile.php on line 140
how can i get around this..
oh and what is the best datatype to use for a 10 digit phone number?.
any help appreciated.
thanks
- bruce
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devrim GUNDUZ | 2003-02-22 16:56:20 | Re: updating integer column |
| Previous Message | Adam Witney | 2003-02-17 16:00:05 | Re: tcp connections |