The Mudcat Café TM
Thread #96813 Message #1896391
Posted By: wysiwyg
30-Nov-06 - 07:06 AM
Thread Name: Tech: Help Forum Error
Subject: Tech: Help Forum Error
[Microsoft][ODBC Microsoft Access Driver] System resource exceeded.
SQL = "SELECT Threads.Thread_ID, Threads.Name, Count(Messages.Message_ID) AS MessageCount, Max(Messages.Posted) As LastMessage FROM Messages Messages, Threads Threads WHERE Threads.Thread_ID = Messages.Thread_ID AND Threads.Name Like '%%' GROUP BY Threads.Thread_ID, Threads.Name HAVING Max(Messages.Posted) > (Now()-7) ORDER BY Max(Messages.Posted) DESC"
Data Source = "MUDTROUBLE"
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (16:1) to (31:45) in the template file C:\!webserver\mudhelp\htdocs\threads.cfm.