use DBI; use HTML::Entities (); use IO; use XML::Writer; use Date::Language; use CGI; my $query = new CGI; print $query->header(); $atom_id = $query->param('atom_id'); my $lang = Date::Language->new('English'); # Set up DB parameters my $dbh = DBI->connect ("DBI:mysql:database=sbsContacts;host=localhost", "root", "cobweb123", {RaiseError => 1, PrintError => 0}); # Outer loop - get all scheme IDs where flag is set $sbs_query = $dbh->prepare("SELECT * FROM sbs_contacts WHERE for_sbs = 'Y' AND atom_id = ?"); $sbs_query->execute($atom_id); # Create the file where all the contact XML will be printed my $output = new IO::File(">$atom_id.xml"); #PROBLEM HERE! my $writer = new XML::Writer(OUTPUT => $output, DATA_MODE => 'true', DATA_INDENT => 2);