Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 32B384768E7 for ; Tue, 1 Oct 2002 18:48:09 -0400 (EDT) Received: from marsha.pcisys.net (marsha.pcisys.net [216.229.32.146]) by postgresql.org (Postfix) with ESMTP id 8BF124768CE for ; Tue, 1 Oct 2002 18:48:07 -0400 (EDT) Received: from [208.202.106.238] (moe1.meg106-238.cos.pcisys.net [208.202.106.238]) by marsha.pcisys.net (8.12.5/8.12.5) with ESMTP id g91Mm76u009218 for ; Tue, 1 Oct 2002 16:48:08 -0600 (MDT) User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.4 Date: Tue, 01 Oct 2002 16:48:09 -0600 Subject: Re: Inserting Null Value or String Value From: Keary Suska To: Postgres-PHP Message-ID: In-Reply-To: <20021001192010.91020.qmail@web14405.mail.yahoo.com> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/8 X-Sequence-Number: 1523 on 10/1/02 1:20 PM, dcmkx10@yahoo.com purportedly said: > This is the SQL generated: UPDATE prod_opt SET xref_prod_id = '4', code = '2', > title = 'test', isbn = '2', list_price = 2, our_price = 2, spec_price = 2, > spec_start_date = '10/01/02', spec_end_date = '10/01/02', quantity = 2, > clearance = 't', priority = 2 WHERE id = '2' > > This is the error I get: Warning: PostgreSQL query failed: ERROR: parser: > parse error at or near "10" I wouldn't expect that error message, but unless you have changed your date preferences the date format being used is invalid. By default, you must use SQl formatted dates, e.g. 2002-10-01 Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet"