> 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
Hi, I have the same problem that you.. When I try execute the query, I see [Macromedia][SequeLink JDBC Driver]Network problem, session aborted due to internal error in remote procedure call, connection closed. Any help will be excelent! Thanks Fernando ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
