repost again :) sorry

[MeTin]

Hi all


any idea how to display specific record on current date and time of the day
...
i did managed to display it for the date and drop it on specific date but
couldn manage it to dispay on speci,fic time of the date (for example 6
o'clock in the evening drop from the list)
i work with ASP and access 2000 and i have done it like

SELECT *
FROM students_table
WHERE students_pass_exam <=now
ORDER BY students_pass_exam ASC

So can u pls help me out how to do it to dissapear at the current time of
the last day instead of after midnight of the last date ...


Pls gimme some tips ..


Rgrds MeTin

[CMBergin]

Your students_pass_exam field must have a time. Then, kill the equal sign.
WHERE students_pass_exam < NOW()

If your field has a time, the comparison will end up being something like
WHERE '2/28/2005 18:00:00' < '2/28/2005 07:25:57'

So this record will still display, but at 6:00 tonight, it will no longer
display on newly requested pages.


"MeTin" <metinyaman@hotmail.com> wrote in message
news:cvq326$8jn$1@forums.macromedia.com...

> Hi all
>
>
> any idea how to display specific record on current date and time of the

day

> ..
> i did managed to display it for the date and drop it on specific date but
> couldn manage it to dispay on speci,fic time of the date (for example 6
> o'clock in the evening drop from the list)
> i work with ASP and access 2000 and i have done it like
>
> SELECT *
> FROM students_table
> WHERE students_pass_exam <=now
> ORDER BY students_pass_exam ASC
>
> So can u pls help me out how to do it to dissapear at the current time of
> the last day instead of after midnight of the last date ...
>
>
> Pls gimme some tips ..
>
>
> Rgrds MeTin
>
>