On Mon, Jul 30, 2001 at 12:30:34PM +0200, [EMAIL PROTECTED] wrote:
> plz tell me if the following statement is correct (just for the fact i cant
> find a solution for the problem in jsp at once)
>
> insert into pictures (picturename,picturedata) values ("testpicture", "c:
> \temp\testpicture.gif");
>
> picturename is defined as char(50) - picturedatea is defined as blob
No, you're just inserting the string "c:\temp\testpicture.gif" into
the blob column. MySQL won't go out to the disk and fetch the image
for you. You'll need to read it from disk yourself.
--
Maurice Aubrey <[EMAIL PROTECTED]>
"Watch the costs and the profits will follow." - Andrew Carnegie
MySQL 3.22.32: up 11.1 days, processed 766,672,358 queries (797/sec. avg.)
---------------------------------------------------------------------
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
