Received: from clio.trends.ca (root@clio.trends.ca [209.47.148.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e57Ixlc38021 for ; Wed, 7 Jun 2000 14:59:47 -0400 (EDT) Received: from sandtstudent.pyr.ec.gc.ca (fwvan1.pyr.ec.gc.ca [199.212.20.2]) by clio.trends.ca (8.9.3+Sun/8.9.3) with ESMTP id OAA08349 for ; Wed, 7 Jun 2000 14:19:50 -0400 (EDT) Received: from ec.gc.ca (IDENT:huangb@sandtstudent [131.235.150.249]) by sandtstudent.pyr.ec.gc.ca (8.9.3/8.9.3) with ESMTP id LAA14283; Wed, 7 Jun 2000 11:20:19 -0700 Message-ID: <393E9263.F84CA777@ec.gc.ca> Date: Wed, 07 Jun 2000 11:20:19 -0700 From: Bernie Huang Organization: Environment Canada X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: PGSQL-SQL , PHP-PGSQL Subject: Please ignore [PSQL and PHP] Content-Type: multipart/mixed; boundary="------------96BDF137F2A641DC26FCB5E7" X-Archive-Number: 200006/74 This is a multi-part message in MIME format. --------------96BDF137F2A641DC26FCB5E7 Content-Type: text/plain; charset=iso-8859-15 Content-Transfer-Encoding: 7bit Hello, Never mind the last email subjected "PSQL and PHP". I found the bug. In PHP script, instead of using insert into employee values ( 'Bernie', '{$phone, $fax, ...}' ); or insert into employee values ( 'Bernie', '{"$phone", "$fax", ...}' ); or any other possible combo, I should have used insert into employee values ( 'Bernie', '{\"$phone\", \"$fax\", ...}' ); Damn it! That makes me mad! Sorry about this. - Bernie --------------96BDF137F2A641DC26FCB5E7 Content-Type: text/x-vcard; charset=iso-8859-15; name="bernie.huang.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Bernie Huang Content-Disposition: attachment; filename="bernie.huang.vcf" begin:vcard n:Huang;Bernie tel;fax:(604)664-9195 tel;work:(604)664-9172 x-mozilla-html:TRUE org:Environment Canada;Standards and Technology Services adr:;;700-1200 West 73 Ave.;Vancouver;BC;V6P 6H9;Canada version:2.1 email;internet:bernie.huang@ec.gc.ca title:Programmer x-mozilla-cpt:;0 fn:Bernie Huang end:vcard --------------96BDF137F2A641DC26FCB5E7--