The single quotes around $image prevent perl from substituting the value. You are trying to load a file named $imageFN. $SQL = "UPDATE banners SET image=load_file(\"$imageFN\") where id=1";
Kevin Smith wrote: >After reading some other posts on inserting a image into a blob field, I >tried using DBI to insert and the following does not work... > >I've double-checked the path and it is correct. > >$imageFN = '/var/www/htdocs/corporate/images/homenew.jpg'; >$SQL = "UPDATE banners SET image=load_file('$imageFN') where id=1"; > >If I execute the same SQL statement at the MySQL > prompt it inserts into >the database fine... what am I doing wrong? > >Thanks, > >Kevin > > > > > >--------------------------------------------------------------------- >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