Hi. Did you solve this problem? Iam getting this error...CF 8 and Oracle 11.
> Hi > > I am getting the following error everytime i try to run the query > below from the coldfusion page. > > [Macromedia][SequeLink JDBC Driver]Network problem, session aborted > due to internal error in remote procedure call, connection closed. > > <cfquery name="offerreport" datasource="#placement#"> > SELECT job_info.org_name, job_info.Position, job_info.offer_id, > job_info.accepted_date, job_info.job_id, > job_info.org_id, job_info.job_info_id, job_info.job_type, job_info. > acceptance_status, > offer_list.Offer_type, corporation.title > FROM job_info, offer_list, corporation > WHERE job_info.Student_ID = '#COOKIE.id#' > AND job_info.offer_id *= offer_list.offer_id > AND job_info.org_id *= corporation.org_id > ORDER BY job_info.org_name, job_info.Position > </cfquery> > > The query is fine, it works if i directly run it in the MS SQL Query > Analyzer... > > While submitting the page which has this query, If i click on submit > several times, then in one of the clicks the query gives correct > results. > > Has anyone faced the same problem. If yes, did you get a resolution to > it? > > Thanks Nimesh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
