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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
