[thelist] something wrong with my SQL query

[rudy]

> There's no significance in using the number 1

at the risk of flaying the already dead horse some more...

yes, there is no significance in the number 1 (i use it a lot in
WHERE EXISTS subqueries), except for one thing --

you'll get as many 1's as there are rows in the table

if there are thousands of rows, you will get thousands of 1's

maybe it's me, but i'd rather have the slick performance
that comes with getting only one row that contains count(*)

;o)


> but it quite handily equates to true in PHP...

that "handiness" can bite you

ask ben in that other thread on recordcount in cfmx


rudy