Image display problems

[rudodoo619]

I created a database using access that has 2 tables one displays the product id
and its descriptions, the other table has the productid and a text link that
will show the image that matches that particular product.

However, when I run the search form and display the results I get a text link
to the image and not the actual image. How do I configure Coldfusion MX7 to
display the image that is associated with that particular link?

[jdeline]

Could you provide an example of the text link as it appears in the database?
Are you using an <A> tag to make the link hot? Are you using an <IMG> tag with
the link specified? See code below for example.

<CFQUERY NAME="getImage" ... >
SELECT id, link FROM linkTable WHERE ...
</QUERY>

<CFOUTPUT QUERY="getImage">
<A HREF="goToDisplayLargerImage.cfm?id=#id#"><IMG SRC="#link#" ... ></A><BR>
</CFOUTPUT>

[rudodoo619]

Got it figured out, thanks though!!!

HOwever I do have another question if you can answer it

I have created a search form that links to the master detail page set and from
there has a hyperlink that goes to the detail page.

Now the search form has 3 different types of categories to search from.
These different categories all have different field values.

How would i create the detail page where if the value in a certain field is
null, that certain field will not be displayed on the screen

[jdeline]

You wrote:
"I have created a search form that links to the master detail page set and
from there has a hyperlink that goes to the detail page.

Now the search form has 3 different types of categories to search from. These
different categories all have different field values.

How would i create the detail page where if the value in a certain field is
null, that certain field will not be displayed on the screen "

In your last sentence, are you refering to the detail page or the master
detail page?

[rudodoo619]

The detail page.

What I am trying to say is that these 3 search categories have some values in
common and some values that aren't. So what I did was just display all the
values from the query in the detail page.

However, if a value is null in the detail page I don't want it showing up at
all

How would I do that

[jdeline]

Are you passing the variable(s) that contain these values (possibly null value)
to the detail page? If so, use the IsDefined("variableName") to see if the
variable exists, or use <CFIF variableName IS ""> to see if it is empty. Then
act accordingly.

[rudodoo619]

Would this work

<cfif len(trim(name)) neq 0>
#name#<br>
</cfif>

[rudodoo619]

Yes I am passing it to the details page

[jdeline]

Try it and see if it works.