Hi,

On a list of clan teams, linked to a DB field containing their url's is it possible to:

Write the team out as plain text if the hyperlink is null instead of getting a href value of "/" in the browser.

Regards,
Dave

UD4 || Flash || Access ||Web Hosting

<% If rsRecordset1.fields.item("URLFieldName".value = "" or Null Then%>

<%=rsRecordset1.fields.item("TextfieldtoDisplay".value%>

<% Else %>

<a href="<%=rsRecordset1.fields.item("URLFieldName".value"><%=rsRecordset1.fields.item("TextfieldtoDisplay".value%></a>

<% End If %>

Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting

Edited by - bakerv on 30 Sep 2002 12:45:46

i thought of something along them lines,

thanks again vince.

Regards,
Dave

UD4 || Flash || Access ||Web Hosting

Okies that didn't work but thanks for trying anyway. I appreciate it;

Heres the working code below:

<% Dim strTeam, strLink, strFinal

strTeam = rsClanA.fields.Item("Opponent"
strLink = rsClanA.fields.Item("ClanURL"

if len(strLink)>0 then
strFinal = "<a href="""&strLink&""">"&strTeam&"</a>"
else
strfinal = strTeam
end if
response.write strFinal
%>

Regards,
Dave

UD4 || Flash || Access ||Web Hosting