Received: from relay2.shore.net (relay2.shore.net [207.244.125.21]) by hub.org (8.10.1/8.11.0) with ESMTP id e9IBLVW21490 for ; Wed, 18 Oct 2000 07:21:31 -0400 (EDT) (envelope-from drp@shore.net) Received: from netmnch-s01-70.port.shore.net (wind) [204.167.102.70] by relay2.shore.net with smtp (Exim) id 13lrHW-0002ja-00; Wed, 18 Oct 2000 07:21:15 -0400 Message-Id: <3.0.6.32.20001018071750.007aa450@shell1.shore.net> X-Sender: drp@shell1.shore.net X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.6 (32) Date: Wed, 18 Oct 2000 07:17:50 -0500 To: Chris From: Dave Perkins Subject: Re: files, php & pgsql Cc: pgsql-php@hub.org In-Reply-To: <4.3.2.7.2.20001018185338.00a9fcb0@mail.pharm.usyd.edu.au> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Archive-Number: 200010/27 X-Sequence-Number: 42 Chris, I ran a quick test and got the following error: "PostgresSQL query failed: ERROR: parser: parse error at or near " " If the following is how the code is actually formated: >$sql = "insert into images (picnum, image) values >(nextval('images_picnum_seq'), '$loid')"; it might be the source of the problem. Putting the quoted string all on one line as in: $sql = "insert into images (picnum, image) values (nextval('images_picnum_seq'),'$loid')"; eliminates this error. Hope this helps . . . Cheers, Dave