Message 9/12
Date: 07-Dec-01 @ 01:40 PM -
RE: k, having a problem
k, some more info, dunno how usefull it is tho, i clicked on forums then got this :
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] Not enough space on disk.
SQL = "SELECT Threads.Thread_ID, Threads.Name, Count(Messages.Message_ID) AS MessageCount, Max(Messages.Posted) As LastMessage FROM Threads Threads, Messages Messages WHERE Threads.Thread_ID = Messages.Thread_ID AND Threads.chatter_id = 1 GROUP BY Threads.Thread_ID, Threads.Name HAVING Max(Messages.Posted) > (Now()-7) ORDER BY Max(Messages.Posted) DESC"
Data Source = "DT_2001"
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (19:1) to (19:45).
Date/Time: 12/07/01 13:37:03
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461)
Remote Address: 62.252.32.4
HTTP Referer: http://www.dancetech.com/aa_dt_new/forums/chatter-index.cfm?CHATTER_ID=1
Query String: chatter_id=1