> > Try currentrow. Also tied to recordcount.
...
> Thanks. Is there a good online reference for this kind of thing? Or a
> good book? I searched and looked over a few sites, but found nothing
> really helpful. Also, there's nothing in any of the BF books. I assume
> this is standard SQL.
No, this is part of CF. Whenever you execute a query that returns a
recordset, you'll get some information about the query.
queryname.RecordCount - number of records
queryname.CurrentRow - available when looping over a query using CFOUTPUT or
CFLOOP with the QUERY attribute
queryname.ColumnList - comma-delimited list of column names
CFQUERY.ExecutionTime - the time required to execute the query, in
milliseconds. Note the use of the literal "CFQUERY" for
this one.
I believe that all of these are listed within the Allaire documentation, but
they're not going to leap out at you, I'll admit.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
