Hi,
I am trying to write a scipt which generates a web page based on a
information is ACCESS database. First, I need another script which hava
to pass the information (user ID) to the one which will actually display
the other page. I have to pass the infprmation only by clicking on a
particular link. The scrpt that generates the web page gives me the
following error:
syntax error at franowner.pl.txt line 1, near "use Win32:"
Execution of franowner.pl.txt aborted due to compilation errors.
the script is:
use Win32:ODBC;
$ownerid = $ENV{'QUERY_STRING'};
$DSN="db1"
$dbh = new Win32::ODBC($DSN);
$statement = "SELECT Field1, Field2, Field3,
Field4, Field5, Field6 FROM Owners WHERE ID=17";
if ($dbh->Sql($statement)) {
print "SQL failed.\n";
print "Error: " . $db->Error() . "\n";
}
$sth = $dbh->prepare($statement);
$rv = $sth->execute || die "Cannot execute SQL statement:\n$DBI:errstr\n";
($ownerfname,$ownerlname,$owneradd,$ownercity,$ownerst,$ownerzip) = $sth-
>fetchrow_arrayref;
It also gives me SQL error when I try to select from columns which names
are consisted of more than one word
__________________________________
12MB-POP3-WAP-SMS---TOBA-E-mail.bG
----------------------------------
" Ako uckame u Bue agpec B mail.bg
ugeme myk: http://www.mail.bg/new/ "
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
