Hello everyone and anyone. I'm new to ASP and this forum. So please bear with me. I had someone help me with this script which works great. It's purpose is to (1) generate times in time given increments and (2) compare these times to data in a particular database field (MSSQL). If any of the generated times match the database data, the matching generated times are not to display. I attempted to tweak it a little to see if I could do this. Here's the code:

<%
Dim varSatOpen
Dim varSatClosed
Dim varSatapptframe
Dim addTime
Dim newTime 'what I added
Dim whatTime 'what I added

dim dt() : redim dt(-1)

varSatOpen = ("08:00:00")
varSatClosed = ("17:00:00")
varSatapptframe = "30"
addTime = dateadd("h",cint("0"),varSatOpen)
response.write addtime
newTime = ("09:00:00") 'what I've added
whatTime = dateadd("h",cint("0"),newTime) 'what I've added

Do While addTime < dateadd("h",cint("0"),varSatclosed)
addTime = DateAdd("n",cint(varSatapptframe),addTime)
redim preserve dt(ubound(dt)+1)
dt(ubound(dt))=addTime
If whatTime <> dt(ubound(dt)) Then 'what I've added
response.write replace(string(1," ")," ","<br/>") & dt(ubound(dt)) 'from original script
End If 'what I've added
Loop
%>

It works fine until the variable "newTime" is changed to times such as "08:00:00", "08:30:00", or "14:30:00". These times continue to display when they shouldn't. Any ideas what I've done wrong?

Again, any and all help is greatly appreciated.

I am sorry, but I do not understand the problem fully. Is it that when you change "newTime" to 08:30:00, it starts displaying from 08:00:00 onwards ? If that is the case, it must be because of cache.

You can prevent pages from going to cache using following code at the very top of the page.

Response.AddHeader "Pragma","no-cache"
Response.AddHeader "cache-control","no-cache,must revalidate"
Response.Expires =-1

pupadu

Yes I remember assisting you - why wouldnt you continue the same post?


Wind is your friend
Matt