Thread: RE: [SQL] Delete with AND

RE: [SQL] Delete with AND

From
"Jackson, DeJuan"
Date:
That statement should work just fine (assuming $CartCookie and $ItemID are
perl variable to be expanded before sent to the DB or that the strings
actually contain those values).

You may be having trouble with the uppercase column and table names if the
tables in the database are actually that case then you'll need to
double-quote the table and column names.-DEJ

> Hi,
> 
>         I'm trying to port some perl scripts that used MySql to Postgres
> and I'm having problems with a delete statement.
>         With MySql, the script has a line like this:
> DELETE FROM CartItems WHERE UserID='$CartCookie' AND ItemID='$ItemID'
>         How can I use such delete statement in Postgres?
>         Is there another way to do this?
>         Please, help and if possible cc to my e-mail as I'm not currently 
> subscribed to this list.
>         Thanks,
> 
> []s,
> Mario O.de Menezes            "Many are the plans in a man's heart, but
>     IPEN-CNEN/SP                 is the Lord's purpose that prevails"
> http://curiango.ipen.br/~mario                 Prov. 19.21
>