First off, you trying to insert the image into the database or just its path?
-----Original Message----- From: yue cheng [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:23 PM To: [EMAIL PROTECTED] Subject: Load_File issue Hi, Now I am puzzled by the filepath,Load_file, I install MySQL in Windows98, the file which i want to insert to table is c:\P1.bmp when I run load_file in mysql command line,it succeeds mysql> insert into blobtable (load_file("/P1.bmp")) but i don't know why i should use slash instead of backslash on windows. if i use the absolute path load_file("c:\P1.bmp"), the blob field in table is NULL I also run insert into blobtable (load_file("/P1.bmp"))in mysqlgui,it also insert null to table. i run this query in my Visual basic, same problem. _________________________________________________________ Do You Yahoo!? 到世界杯主题公园玩一玩，赢取世界杯门票乐一乐。 http://cn.worldcup.yahoo.com/ --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
