Hi all,
Sorry should have got my mind around the LOAD_FILE('./image.tiff')
method.
M.
In message <[EMAIL PROTECTED]>, Mark Worsdall
<[EMAIL PROTECTED]> writes
>Hi,
>
>After a good old slurp of an image< I am trying to stick it into my
>table.
>
>
># Slurp file
>foreach (@image_list) {
> my $image = "/usr/home/shadow/Vision/$_";
>
> # Load image into memory
> my $imagePIC = do
> {
> local ($/, *PIC); # slurp mode, local file handle
> open PIC, $image or die "can't open '$image': $!";
> binmode PIC;
> <PIC>
> };
>
>
>And this is how I am sticking it in, but I get an error reported in my
>sql code.
>
>my $prep = "INSERT INTO object (object) VALUES ('$image')";
>
>see anything wrong?
>
>I tried:
>my $prep = "INSERT INTO object (count) VALUES (1)";
>
>to check I can insert, and I can.
>
>M.
>
--
Work:- postmasterAThinwick.demon.co.uk
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
