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]