My IT person will not allow me to create/edit Oracle Tables but will allow me to create Views. I can create the table in Access (different data source) and populate with that view. I am free to edit the Access table but need to convert it back to a View to continue using the Oracle data source and that is where I get stuck.
Jim Watkins, Ed.d ....................... North Georgia Tech Blairsville 706 439-6340 Clarkesville 706 754-7850 [EMAIL PROTECTED] -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Sunday, February 11, 2007 7:37 PM To: CF-Talk Subject: Re: Access to Oracle View 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:269483 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
