in reply to Re: Perl Beginners problem with DBI
in thread Perl Beginners problem with DBI

BTW, what database allows double quotes around literal strings: 
$dbh->do("UPDATE INV SET SOLD=\"$updy\" WHERE CODE==$CODE");

[download]
The SQL standard is single quotes around strings. Double quotes are used around identifiers.

Replies are listed 'Best First'.
Re: Re: Re: Perl Beginners problem with DBI
by matija (Priest) on Mar 17, 2004 at 23:01 UTC
    > BTW, what database allows double quotes around literal strings

    MySQL allows both. But you're right, I should be more carefull about that.

[reply]

In Section Seekers of Perl Wisdom