[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
RE: ASP Question...
- To: <ukha_d@xxxxxxx>
- Subject: RE: ASP Question...
- From: "Keith Doxey" <ukha.diyha@xxxxxxx>
- Date: Thu, 29 Mar 2001 15:41:56 +0100
- Delivered-to: rich@xxxxxxx
- Delivered-to: mailing list ukha_d@xxxxxxx
- Mailing-list: list ukha_d@xxxxxxx; contact
ukha_d-owner@xxxxxxx
- Reply-to: ukha_d@xxxxxxx
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/
Home |
Main Index |
Thread Index
|