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

On Tue, Jul 30, 2002 at 07:05:05AM -0700, Paul wrote:
> 1.  The following PHP statement:
>
> $strSQL = sprintf("INSERT INTO companies (comp_name, type_id) VALUES
> ('%s', %s);",$strCompName,trim($intTypeID));
>
> yields the SQL statement:
>
> INSERT INTO companies (comp_name, type_id) VALUES ('someName',9);

Is that what your logs tell you it's yielding?  Given your errors, my
bet is that PHP is doing something you don't think it is.

> 2. When I try to drop old databases or tables, it gives an error
> telling me that a user is using the database and can't drop the
> table/database. I've even tried it after killing all processes on the
> server and not being logged into the database I'm trying to drop
> (i.e., logged into another database)

Are you sure there's no-one connected?  You've checked with ps?
Sounds like a connection isn't really dead.

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110