Image's
Either the coffee is flat or someone switched to decafe on me. What is the proper way to retrive an image that is stored as a path in a field name with SQL? My path would be something like Table=YPEOPLE field=pictures with the path like this c:\images\110101\yourpic.jpeg Also is there a way to do this. I have an aging DOS FoxPro database (see above) that is still in constant use. I imported the tables into MySQL, 200+ Tables and some 200,000 rows, and I would like to update just the New info. Reason. They flat will not give up the monster in accounting. Period. So to make Win users happy I have a small GUI for searchs and stuff,,all read only. Off in seach of a Starbucks. M;) - 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
Re: Image's
tryt constructing a URL like file:///images/110101/yourpic.jpg out of the location... [EMAIL PROTECTED] wrote: Either the coffee is flat or someone switched to decafe on me. What is the proper way to retrive an image that is stored as a path in a field name with SQL? My path would be something like Table=YPEOPLE field=pictures with the path like this c:\images\110101\yourpic.jpeg Also is there a way to do this. I have an aging DOS FoxPro database (see above) that is still in constant use. I imported the tables into MySQL, 200+ Tables and some 200,000 rows, and I would like to update just the New info. Reason. They flat will not give up the monster in accounting. Period. So to make Win users happy I have a small GUI for searchs and stuff,,all read only. Off in seach of a Starbucks. M;) - 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
Re: Image's
The GUI is built in Delphi and uses a grid and a TDBImage and when you scroll through the Grid or Search I need to be able to retrive the image that goes with the persons name. The Web thought has me thinking since I use PHP to do this with my web site it might be easy to do. But I would rather just use an SQL Script to retrive the info.. M;) tryt constructing a URL like file:///images/110101/yourpic.jpg out of the location... [EMAIL PROTECTED] wrote: Either the coffee is flat or someone switched to decafe on me. What is the proper way to retrive an image that is stored as a path in a field name with SQL? My path would be something like Table=YPEOPLE field=pictures with the path like this c:\images\110101\yourpic.jpeg Also is there a way to do this. I have an aging DOS FoxPro database (see above) that is still in constant use. I imported the tables into MySQL, 200+ Tables and some 200,000 rows, and I would like to update just the New info. Reason. They flat will not give up the monster in accounting. Period. So to make Win users happy I have a small GUI for searchs and stuff,,all read only. Off in seach of a Starbucks. M;) - 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