CFQuery - metadata
You learn something new everyday! I Just discovered that in Coldfusion 7 you can get query infomation (metadata) by adding result = 'aVariable' to the cfquery tag.
for example:
select * from aTable
</cfquery>
<cfdump var="#aVariable#">
COLUMNLIST (the names of the columns returned)
EXECUTIONTIME (time to execute query ms)
RECORDCOUNT (rows returned)
SQL (the sql that was executed)
I use it mainly to see the sql that is executed from dynamically created sql.
Sponsored Links
Archives By Subject
BlogCFC (2)Coldfusion (18)
CSS (4)
Design (5)
Javascript (1)
Life (7)
PhotoShop (5)
SQL (5)
Technology (5)
The Web (7)
Calendar
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | 6 | |
| 7 | 8 | 9 | 10 | 11 | 12 | 13 |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| 21 | 22 | 23 | 24 | 25 | 26 | 27 |
| 28 | 29 | 30 | 31 |
Recent Comments
Multiple SQL inserts: Oracle, Mysql, MssqlJAYESH TALSANIYA said: in mssql u cannot use parentheses in select statement. use as below: INSERT INTO [TABLE] (column1,... [More]
Multiple SQL inserts: Oracle, Mysql, MssqlJD said: I found with MSSQL, I couldn't use parentheses in my select statements for insert. So, from your ex... [More]
BlogCFC ping list and timeoutsWill Wilson said: Nice :) that will come in handy, thanks! [More]
Is this a Coldfusion 8 BUGBarb said: I'm having the same problem . . . when I start CF8, it seems to hang during or just after the user M... [More]
Is this a Coldfusion 8 BUGJoão Fernandes said: Phil, when you install CF8 they give you an option to install LCDS within CF. The messageBrokerServl... [More]
Bookmarks
Russ Michaels blogw3csites.com
riaforge.org
smashingmagazine.com
coldfusioncommunity.org
succor.co.uk
cssplay.co.uk
hotukdeals.com
feedicons.com
coldfusionjedi.com
alistapart.com
photoshopcandy.com
Recent Entries
Eclipse Oracle PluginWhere is my iPhone - o2 poor servic
Cheapest iPhone on the internet
Is this a Coldfusion 8 BUG
Online CSS Layouts designer
There are no comments for this entry.
[Add Comment]