Thread Problem beim Importieren in eine MySQL DB
(10 answers)
Opened by schiba82 at 2008-04-02 17:56
pq hatte ja schon die Platzhalter erwähnt!
Mach Code (perl): (dl
)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 my $SQL_Insert = "INSERT INTO TicketData ( TicketNumber, Year, Month, FiscalYear, Category, Problemtype, Component, SLA, EscalationLevel, Status, Priority, Queue, Customer, CustomerUserID, TicketOwner, DirectSolve, Hostname, Created, Solved ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; my $Abfrage1 = $dbh->prepare($SQL_Insert); $Abfrage1->execute( $TicketNumber, $Year, $Month, $FiscalYear, $Category, $Problemtype, $Component, $SLA, $EscalationLevel, $Status, $Priority, $Queue, $Customer, $CustomerUserID, $TicketOwner, $DirectSolve, $Hostname, $Created, $Solved ); 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/ |