Thanks, I just tried this and am still getting an error at:
http://web-dev.csrees.usda.gov/newsroom/news/ag_biosecurity/testing.cfm
<cfquery name="Programs" datasource="#dsn#" username="#dbuser#" >
select p.PROG_EMPH_ID, l.PROG_RL_DESCRIPTION,
l.PROG_RL_LINK, l.PROG_REC_ID, l.PROG_LINK_LKUP_REC_ID, p.PROG_REC_ID
from PROGRAMS p and PROG_RELATED_LINKS l
where p.PROG_REC_ID = l.PROG_REC_ID
and p.prog_emph_id = 1
and l.PROG_LINK_LKUP_REC_ID = 3
</cfquery>
<cfoutput query ="Programs">
<Ul>
<li>#PROG_RELATED_LINKS.PROG_RL_DESCRIPTION#
</li>
</Ul>
</cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:501
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
