I think the line is supposed to be: use Win32::ODBC; Thanks,
Daryl J. Hoyt Software Engineer Geodesic Systems < http://www.geodesic.com> < mailto:djh@;geodesic.com> -----Original Message----- From: Angel Iliev Kafazov [mailto:angel.kafazov@;mail.bg] Sent: Thursday, November 07, 2002 12:48 PM To: '[EMAIL PROTECTED]' Subject: Enviroment variables and Win32::ODBC 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] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
