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]
