Another hint, when you run a <cfquery> tag in coldfusion, it returns a list of
columns in #queryname.columnlist#.
So to rewrite you code.
<cfif structKeyExists(form,'project_category')>
<cfset project_id = form[form.project_category])>
<CFQUERY NAME="project_retrieval" DATASOURCE="dpch">
SELECT *
FROM empower_project_data
WHERE project_id = #project_id#
</CFQUERY>
</cfif>
<cfoutput query="dpch">
<cfloop list="#dpch.columnlist#" index="col">
#col#<br>
<cfset session[col] = dpch[col][currentRow]>
</cfloop>
</cfoutput>
Untested and just written in this e-mail, but this should be close to what I
THINK you are trying to do.
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207893
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
