The Mudcat Café TM
Thread #96813 Message #1897268
Posted By: Tom Hamilton frae Saltcoats Scotland
01-Dec-06 - 05:19 AM
Thread Name: Tech: Help Forum Error
Subject: RE: Tech: Help Forum Error
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 (1) AND DTKeywordSongPairs.SongID=Songs.SongID GROUP BY Songs.SongID,Songs.Title HAVING count(Songs.SongID)=1 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: 12/01/06 05:18:51 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) Remote Address: 80.41.221.60 HTTP Referrer: http://www.mudcat.org/DTKeywords.cfm