What's the quickest dirtiest way (for testing only) to output all the
field names from a specific table - assuming you've *no* idea what the
field names are to start with and can only get at the table (for the
moment) through a query on a CF page?
Les Mizzell wrote:
What's the quickest dirtiest way (for testing only) to output all the
field names from a specific table - assuming you've *no* idea what the
field names are to start with and can only get at the table (for the
moment) through a query on a CF page?
cfquery
Actually I would add TOP 1 to the select statement that way you are not
obtaining
All records in a LARGE table.
-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 07, 2006 5:14 PM
To: CF-Talk
Subject: Re: Output list of fields names from table
Les
Coldfusion wrote:
Actually I would add TOP 1 to the select statement that way you are not
obtaining All records in a LARGE table.
I found that out REAL fast! Well, REAL slow actually
Thanks,
Les
~|
Introducing the
I would add WHERE 1=0 just so no records are returned.
M!ke
-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 07, 2006 4:14 PM
To: CF-Talk
Subject: Re: Output list of fields names from table
Les Mizzell wrote:
What's the quickest dirtiest way
On Saturday 07 October 2006 16:34, Dawson, Michael wrote:
no records are returned.
And as someone else suggested in another thread, you should add the function
getBeer(Heineken) to that.
~|
Introducing the Fusion Authority
I would add WHERE 1=0 just so no records are returned.
Assuming the database driver is smart enough not to evaluate the
expression for every record ;-)
The longest time may not be for the number of records returned, but for
the number of records
tested.
May be better use some indexed id field
7 matches
Mail list logo