Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error
|
| |
The error occurred in C:/inetpub/agent/blog_search.cfm: line 28
|
26 : </cfloop>
27 : )
28 : AND (FK_AccountID = #var_app_siteID# AND Status = 1)
29 : ORDER BY Tbl_Blog.DateStamp DESC;
30 : </cfquery>
|
|
| SQLSTATE |
08S01 |
| DATASOURCE |
Blog |
| SQL |
SELECT *,
convert(varchar,DateStamp,101) AS BlogDate,
(SELECT CategoryTitle FROM Tbl_BlogCategories WHERE Tbl_Blog.FK_CategoryID = Tbl_BlogCategories.CategoryID) AS CategoryTitle
FROM Tbl_Blog
WHERE
(
Tbl_Blog.Description LIKE '%loan%' AND
Tbl_Blog.Description LIKE '%work-out%' AND
Tbl_Blog.Description LIKE '%package%'
)
OR
(
Tbl_Blog.BlogTitle LIKE '%loan%' AND
Tbl_Blog.BlogTitle LIKE '%work-out%' AND
Tbl_Blog.BlogTitle LIKE '%package%'
OR
Tbl_Blog.Tags LIKE '%loan%' AND
Tbl_Blog.Tags LIKE '%work-out%' AND
Tbl_Blog.Tags LIKE '%package%'
)
AND (FK_AccountID = 56 AND Status = 1)
ORDER BY Tbl_Blog.DateStamp DESC;
|
|
|
Resources:
|
| Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Remote Address |
216.73.216.217 |
| Referrer |
|
| Date/Time |
06-Nov-25 03:27 PM |
|