This topic is locked

Loookup database images

9/20/2006 7:09:25 AM
ASPRunnerPro General questions
M
maurello author

I am trying to lookup a field containing images of country flags (datatype = image) from a SQL Server 2005 db. However, the generated webpage always shows a broken link. On the other hand, if I change the looked up field to retrieve the country name, it works fine and the name of the country is correctly published.
Does the lookup wizard support database images?

Sergey Kornilov admin 9/22/2006

No,
lookup wizard don't support images.
To be honest I've never seen a webpage with dropdown box full of images. Not sure if this is possible at all.

M
maurello author 9/25/2006

No,

lookup wizard don't support images.
To be honest I've never seen a webpage with dropdown box full of images. Not sure if this is possible at all.


Actually i only need the lookup and not the dropdown box.
I basically have a main table with the list of products and each product has a country of origin, which is of course a foreign key (3 numbers). If I use the lookup function I can easily publish the name of the country loooking up the CountryName field in the Country table, but I would like to lookup the Flag field, which contains the image of the flag, and publish it as image in the main page. When I tried to do so, I could see only broken links in that column or some strange characters in another column.
I solved the issue applying the same suggestion for the search of loookeup up values, but I was wondering if this could be done quickly using the lookup wizard in ASP Runner.

Sergey Kornilov admin 9/25/2006

Mauro,
Lookup wizard means dropdown box in ASPRunnerPro.

Not really sure what do you mean "I need the lookup and not the dropdown box".

M
maurello author 10/4/2006

Hi,
I basically use the lookup to resolve key values in my "list" table looking up either a name of a country or its flag. The name of course is a text field and the lookup wizard reports it correctly. The flag is an image and the lookup wizard does not retrieve it correctly.
I had to work around the problem within the query adding a LEFT JOIN to retrieve directly for the list table the flag of each country.
I was just wondering if it would be possible to use the lookup wizard to do so.