> No, I am not claiming anything :-) I do see what you mean > though and indeed I think I used to use this method but last > time I checked if you "select from table where value does not > exist" It could/would return NULL or EMPTY STRING when using > query.recordcount? Others seem to think this as well? > Maybe it doesn't anymore?
I have never had it return anything but a non-negative integer, no matter what you SELECT, or even if you don't SELECT at all. For example, if you run an INSERT, UPDATE or DELETE, you will get a non-negative integer for RecordCount - it will usually be zero, but if you have a trigger that SELECTs data the RecordCount will reflect that. It may have done this in some version, but I've never seen it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore and Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254964 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
