Thread Problem beim Importieren in eine MySQL DB (10 answers)
Opened by schiba82 at 2008-04-02 17:56

renee
 2008-04-02 18:33
#107757 #107757
User since
2003-08-04
14371 Artikel
ModeratorIn
[Homepage] [default_avatar]
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/

View full thread Problem beim Importieren in eine MySQL DB