|
|
Hi coders,
thanks for the help on my last topic!
now i have another one:
i need to show records that are less than 24 hours in database.
so far i have this:
<% session("tijdnu") = DateAdd("h",-24,Now()) %>
to get the time 24 hours ago
my where statement is:
"SELECT * FROM rented WHERE time < #" + Replace(seen__MMColParam, "'", "''") + "# AND renter = '" + Replace(seen__name, "'", "''") + "'
but it does not show the records the time field is a date/time field "1-12-1900 0:0:00"
the syntax for the time 24 hours ago is correct when i do a response.write is stats the correct time
i am pulling my hair, so i hope someone can shed some light
on this.....
thank, greetzzzz
Sander Kerstens
|
|
|
|
"SELECT * FROM rented WHERE time < #"
should probably be
"SELECT * FROM rented WHERE time > #"
semper fi...
|
|
|
|
mmmm i think you are right, it seems to work now
stupid me.....thanks again
this forum is the best
greetzzz from the netherlands....
|
|
|
|
|
|
|
|
sanderman
