On 8/30/05, Claude Schneegans <[EMAIL PROTECTED]> wrote: > >>If I just need a count, why would i want to return a recordset? > > A good example of this is when you want to display n records among > "total nb of records". > Some databases allow you to set limits on the records to be returned. > For example in MySQL, in > SELECT ... LIMIT 9, 20 will return only rows 10 to 20, then if you want > to display > "Here are records 10 to 20 of whatever are in the table", you do need a > query to get the total > number of records.
Claude: I wasn't saying that there's never a reason to grab the recordset. I was saying there's not a reason to never need JUST the count (i think that's what i was saying...too many negatives in one sentence confuse me). yes, situations exists where you need the whole shebang. but situations exist as well where you need just the count and nothing more. See the part of my response that you quoted above. "If I need -just- a count..." (emphasis on -just- added) :) -- Charlie Griefer ================================================ "...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216840 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
