You are looping over each row of the query and replacing the view with the current row each time.
Out of interest, is there a reason for creating an Oracle view rather than just populating a table in this case? On 2/11/07, James Watkins <[EMAIL PROTECTED]> wrote: > 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:269481 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
