Re: Query Help Please

I dont believe this is working with Access DB SUM(CASE WHEN o.Date IS NULL THEN 0 ELSE 1 END) ordersFound C S <[EMAIL PROTECTED]> wrote: >select *, exists ( >select * >from orders >where date between #date1# and #date2# >) as hasOrdered >from customers >order by name, id > >Use CFQUERYPARAM

Query Help Please

I will try to make this as simple as possible. Any help would be greatly appreciated. I have 2 tables like below. tblCustomers === ID | Name | Email | 1, John, [EMAIL PROTECTED] 2, Bob, [EMAIL PROTECTED] 3, Steve, [EMAIL PROTECTED] =

Coldfusion Array help

Im not that familiar with Coldfusion and I'm learning. I have spent alot of time with no luck. Can someone please take a peek at my code and help me arrange this data correctly. Any help much appreciated. - The data is set from a JS v