The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[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:26:46 +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

Hi Andy,

MYTIME=#1:44:54#

I think

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

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.