Thread Access-DB Abfrage mit CGI: Auswertung Access-DB (5 answers)
Opened by axel19071 at 2004-07-15 18:03

renee
 2004-07-15 18:19
#32404 #32404
User since
2003-08-04
14371 Artikel
ModeratorIn
[Homepage] [default_avatar]
Hab noch was besseres gefunden:
Code: (dl )
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
use DBI;

#open connection to Access database
$dbh = DBI->connect('dbi:ODBC:driver=microsoft access driver (*.mdb);dbq=C:\Windows\Desktop\meineDB.mdb');

#prepare and execute SQL statement
$sqlstatement="SELECT * FROM table1, table2 WHERE table1.spalte = table2.spalte";
$sth = $dbh->prepare($sqlstatement);
$sth->execute ||
      die "Could not execute SQL statement ... maybe invalid?";

#output database results
while (@row=$sth->fetchrow_array()){
   print "@row\n";
}
\n\n

<!--EDIT|renee|1089901232-->
OTRS-Erweiterungen (http://feature-addons.de/)
Frankfurt Perlmongers (http://frankfurt.pm/)
--

Unterlagen OTRS-Workshop 2012: http://otrs.perl-services.de/workshop.html
Perl-Entwicklung: http://perl-services.de/

View full thread Access-DB Abfrage mit CGI: Auswertung Access-DB