Ok I've cleaned it up but cannot comprehend how to so the aliasing so I have
left that part as is. Code is below. But I still get an error which can be
found at:
http://web-dev.csrees.usda.gov/newsroom/news/ag_biosecurity/testing.cfm
<cfquery name="Programs" datasource="#dsn#" username="#dbuser#" >
select PROGRAMS.PROG_EMPH_ID,
PROG_RELATED_LINKS.PROG_RL_DESCRIPTION,
PROG_RELATED_LINKS.PROG_RL_LINK,
PROG_RELATED_LINKS.PROG_REC_ID, PROG_RELATED_LINKS.PROG_LINK_LKUP_REC_ID,
PROGRAMS.PROG_REC_ID
from #dbuser#.PROGRAMS and #dbuser#.PROG_RELATED_LINKS
where PROGRAMS.PROG_REC_ID =
PROG_RELATED_LINKS.PROG_REC_ID
and PROGRAMS.prog_emph_id = 1
and PROG_RELATED_LINKS.PROG_LINK_LKUP_REC_ID = 3
</cfquery>
<cfoutput query ="Programs">
<Ul>
<li>#PROG_RELATED_LINKS.PROG_RL_DESCRIPTION#
</li>
</Ul>
</cfoutput>
</body>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:497
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
