in reply to Re: On Handling Text (Blob) Column Types in MySQL/CGI
in thread On Handling Text (Blob) Column Types in MySQL/CGI

Sorry about that - my typo. I meant to say
...
$sth->execute($text,$node_id);
...

[download]
cluka

Replies are listed 'Best First'.
Re: Re: Re: On Handling Text (Blob) Column Types in MySQL/CGI
by jasonk (Parson) on Apr 03, 2003 at 22:57 UTC

    The other problem (which I seem to have missed the first time around) is that you are mixing query types, is it an INSERT, or is it an UPDATE? You can't have a WHERE clause for an INSERT (although mysql has a REPLACE INTO syntax which does what you may be trying to do here).

    We're not surrounded, we're in a target-rich environment!
[reply]

In Section Seekers of Perl Wisdom