PROBLEM:
1. I am continually inserting fields into a table (2-3/mth).
2. I would like my script to know how many fields exist; and
3. to be able to list them and
4. pull data from them.
<!--- 1. --->
I got part one (which I thought was going to be the hard part) and I'm able
to list them (3.)
<cfquery>
select name from syscolumns where upper(name) like '...' and id =
object_id('...')
</cfquery>
So far so good.
<!--- 2. --->
I'm stumped on 2 -- which I thought was going to be the easy part.
I thought I could put the result into a list and work off the list.
<cfset tmp = Evaluate("name")>
#ListLen(tmp)#
No go. :-)
<!--- 3 --->
<cfoutput>#name#</cfoutput> works nicely
<!--- 4 --->
haven't gotten to yet
thx for any clues
// gilbert midonnet
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
