In CFSTUDIO, type in <CFQUERY and then click your mouse somewhere
inside
CFQUERy and press F1. This will open up help for the CFQUERY tag
where you
will find the following information:
In addition to returning data from a ColdFusion data source, the
cfquery
tag also returns information about the query. cfquery.ExecutionTime
returns
the time it took the query to execute in milliseconds.
The cfquery tag creates a query object, providing information in query
variables as described in the following table. Variable Name
Description
query_name.recordCount
The number of records returned by the query.
query_name.currentRow
The current row of the query being processed by cfoutput.
query_name.columnList
A comma-delimited list of the query columns.
You can cache query results and execute stored procedures. For
information
about caching cfquery results, executing stored procedures, and
displaying
cfquery output, see Developing ColdFusion Applications.
This was just asked yesterday as well.
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
[EMAIL PROTECTED]
-----Original Message-----
From: Jerry Staple [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 10:40 AM
To: CF-Talk
Subject: Output Field Names
Hi,
Does anyone know if there is anyway that you can output the Field
names (Column Names) for a specific table in a <cfquery>?(using access
db).
Jerry Staple
Web Applications Developer
BizNet Solutions
133 - 137 Lisburn Rd
Belfast
BT9 7AG
Tel: +44 (0)28 9022 3224
Fax: +44 (0)28 9022 3223
www.biznet-solutions.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
