Andy,
it gives me no returns even when there are 2 possible returns it should be
returning. I have set up 2 records that should match the query tests. I
am no longer getting the syntax error I was.
Dominic
At 01:08 PM 10/24/00 +0100, you wrote:
>Try putting hashes around dos and using = rather than LTE. You also have a
>bracket missing around your ABS function like so:
>
><CFQUERY name="getkundeinfo" datasource="abx2" dbtype="ODBC">
> select distinct forsikring.*,kunde.*
> from forsikring, kunde
> where kunde.kundenr = #kundenr2# AND forsikring.id = #salg# AND
> forsikring.id = kunde.id and Abs(datediff("d", #dos#, #dos2#)) = 30
></CFQUERY>
>
>If this doesn't work try replacing the "d" in the datediff function with
>"dd" or "day"
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]