Close but the index goes after the column name like this: QueryName.ColumnName[QueryName.RecordCount]
- Nate Smith > -----Original Message----- > From: Leon Oosterwijk [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 05, 2001 6:00 PM > To: CF-Talk > Subject: Getting Information from a RecordSet > > > All, > > I'm trying to find a way to get certain information from a > recordset. I need > to get a certain field from the last row of the result of a > query. I know I > can use #RecordCount# to get the number of rows, and I know > the field name. > So now I need a way to get to that information. I assume if would be > something like: > > Recordset[#recordset.RecordCount#].fieldname but this does not work. > > Leon > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
