Thanks for your help guys, yes, it was as simple as that #GetQuestions.RecordCount# and I'd forgot it!
Thanks to all those who responded! :) On 21/4/05 5:44 pm, "Dave Watts" <[EMAIL PROTECTED]> wrote: >> 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! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:203828 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
