> heh - that was perty cool to read as opposed to the code that inspired it:
WHERE (((ctlstat.status)='C') #bname_where4# AND (((ctlstat.statuslast) Is Null) OR ((ctlstat.statuslast)='P')) AND ctlstat.statuschange BETWEEN #CreateODBCDateTime(rptlastweek)# AND #CreateODBCDateTime(rptenddate)#) You know, every column name needs its own set of parenthesis, separate from the set of parenthesis required for every logical comparison (((with the (exception) of) (between) comparisons) ((which don't need (either)) of them))... <sigh>... s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase Studio MX with Flash Pro from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=51 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:165606 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
