If then ... for database records/web page

SoC · September 6th, 2004, 08:36 PM

Hi,

I have a series of web pages that allow users to search an Access database.

One of the fields in this database contains URLs (in text format).

On my web page, I do not display the URL (because it is very long), but rather a graphic. Uses click the graphic and go to that URL.

Here's my question:

Not all records in the db currently include a URL. I would like to be able to show when a record does not have a URL by displaying a different graphic.

So when there is a URL, I display graphic 1, when there isn't a URL I display graphic 2.

I know it must be a fairly simple if statement, but I'm not sure how to do it.

Here's my code:

Code:

<td width="10" align="center" valign="top">
<a href="http://myWeb/documents/<%=(rsDirected.Fields.Item("url").Value)%>">
<img src="images/doc-link.gif" alt="Click to Open Document"</a>

So really I just need something that says

if rsDirected.Fields.Item.Value = null then
display pic 2
else
display pic 1
end if

thanks
S

gbianchi · September 7th, 2004, 08:36 AM

hi there.. you have it rigth.. you need something like you say..
can you just read the value of the item before construct the page?? you will have to construct it iterating around all the records...

HTH

Gonzalo

SoC · September 9th, 2004, 02:10 AM

Hi, I worked out how to do it:

<a href="http://myweb/mypage/<%=(myRecordSet.Fields.Item("url").Value)%>">
<%if myRecordSet.Fields.Item("url").Value = "" then%>
<img src="images/image1.gif" alt="image 1 alt text">
<%else%>
<img src="images/image2.gif" alt="image 2 alt text">
<%end if%>

Had to make sure that the database had zero length strings ("") inserted, not nulls. Also tried putting in a value in place of ero length string (a page name, let's say default.htm)

All works very well.

cheers