Accessing the Data via SQL in WF perl script.

jsha

Hi,

I am trying to access data using following code, for some reason it hangs up. Any insight will be very helpful.

my $qry = "SELECT FILENAME from CMS_TEAMSITE where FILENAME= ?";

my $dbh = TWC::Utils::dbConnect(TWC::Utils::getDBConnectionInfo());
my $sth = $dbh->prepare($qry);
my $rv = $sth->execute($$dcrPath);
my $row = $sth->fetchrow_hashref)
$filen = $row->{'FILENAME'};

thanks

reddyl

You need to pass the filename before you execute the sql statement.