var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Time in ASP
Assume that all of time was kept in variable which is array like this. Note that tiorder is time
sql="select top 1 * from ("&namecompany2(i2)&") where price <= "&limitprice2(j2)&" and ti > #&tiorder2(t2)&#"
The problem is ti > #&tiorder2(t2)&#" it doesn't work
Note that tiorder2(t2) keep time
I think you are trying for something like....
Actually you are probabyl better to go with a CDate idea like...
ti > "#" & tiorder2(t2) & "#"
At least then you know you are comparing two dates...
CDate(ti) > CDate(tiorder2(t2))
Last edited by rokslide; 09-27-04 at 00:22.
The type of time that I use in column ti is date/time hh:nn:ssAM/PM
errgghhh.... that's not good.... okie, something that will work.... (although there may be better ways, I haven't played much with time values)
reformat your time to 24 hour using something like...
24Hour(ti) > 24Hour(tiorder2(t2))
Function 24Hour (myTime)
arrTime = split("9:00:01AM",":")
AMPM = mid(arrTime(2),3)
myHour = arrTime(0)
myMinute = arrTime(1)
mySecond = left(arrTime(2))
if AMPM="PM then myHour = myHour +12
24hour = myHour & myMinute & mySecond