[ppa-users] Re: [ppa-dev] Online Contact Form

[Dan W. <kil...@us...>]

This is corrected in development... Just one more type that we/I didn't know 
needed quoting (I'm sure there are plenty more). In order to fix it on your 
side, you should change line 46 in tbl_replace.php.

You will find something link the following:

if (eregi("char|date|bool|time|inet|text|cidr", $field_type[$key])) {

This should be changed to include macaddr in the list of types that require 
quoting. So it should look like:

if (eregi("char|date|bool|time|inet|text|cidr|macaddr", $field_type[$key])) {

-Dan


Quoting Matthew Wild <M....@rl...>:

> 
> I have a table of MAC addresses and am using the type macaddr. Unfortunately
> I can't get phpPgAdmin to insert values into the table. It keep passing ...
> values (405,aa-aa-aa-aa-aa-aa) rather than ... values
> (405,'aa-aa-aa-aa-aa-aa) to postgres.
> I've tried quoting, but they just get preserved and postgres barfs over them.
> 
> How do I enter values for fields such as these?