use strict; use warnings; use DBI; my $dbh=DBI->connect('dbi:ODBC:DSN='.$DSN, $USER, $PSWD) or die "Couldn't connect to database: ".DBI->errstr; my $fieldquery=" SELECT FROM WHERE PlanSetup.PlanSetupSer=? "; my $sth_fields=$dbh->prepare($fieldquery) or die "Couldn't prepare statement: " . $dbh->errstr; $sth_fields->execute($plansetupser) or die "Couldn't execute statement: ".$sth_fields->errstr;