Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:
my $dbh = CreateObject OLE "ADODB.Connection" or die "Can't create con +nection to DataBase: $!" unless $dbh; $dbh->Open("Driver={Microsoft Access Driver (*.mdb)};DBQ=db/1.mdb"); my $rs = CreateObject OLE "ADODB.Recordset" or die "can not create rec +ordset"; my $sql = "INSERT INTO classes (subject,classnumber,description) VALUE +S ('$classSubject','$classNumber','$classDescription')"; $rs = $dbh->Execute( $sql ) or die print ( "Can't execute SQL statemen +t. Perl says $!, DBI says ",$dbh::errstr,"\n"); $dbh->Close();
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Bad file descriptor error.... No idea what that is ... please help :-D
by poj (Abbot) on Dec 28, 2002 at 13:29 UTC | |
by Anonymous Monk on Dec 28, 2002 at 13:50 UTC | |
|
Re: Bad file descriptor error.... No idea what that is ... please help :-D
by chromatic (Archbishop) on Dec 28, 2002 at 23:07 UTC | |
by mjolnir (Initiate) on Dec 29, 2002 at 00:26 UTC |