Hello everyone and anyone. I'm new to ASP and this is my second time using this forum. So please bear with me. Thanks to mat41 who helped me put this loop together, I have a While...Wend loop that lists times in 30 minute increments. I plan to use this loop in various places in my application. I need to take the results of the loop and compare one of the times to data in a particultar database field (MSSQL). My hope is if the loop result time is the same as the data in the particular database field, then that loop result time should not display on the web page.

Here is the code for the loop that works properly:

<%
Dim strSatOpen
Dim strSatClosed
Dim strSatapptframe
Dim addTime

strSatOpen = ("08:00:00")
strSatClosed = ("17:00:00")
strSatapptframe = "30"
addTime = dateadd("H","0",strSatOpen)
response.write addtime

While addTime < dateadd("H","0",strSatclosed)
addTime = DateAdd("n",strSatapptframe,addTime)
Response.Write "<br>" & addTime
Wend
%>

I need to know how I can capture these loop results and use them on other pages in my application. I've tried the following just to test out my theory:

<%
Dim strSatOpen
Dim strSatClosed
Dim strSatapptframe
Dim addTime

strSatOpen = ("08:00:00")
strSatClosed = ("17:00:00")
strSatapptframe = "30"
addTime = dateadd("H","0",strSatOpen)
response.write addtime
strAvailTime = ("08:30:00") 'this is just a example of assigned data in a database field

While addTime < dateadd("H","0",strSatclosed)
addTime = DateAdd("n",strSatapptframe,addTime)
Response.Write "<br>" & addTime
If addTime <> strAvailTime Then
Response.Write "<br>" & addTime
End If
Wend
%>

All this does is print each time twice. Any and all help is and will be greatly appreciated. :)

You are welcome. I seem to remember some cDate functions in the example I gave you(http://p2p.wrox.com/topic.asp?TOPIC_ID=28101), did you drop them for a reason?

cDate, Trim etc functions are available to us for very good reasons. When comparing strings if they pysically look the same, use these functions to force the data type and format you know you are looking for.
------------------------------
While addTime < dateadd("H","0",strSatclosed)
addTime = DateAdd("n",strSatapptframe,addTime)
Response.Write addTime & "<br>"
If trim(cDate(addTime)) <> trim(cDate(strAvailTime)) Then
     Response.Write addTime & " [is not equal to]<br>"
else
     Response.Write addTime & " [is equal to]<br>"
end if
Wend
-------------------------------------

;;;I need to know how I can capture these loop results and use them on other pages in my application.
I would post the in hidden form fields

;;;All this does is print each time twice
Well that is what you have asked the loop to do. The loop should print each time twice except for "08:30:00". Change your loop to look like my example above and it will do this.

Wind is your friend
Matt