Hello, Thanks for your time. I'm having some problems loading images into a table. I'm using the statement:
INSERT INTO BLOBTEST set b1=load_file<'c:\1.jpg'); The table (blobtest) is made up of 2 columns : id1 (auto counter) and b1 (BLOB) When I try and run this statement (above) I get a record inserted with a value for the counter, but for the binary file - I get the value NULL. I have checked Pauls' book and it states about the load_file that NULL will be returned if: * the file doesn't exist on the server (it does - at c:\) * is not world-readable (I'm running xp so no unix ACL's but I'm running with admin rights) * user must have FILE privilages in mysql (I've dropped my old user and created a new one with "grant all on test.* to orange@'%' identified by 'orange';") Any ideas why this is not working? - I just need to load an image to test things. ALSO can images be loaded without using the set statement? - IMPORTANT Thank you. Thanks lots David Ayliffe ICQ# 125646758 --------------------------------------------------------------------- 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
