RE: ASP Question...

["Keith Doxey" <ukha.diyha@xxxxxxx>]

For some reason my messages arent coming through at the moment but I have
seen you latest plea for help via Yahoo.

These are the results of the "=" jury looking for 3min 30
seconds....

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:03:30# ORDER BY SongTitle
----------------------------------------------------------------------------
----

(Nothin' Serious) Just Buggin  00:03:30 WHISTLE
Always On My Mind  00:03:30  Elvis PRESLEY
Coz I Love You  00:03:30 SLADE
Goo Goo Barabajagal  00:03:30 DONOVAN and the JEFF BECK GROUP
Got To Keep On  00:03:30 COOKIE CREW
Let's Get Brutal  00:03:30 NITRO DELUXE
Now That We've Found Love  00:03:30  THIRD WORLD
Street Tuff  00:03:30 REBEL MC
The Groove  00:03:30 Rodney FRANKLIN
View From A Bridge  00:03:30 Kim WILDE
You Got It  00:03:30 Roy ORBISON
You To Me Are Everything  REAL THING

----------------------------------------------------------------------------
----


Hope that helps. BTW the underlying database is Access.

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.