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
