Re: ERROR: Can't Parse "" (PG and PHP on Linux) - Mailing list pgsql-general

From Matthew Kirkwood
Subject Re: ERROR: Can't Parse "" (PG and PHP on Linux)
Date
Msg-id Pine.LNX.4.33.0208031345340.31068-100000@sphinx.mythic-beasts.com
Whole thread Raw
In response to ERROR: Can't Parse "" (PG and PHP on Linux)  (paulie808@yahoo.com (Paul))
List pgsql-general
On 30 Jul 2002, Paul wrote:

> $strSQL = sprintf("INSERT INTO companies (comp_name, type_id) VALUES
> ('%s', %s);",$strCompName,trim($intTypeID));

Lose the trailing semicolon.  The backend is probably
interpreting that as:

"insert foo" + empty statement

Matthew.


pgsql-general by date:

Previous
From: Phil Dobbin
Date:
Subject: Re: Postgres and Perl: Which DBI module?
Next
From: snpe
Date:
Subject: CVS problem