Re: [GENERAL] UPDATE cell from text file

On Sat, 23 Oct 1999, Bob Kline wrote:

>Just out of curiosity, what's the drawback of a perl script here?  It
>would be pretty trivial.
>
>    ....
>    open BAF, "$ARGV[0]" or die "Can't open $ARGV[0]: $!";
>    $contents = "";
>    while (read, BAF, $buf, 10240) { $contents .= $buf; }
>    $sth = $dbh->prepare("UPDATE website
>                             SET content = ?
>                           WHERE filename = ?");
>    $sth->execute($content, $ARGV[1]) or die $DBI::errstr;

Thank you for your reply.

The drawback of perl is that I use it so often that I have to relearn it
from scratch every time I use it. :( In fact, my perl is so weak, I cannot
read your script without opening up the book. I will make good use of your
reply.

I was hoping there was an SQL construct but I half suspected there was
not.

Thank You,     | http://students.washington.edu/jcwells
Jason Wells    | "Those who would trade freedom for security deserve neither
        | freedom nor security." - Benjamin Franklin