RE: ASP Question...

[andy.powell@xxxxxxx]

Keith,

can you try = rather than > or <

Thanks

A.





"Keith Doxey" <ukha.diyha@xxxxxxx>
29/03/2001 16:41
Please respond to ukha_d


To:     <ukha_d@xxxxxxx>
cc:
Subject:        RE: [ukha_d] ASP Question...

Just tested it on my Jukebox and it works.....

SELECT TOP 20 Artist.ArtistID, SongID, ArtistFirstName, ArtistName,
ArtistLink, ArtistSuffix, SongTitle, SongDuration, SongMP3, SongCD FROM
Song
INNER JOIN Artist ON Song.ArtistID=Artist.ArtistID WHERE Song.SongDuration
>
#00:06:00# ORDER BY SongTitle

List the first 20 songs where the duration is greater than 6 minutes.

Keith

-----Original Message-----
From: andy.powell@xxxxxxx [mailto:andy.powell@xxxxxxx]
Sent: 29 March 2001 15:19
To: ukha_d@xxxxxxx
Subject: [ukha_d] ASP Question...


Folks,

just a quickie re: ASP and Access...

How do I search for records matching a TIME (i.e. The field type is
date/time) ?? What's the SQL for it??

I've tried

Select * from MyTable where MYTIME='1:44:54'

but this gives an ODBC error 80040e21 - ODBC Driver does not support the
requested properties..


any clues???

Ta muchly

A.


************************ DISCLAIMER ************************
This message is intended only for use by the person
to whom it is addressed. It may contain information
that is privileged and confidential. Its content does
not constitute a formal commitment by Lombard Odier.
If you are not the intended recipient of this message,
kindly notify the sender immediately and destroy this
message. Thank You.
*****************************************************************







Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/







Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/