in reply to Bug in DBD::CSV?

Can you change the first value in $sth2->execute("postaladdress","123456","name 10"); to "postaladdress10" and say what the DBD::CSV output is? i'm curious which update statement really sets it .. hmm.. what happens in the update's are reversed in order? (i agree w/Tortue that the SQL looks good)

I'm sure he'll see this, but in case he doesn't, be sure to /msg jZed or catch him in the chatterbox -- he's the author and always very willing to handle issues w/DBD::CSV ...

random tmtowtdi code comment -- output could just be print join("\t",@$line), "\n"; instead of the foreach loop.

Replies are listed 'Best First'.
Re^2: Bug in DBD::CSV?
by g0n (Priest) on Sep 06, 2005 at 12:45 UTC
    OK

    .. $sth1->execute("name 9","postaladdress","123456","name 9"); $sth2->execute("postaladdress10","123456","name 10"); ..

    results

    name 1 postal 1 telephone 1 name 2 postal 2 telephone 2 name 3 postal 3 telephone 3 name 4 postal 4 telephone 4 name 5 postal 5 telephone 5 name 6 postal 6 telephone 6 name 7 postal 7 telephone 7 name 8 postal 8 telephone 8 name 9 name 9 postaladdress name 10 name 10 postaladdress10

    Thanks for the suggestions, I'll /msg jZed, and the join for output is much neater :)

    --------------------------------------------------------------

    g0n, backpropagated monk