Re: ERROR: Can't Parse "" (PG and PHP on Linux)

From: Matthew Kirkwood <matthew(at)hairy(dot)beasts(dot)org>
To: Paul <paulie808(at)yahoo(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: Can't Parse "" (PG and PHP on Linux)
Date: 2002-08-03 12:46:38
Message-ID: Pine.LNX.4.33.0208031345340.31068-100000@sphinx.mythic-beasts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hannu Krosing 2002-08-03 12:55:36 Re: getpid() function
Previous Message Phil Dobbin 2002-08-03 10:15:17 Re: Postgres and Perl: Which DBI module?