Zac123
asked on
cfquery, columnList results display twice
i'm using this query to pull column names:
SELECT *
FROM ProdFields
WHERE 1 = 2
i'm using this to output the results:
<cfset ColList = listChangeDelims(valueList
<cfoutput>#ColList#</cfout
the table that i'm querying only has two columns currently but i view the output i see them duplicated like so:
AUTOID
PRODNAME
AUTOID
PRODNAME
any ideas why?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yeah i tried that first off. but the output is just:
#ColList# and not data
#ColList# and not data
Please show your block of code all around this item..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
To show the column names, try
<cfset ColList = listChangeDelims(GetCurren tProdField Names.colu mnList,</b r>)>
<cfoutput>#ColList#</cfout put>
<cfset ColList = listChangeDelims(GetCurren
<cfoutput>#ColList#</cfout
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
oh crap, of course... you are trying to show the list of column names...
Good catch agx
I couldn't see the forest through all the trees
That was me yesterday :) Tag, you're it.
ASKER
LOL
sorry for slow reply. had to travel home.
thanks for you input peeps.
agx was right, didnt need the value list in there. seems to be working great!
many thanks
zac
sorry for slow reply. had to travel home.
thanks for you input peeps.
agx was right, didnt need the value list in there. seems to be working great!
many thanks
zac
ASKER
sorry for planting so many trees! :-)
ASKER
i.e. i now have 5 columns so the output block repeats 5 times.