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 have 
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=$ownerid";

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;

When I try to access the database it gives me errors when I want to 
select from columns with manes which include space
__________________________________
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]

Reply via email to