Dominic,
There are two issues here:
First, is "dos" a date, or a date/time? Now() is a date/time, so it's
not likely you'll match any entries down to the current time. If dos is
just a date, you'd need to manipulate Now() to get the date part of it.
If dos includes the time, you'll need to test on the difference between
dos and Now().
Second, you need to work in ODBC dates/times.
Can you show us how you insert dos?
-David
On Wed, 18 Oct 2000 14:13:38 +0200 "Dominic J. Doucet-Lorang"
<[EMAIL PROTECTED]> writes:
> I am trying to pull information from a database table based upon the
> date
> and a couple of other items. I have tried to use a query wher I
> comparied
> the date column in the table with now() but it gets no results. the
> query
> looks like this:
> <cfquery name="getkundeinfo" datasource="abx2" dbtype="ODBC"
> debug>
> select distinct forsikring.*,kunde.*
> from forsikring, kunde
> where forsikring.refnr = #refnr2# AND forsikring.id =
> kunde.id and dos =
> Now()
> </cfquery>
> It will get results if I remove the dos = Now()
> It needs to just get the records if the date is today also.
>
>
> Dominic
>
>
-------------------------------------------------------------------------
-----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
________________________________________________________________
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
