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>
