The Mudcat Café TM
Thread #102598   Message #2080138
Posted By: guitar
18-Jun-07 - 02:09 PM
Thread Name: error - DT Keywords
Subject: 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 (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:
HTTP Referrer:

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.