Yes, I would like to be able to access the collection of employees
within each department.
Ryan
On Wed, 26 Jan 2005 11:41:54 -0500, Adrocknaphobia
<[EMAIL PROTECTED]> wrote:
> Are you expecting to return the full object to CF?
>
> -Adam
>
>
> On Wed, 26 Jan 2005 11:17:16 -0500, Ryan Scott <[EMAIL PROTECTED]> wrote:
> > When I run the following query
> >
> > <cfquery datasource="Test" name="objectView">
> > select departmentcode, emp_list from dept_view
> > </cfquery>
> >
> > against an oracle object view which returns a collection of employee
> > object types within a department:
> >
> > dept_code, dept_name, employees.
> >
> > using the DataDirect JDBC Drivers I get the following error:
> >
> > [Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent
> > datatypes: expected NUMBER got RYSCOTT.EMPLOYEES_T
> >
> > When I change the driver to the oracle thin driver I get this as output:
> >
> > A00060 class [Ljava.lang.Object; F00245 class
> > where A00060 is the department code and [Ljava.lang.Object is I am
> > guess the Employee Object.
> >
> > If I try and use a jdbc driver within CFSCRIPT:
> >
> > dsService = CreateObject("java",
> > "coldfusion.server.ServiceFactory").DataSourceService;
> > l_datasource= dsManager.getDataSource('<oracle_thin_driver>')
> > conn = l_datasource.getConnection()
> > ps = conn.prepareStatement("Select * from dept_view");
> > ps.executeQuery();
> >
> > conn.close();
> >
> > I get this error
> >
> > [Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent
> > datatypes: expected NUMBER got RYSCOTT.EMPLOYEES_T
> >
> > even though I have used the oracle thin drivers.
> >
> > Has anyone been able to query an object view from within coldfusion mx?
> >
> > Thanks
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191854
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
