Display blanc (Full Version)

All Forums >> [Web Development] >> ASP, PHP, and Database



Message

box -> Display blanc (9/14/2009 3:14:10)

<%If FP_FieldVal(fp_rs,"nextapt") <= fixTheDate(Date()) Then%>
<font color="#FF0000"><%Response.write "Old Appointment"%></Font>
<%end if%>

Nextapt is data/time field and fixTheDate(Date()) returns the curent date like date() I want if nextapt is older than fixTheDate(Date()) then display old appointment but it disply nothing! do you have any idea why? Thanks



TexasWebDevelopers -> RE: Display blanc (9/14/2009 9:56:48)

It isn't finding data and you don't write anything if there isn't any data found...you could do something like this:
<%If FP_FieldVal(fp_rs,"nextapt") <= fixTheDate(Date()) Then%>
<font color="#FF0000>Old Appointment</font>
<%else%>
<font color="#FF0000>No Data Found</font>
<%end if%>



box -> RE: Display blanc (9/14/2009 11:40:32)

Thanks for reply, now it disply for date newer than today also including older date no appointment! I useded this:

<%If FP_FieldVal(fp_rs,"nextapt") <= fixTheDate(Date()) Then%>
<font color="#FF0000>Old Appointment</font>
<%else%>
<font color="#FF0000>No Data Found</font>
<%end if%>



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.109375