List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:July 15 1999 4:53am
Subject:Re: Inserting gif images into a table?
View as plain text  
Craig Oettle wrote:
> 
> I'm sure I'm missing something simple but would some one mind telling
> how to insert a gif file into a table instead of just the name of the
> file.  I have a table like this:
> create table producta(
> itemno varchar(40) not null,
> descript varchar(100),
> price decimal(8,2),
> pic blob
> );
> 
> What I try:
> insert into producta values(
> '12345',
> 'blah blah blah',
> '548.99',
> 'prodocta.gif'
> );
> 
> Any help would be appreciated.
> --
> Craig Oettle
> 

You need to store it in a BLOB and properly escape it.

The way you are doing it now would  be better in my opinion, except you
will need to create a directory tree for your images so you will not
have everything in one directory.

-- 
Sasha Pachev
http://www.sashanet.com
Thread
Inserting gif images into a table?Craig Oettle15 Jul
  • posting error?Sean Hynes15 Jul
  • Re: Inserting gif images into a table?Sasha Pachev15 Jul