Yep, that was it. Well done Mark. There were some NULL values in Trail. I had "AND TrailerIncome > 0" in one of the feeder queries, and when I added the apparently redundant line "AND TrailerIncome IS NOT NULL", it worked.
First successful QofQ. Yay ! btw, I thought CFDUMP was used on to show names of variables, not their values. I tried using the bottom code, but nothing displayed. Could be it was either reading the NULLs first, or not getting past them ? > At first glance I would say that: > > WHERE Trail > 150 > > is throwing the error. If you <cfdump var="#Holder#"> what do you see? If > you loop over the Trail column & check the data type (isNumeric()) what do > you get? > > > Cheers > > Mark > > > ------------------ > Mark Stanton > Technical Director > Gruden Pty Ltd > Tel: 9956 6388 > Mob: 0410 458 201 > Fax: 9956 8433 > http://www.gruden.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
