Question
Connection reset by peer socket write error - Sql server error
Hi Folks
I keep getting the error above recently, if I take out this query all the other queries on the page work fine. The query below is highlighted in the error message:
<cfquery name="calendar" datasource="calendar">
SELECT *
FROM events
WHERE
(eventstart BETWEEN #weekstart# AND #weekend#
OR eventend BETWEEN #weekstart# AND #weekend#)
AND (eventend >= #currentdate#) <<<< this line of code is highlighted in the error message
AND (eventgp = 0 OR eventgp is null)
AND eventhide != 1
ORDER BY eventstart
</cfquery>
That code has been working fine for the past two years, however its just started to appear very frequently.
Can anyone please help?
Many thanks
