#!f:/Perl/bin/perl use strict; use warnings; use CGI; use DBI; my $cgi = CGI->new(); my %params = $cgi->Vars(); my $dbh = DBI->connect('DBI:ODBC:driver=Microsoft Access-Treiber (*.mdb); dbq=Kunden.mdb') or die $DBI::errstr; my $stmt = "SELECT Tabelle1.Name, Tabelle1.Adresse, Tabelle2.Rechnungsbetrag FROM Tabelle1,Tabell2 WHERE Kundennummer = ?"; my $sth = $dbh->prepare($stmt) or die $dbh->errstr(); $sth->execute($params{id}); my %hash; @hash{qw/Name Adresse Rechnungsbetrag/} = $sth->fetchrow_array(); print qq~Content-type: text/plain Content-Disposition: attachment; filename=$params{id}.txt ~; print sprintf("%-20s %s\n",$_,$hash{$_}) for(keys %hash);