I would think because sometimes you would need to pass in not only the field names to select but also some criteria as to how it is grabbed. Such as something that needs to go into the FROM or WHERE portions of the query. For the example Russ gave you would need to pass in the name of the column(center) and also its value neither of which is a lot to pass in but if you had more than one column it(call to the function) could start to get big. Hope that makes sense, it is way past my bedtime right now :)
On 12/18/05, Stan Winchester <[EMAIL PROTECTED]> wrote: > > Why not just pass the fields you want to return data as an argument. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:227257 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54