assuming that you meant:
select a as foo, c as goo
from alpha
where c = 700
when done inside a cfquery a variable is returned with a list of the column
names. The variable is: query_name.columnList
so...
<cfquery name="myQuery" datasource="myDatasource">
select a as foo, c as goo
from alpha
where c = 700
</cfquery>
would return the query plus myQuery.columnList = "foo,goo"
Steve
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 12:20 PM
To: CF-Talk
Subject: getting query results
I'm making a dynamic select statement..
Where you have an open form on one page
you type in any query you want and it processes the
query on the next.
The problem I'm running into is on the select statement
Say for example you have
SELECT a, c FROM alpha
WHERE c = 700
how would I grab the foo, goo so I could generate table columns for them?
Also any help in the actual generating the table would be helpful.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
