Here's my code. I get an error (shown below) and I can't figure out what
I am doing wrong.
I have two tables that are combined by the common PROG_REC_ID field and
want the output to show up only if the two latter conditions are met.
<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, #dbuser#.PROG_RELATED_LINKS
where PROGRAMS.PROG_REC_ID =
PROG_RELATED_LINKS.PROG_REC_ID
where PROGRAMS.prog_emph_id = 1
where
PROG_RELATED_LINKS.PROG_LINK_LKUP_REC_ID = 3
</cfquery>
<cfoutput>
#PROG_RELATED_LINKS.PROG_RL_DESCRIPTION#
</cfoutput>
Error Message:
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00972: identifier is too
long
The error occurred in
/home/httpd/web-dev/www/newsroom/news/ag_biosecurity/testing.cfm: line
14
12 : select "PROGRAMS.PROG_EMPH_ID,
PROG_RELATED_LINKS.PROG_RL_DESCRIPTION,
13 : PROG_RELATED_LINKS.PROG_RL_LINK,
PROG_RELATED_LINKS.PROG_REC_ID,
PROG_RELATED_LINKS.PROG_LINK_LKUP_REC_ID, PROGRAMS.PROG_REC_ID"
14 : from #dbuser#.PROGRAMS, #dbuser#.PROG_RELATED_LINKS
15 : where PROGRAMS.PROG_REC_ID =
PROG_RELATED_LINKS.PROG_REC_ID
16 : where PROGRAMS.prog_emph_id = 1
_____
SQL
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
csdev.PROGRAMS, csdev.PROG_RELATED_LINKS where PROGRAMS.PROG_REC_ID =
PROG_RELATED_LINKS.PROG_REC_ID where PROGRAMS.prog_emph_id = 1 where
PROG_RELATED_LINKS.PROG_LINK_LKUP_REC_ID = 3
DATASOURCE
csdevmaint
VENDORERRORCODE
972
SQLSTATE
HY000
Please try the following:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:486
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
