Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '='.
|
|
The error occurred in C:/inetpub/intranet/Newsletter/FullNewsletter.cfm: line 31
Called from |SQLServer|6.0.0.1282|: line 1103
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2035
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from |SQLServer|6.0.0.1282|: line 1103
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2035
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from C:/inetpub/intranet/Newsletter/FullNewsletter.cfm: line 31
|
29 : On A.ArticleID = I.ArticleID
30 : And I.ArticleImage = 'Y'
31 : Where A.ArticleID = #GetNewsletter.FeaturedArticleID#
32 : </cfquery>
33 :
|
|
SQLSTATE |
HY000 |
EXCEPTIONS |
<small><i>not set</i></small> |
DATASOURCE |
D7SQL |
VENDORERRORCODE |
102 |
SQL |
Select A.ArticleID, A.LocationID, I.URL ImageURL, A.Title, A.Body, A.PostedDate, A.StartDate, A.EndDate
From OnlineForms.dbo.NL_Articles A
Left Join OnlineForms.dbo.NL_Attachments I
On A.ArticleID = I.ArticleID
And I.ArticleImage = 'Y'
Where A.ArticleID = |
|
Resources:
|
Browser |
claudebot |
Remote Address |
172.16.255.1 |
Referrer |
|
Date/Time |
28-Mar-24 12:46 PM |
|