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
