BellaOnline Forums Computers ASP Urgently Need Help with ASP Loop & Display Script

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)) 'part of 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.

First, why are you bothering to do the dateadds with a value of zero? You're adding zero to something? And if you're going to add zero, why add zero as the "int value of the character 0" instead of just adding the numeric zero?

Just what is replace(string(1," ")," ","<br/>") supposed to be writing out? <img src="/images/graemlins/smile.gif" alt="" />

Let's say that your NewTime is 8:00. The very first thing you do in your while loop is add 30 seconds to your starting time - so now SatOpen. So your AddTime is 8:30. Those obviously aren't the same, so it's going to write it out.

You really need to read through my site and go back to the basics <img src="/images/graemlins/smile.gif" alt="" /> This code is a little convoluted. A loop is a very basic structure, and I cover this sort of thing step by step. I also cover the basics of troubleshooting - always write out BOTH values in each loop run, so you can clearly see what each value is. That will make the problems quite obvious, if you do a response.write of both the whattime and dt(uboudt(dt)) right before each 'if'.