Help for this page

Select Code to Download


  1. or download this
            my $executeSQL = "INSERT INTO FDNMail (msgid,subject,sourceip,
    +sourcednsname,[from],[to],allheaders,preamble,body,receiveddate,attac
    +hmentdata,
                    custnum,[X-AOLIP]) VALUES ('".$record->{"msgid"}."','"
    +.$record->{"subject"}."','".$record->{"sourceip"}."','".$record->{"so
    +urcednsname"}.                "','".$record->{"from"}."','".$record->
    +{"to"}."','".$record->{"allheaders"}."','".$record->{"preamble"}."','
    +".$record->{"body"}.                "','".$record->{"receiveddate"}."
    +','".$record->{"attachmentdata"}."','".$record->{"custnum"}."','".$re
    +cord->{"xaolip"}."')";
            my $action = $tema1->prepare($executeSQL);
    
  2. or download this
    my %fields = (
        msgid          => $record->{msgid},
    ...
    
    my $fdnmail_sth = $temal->prepare($sql);
    $fdnmail_sth->execute(values %fields);