Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S0002 (Base table not found)


[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'DTKeywordSongPairs'.


SQL = "SELECT Songs.SongID,Songs.Title FROM Songs,DTKeywordSongPairs WHERE DTKeywordSongPairs.keywordid IN (431) AND DTKeywordSongPairs.SongID=Songs.SongID GROUP BY Songs.SongID,Songs.Title ORDER BY Songs.Title"

Data Source = "MUDCAT"


The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (13:1) to (13:54) in the template file C:\!webserver\mudcat\htdocs\dtkeywords2.cfm.


Date/Time: 06/18/07 14:07:01
Browser: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)
Remote Address: 80.41.209.199
HTTP Referrer: http://www.mudcat.org/DTKeywords.cfm


this is what I get when I try and get the dt keywords, mind you it's being like this since for a few months and it still hasn't been sorted.