Classic ASP Discussion - If ... then statement

Print Page | Close Window

If ... then statement

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=7501
Printed Date: 31 March 2026 at 11:22pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: If ... then statement

Posted By: cuedog
Subject: If ... then statement
Date Posted: 22 November 2003 at 1:29pm

I cannot get N/A to print if there is no post date. Can anyone see why? Here is the code

I am using mysql and dtLastPostDate is in this format 2002-08-26 07:50:21

dtLastPostDate = rsPostdate("lastpostdate")

<%If dtLastPostDate <> "" Then%>

" face="<%=frm_dscp_fontfm%>" color="<%=frm_dscp_fontcl%>"><%=fncFmtDate(dtLas tPostDate, "%d %b %Y at %h:%N %P")%> 
by <a href="javascript:popUp('popup_profile.asp?id=<%=rsAuthor( "MemberID")%>','popUp','width=375,height=250,scrollbars=y es')"><%=rsAuthor("lastpostmember")%></a>

<%Else%>

<center>" face="<%=frm_dscp_fontfm%>" color="<%=frm_dscp_fontcl%>">N/A</c enter>

<%End IF%>

-------------
http://www.512ryders.com - 512 Ryders

Replies:

Posted By: Gullanian
Date Posted: 22 November 2003 at 5:45pm

Try:

<%If dtLastPostDate <> "" OR isNull(dtLastPostDate) = TrueThen%>

Posted By: cuedog
Date Posted: 23 November 2003 at 2:40pm

That didn't work any other suggestions

-------------
http://www.512ryders.com - 512 Ryders

Posted By: Gullanian
Date Posted: 23 November 2003 at 2:59pm

Try printing out the value of the variable in question and see what it holds

Posted By: cuedog
Date Posted: 23 November 2003 at 3:28pm

If there is a value it shows 9/21/2003 8:26:35 PM, if there is not a value nothing prints out. I have tried IsDate, IsEmpty, IsNull, AND, false and true combinations and have not been succesful.

-------------
http://www.512ryders.com - 512 Ryders