Re: BLOB insert problem used ' '

2002-07-09 Thread Mark Worsdall 

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

BLOB insert problem used ' '

2002-07-06 Thread Mark Worsdall 

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