I have an Access table named CF_SSRSYLN containing several items. I
have queried the table and confirmed. When I attempt to populate an
Oracle "View" (CF_SSRSYLNBB) from the Access table I get only one item.
What am I doing wrong??
<!---Access Table--->
<CFQUERY Name="bbcourses" DataSource="blackboard">
SELECT distinct
CF_SSRSYLN_LONG_COURSE_TITLE,CF_SSRSYLN_TERM_CODE,CF_SSRSYLN_CRN
FROM CF_SSRSYLN
where CF_SSRSYLN_TERM_CODE='#term#'
</cfquery>
<!---Oracle View--->
<cfloop query="bbcourses">
<CFquery Name="bbcourses1" DataSource="ngtbanner">
CREATE OR REPLACE VIEW CF_SSRSYLNBB
(CF_SSRSYLN_LONG_COURSE_TITLE,
CF_SSRSYLN_CRN,
CF_SSRSYLN_TERM_CODE)
as select
'#bbcourses.CF_SSRSYLN_LONG_COURSE_TITLE#',
'#bbcourses.CF_SSRSYLN_CRN#',
'#bbcourses.CF_SSRSYLN_TERM_CODE#'
>From dual
</cfquery>
</cfloop>
Jim Watkins
.......................
North Georgia Tech
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269456
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
