> Is there a more efficient way to determine how many products are in the > products.txt table than the following? > > [loop search="ml=1000"] > [tmp my_counter][calc] [scratch my_counter] + 1 [/calc][/tmp] > [/loop] You can do a "select count(code) from products". Jeff