How to create a list of images stored in a MySQL database in a text field
jrosat at mac.com
Fri Nov 5 14:26:34 CST 2004
Thank you for your answer.
Yes, it helps me a lot.
Le 5 nov. 04, à 15:56, Jan Schenkel a écrit :
> --- Jérôme Rosat <jrosat at mac.com> wrote:
>> Hi all,
>> I would like to create a list field containing in
>> each row an image,
>> its number and its name.
>> The image size should make 16 X 16 pixels.
>> I imagine I should first:
>> - open a connection to my DB
>> - execute a SQL query to select all rows of the
>> I think I should use the imageSource property but I
>> have got no idea
>> how to use it to create the list and fix the size of
>> the images.
>> Does somebody have an idea ?
>> Thank you for you help.
>> Jérôme Rosat
> Bonjour Jérôme,
> As I don't recall seeing a reply to this on the list,
> I thought I'd give you some advice (better late than
> never, right ?)
> Text field images are either stored in the stack and
> refered to by their ID or name, or are external to
> your stack and refered to by a URL (http or file)
> So if the data is stored in a MySQL database, you'll
> have to take two steps to accomplish your goals :
> 1) get the image data from the database and
> temporarily store them inside an image control (this
> control can be offscreen, or hidden)
> 2) then set the imagesource of a chunk of your field
> to the ID of the image :
> set the imageSource of char 1 of line 2 of \
> field "Foobar" to "myImageName"
> Hope this helped,
> Jan Schenkel.
> Join us at the European Revolution Conference
> November 14-16, MALTA. ~ http://TechieTours.com/Rev/
> "As we grow older, we grow both wiser and more foolish at the same
> time." (La Rochefoucauld)
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> use-revolution mailing list
> use-revolution at lists.runrev.com
More information about the use-livecode