in reply to Re: MYSQL $dbh->do
in thread MYSQL $dbh->do

You have an error in your SQL syntax near '' at line 1 at admin.cgi line 207. Doesnt work!!!

Replies are listed 'Best First'.
Re: Re: Re: MYSQL $dbh->do
by Juerd (Abbot) on Sep 28, 2002 at 20:49 UTC

    Doesnt work!!!

    Oh, right. Stupid DBI again. I forgot to add undef.

    use DBIx::Simple; my $db = DBIx::Simple->connect(...); $db->query('UPDATE ... SET foo=?, bar=?', $foo, $bar);
    There, a lot better :)

    - Yes, I reinvent wheels.
    - Spam: Visit eurotraQ.
    

      were does it say undef, and Im just using

      use DBI;