Some help pls

[MeTin]

Hi all


this is my code iam using to display the RS of my table by specific date and
time :

"SELECT * FROM Students WHERE ex_date >= Date() and ex_time >= Time()

this works but only SOMETIMES so iam stuck and got no idea whats the problem
cause it doesnt give me any errors it just sorts or DOESNT sort information
in the db so its really strange it does display the info sometimes and
sometimes doesnt display ..
in my access DB iam using general date and general time format also on DW MX
2004 i have done it like general date and general time ..
So can anyone give me any idea why this could be happening or any reason or
at least can u redirect me to sort my info from DB to display by specific
date and time i work with ASP..

Kind Rgds MeTin

[bthouin]

What's your DB ? What's the format of the date/time values you have in
your SELECT statement ? have you made a Response.Write of the SELECT
statement to see what you send as a SQL statement ?

And if you want sorting, you have to add "ORDER BY ex_date, ex_time",
otherwise your RS might be all jumbled up, depending on what it finds in
the database.

Why have you 2 separate attributes for date and time ? If you use
genaral date, if I am not mistaken, the time is also in there, so why
split the two ?

Regards
Bernard

MeTin wrote:

> Hi all
>
>
> this is my code iam using to display the RS of my table by specific date and
> time :
>
> "SELECT * FROM Students WHERE ex_date >= Date() and ex_time >= Time()
>
> this works but only SOMETIMES so iam stuck and got no idea whats the problem
> cause it doesnt give me any errors it just sorts or DOESNT sort information
> in the db so its really strange it does display the info sometimes and
> sometimes doesnt display ..
> in my access DB iam using general date and general time format also on DW MX
> 2004 i have done it like general date and general time ..
> So can anyone give me any idea why this could be happening or any reason or
> at least can u redirect me to sort my info from DB to display by specific
> date and time i work with ASP..
>
> Kind Rgds MeTin
>
>

[MeTin]

My DB is acces2000 the values for date and time are general date and general
time and My SELECT statment is * this ..

Regards MeTin

"bthouin" <bernard_thouin@bluewin.ch> wrote in message
news:d1v28c$alp$1@forums.macromedia.com...

> What's your DB ? What's the format of the date/time values you have in
> your SELECT statement ? have you made a Response.Write of the SELECT
> statement to see what you send as a SQL statement ?
>
> And if you want sorting, you have to add "ORDER BY ex_date, ex_time",
> otherwise your RS might be all jumbled up, depending on what it finds in
> the database.
>
> Why have you 2 separate attributes for date and time ? If you use genaral
> date, if I am not mistaken, the time is also in there, so why split the
> two ?
>
> Regards
> Bernard
>
> MeTin wrote:

>> Hi all
>>
>>
>> this is my code iam using to display the RS of my table by specific date
>> and time :
>>
>> "SELECT * FROM Students WHERE ex_date >= Date() and ex_time >= Time()
>>
>> this works but only SOMETIMES so iam stuck and got no idea whats the
>> problem cause it doesnt give me any errors it just sorts or DOESNT sort
>> information in the db so its really strange it does display the info
>> sometimes and sometimes doesnt display ..
>> in my access DB iam using general date and general time format also on DW
>> MX 2004 i have done it like general date and general time ..
>> So can anyone give me any idea why this could be happening or any reason
>> or at least can u redirect me to sort my info from DB to display by
>> specific date and time i work with ASP..
>>
>> Kind Rgds MeTin