error report

[alun]

I quite often get this error when looking at the Misc Aviation forum.....

Error Executing Database Query.

[Macromedia][sqlServer JDBC Driver][sqlServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

 

The error occurred in D:\wwwroot\mooneyspace\forums\cfcs\cf4emPosts.cfc: line 232

Called from D:\wwwroot\mooneyspace\forums\dsp\dsp_threads.cfm: line 160

Called from D:\wwwroot\mooneyspace\forums\cf4em.cfm: line 110

Called from D:\wwwroot\mooneyspace\index.cfm: line 91

Called from D:\wwwroot\mooneyspace\forums\cfcs\cf4emPosts.cfc: line 232

Called from D:\wwwroot\mooneyspace\forums\dsp\dsp_threads.cfm: line 160

Called from D:\wwwroot\mooneyspace\forums\cf4em.cfm: line 110

Called from D:\wwwroot\mooneyspace\index.cfm: line 91

230 : 		FROM cf4em_posts join cf4em_threads on cf4em_posts.threadID = cf4em_threads.threadID 

231 : WHERE cf4em_threads.threadID = #arguments.threadID#

232 : and cf4em_posts.dateadded > (SELECT lastviewed FROM cf4em_newPosts WHERE cf4em_newPosts.UserID = #arguments.userID# AND cf4em_newPosts.threadID = #arguments.threadID#)

233 : ORDER BY cf4em_posts.dateadded asc

234 : </cfquery>

---

SQLSTATE

  21000

SQL

   SELECT TOP 1 PostID FROM cf4em_posts join cf4em_threads on cf4em_posts.threadID = cf4em_threads.threadID WHERE cf4em_threads.threadID = 330 and cf4em_posts.dateadded > (SELECT lastviewed FROM cf4em_newPosts WHERE cf4em_newPosts.UserID = 101 AND cf4em_newPosts.threadID = 330) ORDER BY cf4em_posts.dateadded asc

VENDORERRORCODE

  512

DATASOURCE

  mooneyspace

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.

Search the Knowledge Base to find a solution to your problem.

 

Browser  

Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)

Remote Address  

87.244.98.244

Referrer  

http://www.mooneyspace.com/index.cfm?action=forums

Date/Time  

17-Sep-09 07:24 AM

Stack Trace (click to expand)