> I'm trying to count the number of rows in my select, can > anyone help with this please. > > Does this look right? > > <!-- Retrieve Interview --> > <cfquery name="GetQuestions" datasource="user020"> > SELECT questionID, question, interviewID > FROM tbl_020publicQuestions > WHERE interviewID = #CheckInterview.interviewID# > COUNT as numberOfQuestions
No, I don't think that'll work. Typically, you use COUNT within your SELECT clause. However, in this case, why not just remove it altogether and use the RecordCount variable after you run the query? <cfoutput>#GetQuestions.RecordCount#</cfoutput> 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, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203824 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
