Re: Select Multiple Form Field via Perl into Oracle error

From: Larry Rosler <lr_at_hpl.hp.com>
Date: Tue, 31 Aug 1999 12:08:40 -0700
Message-ID: <MPG.1235c812926fa37d989eed@nntp.hpl.hp.com>

In article <FHByIH.Kp8_at_ig.co.uk> on Tue, 31 Aug 1999 12:54:17 GMT, Jacqui Caren <Jacqui.Caren_at_ig.co.uk> says...
> In article <ej%w3.1$2B2.769_at_news.enterprise.net>,
> Simmo <simsi_at_hotmail.com.nospam> wrote:
...
> >DBD::Oracle::db prepare failed: ORA-01756: quoted string not properly
> >terminated (DBD ERROR: OCIStmtPrepare) at news.pl line 855.
...
> >An example string i'm writing incidentally is:
> >
> >$categories_selected = $FORM{'categories'};
>
> $categories_selected = $dbh->escape($FORM{'categories'});
>
> should fix your problem...

Is that function particular to DBD::Oracle? The DBI module has a function called 'quote' that seems to do what is wanted, but no function called 'escape'.

--
(Just Another Larry) Rosler
Hewlett-Packard Laboratories
http://www.hpl.hp.com/personal/Larry_Rosler/ lr_at_hpl.hp.com Received on Tue Aug 31 1999 - 14:08:40 CDT