Re: Image's

[<massey@xxxxxxxx>]

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...
>
> massey@xxxxxxxx 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 <mysql-thread92904@xxxxxxxxxxxxxxx> To
>>unsubscribe, e-mail <mysql-unsubscribe-mikel=ocsny.com@xxxxxxxxxxxxxxx>
>>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 <mysql-thread92909@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php