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
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
