Hi.
----- Original Message -----
From: "Murali Kanaga" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 12:44 PM
Subject: DBI ProxyServer & SQL
> Hi Gurus,
>
> I am trying to connect to SQL from Solaris using DBD::ProxyServer.
>
> This script ask the user for Bug Fix number ($bfn). Then, it passes
> this variable to check the SQL for existence.
(snip)
> my $bfn = clearprompt(qw(text -pref -prompt), 'Enter the Bug-fix
> Number');
>
> my $sth = $dbh->prepare( 'SELECT k_productreview FROM
> b_productreview where
> k_productreview = $bfn');
Why did you use single-quote(') not double-qoute(") ?
Anyway, I recommend you to use placeholder.
#Of course, I recommend you to use "use strict;"!
ex.
my $sth = $dbh->prepare( 'SELECT k_productreview FROM
b_productreview where
k_productreview = ?');
$sth->execute($bfn);
==============================================
Kawai, Takanori(Hippo2000)
Mail: [EMAIL PROTECTED] [EMAIL PROTECTED]
http://member.nifty.ne.jp/hippo2000
==============================================
