Error Occurred While Processing Request

Error Diagnostic Information

ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'and'.

SQL = "SELECT announce_id,announce_name title,city,state,ch_date,announce_cat.announce_cat_id,announce_desc text,city,state,contact_name,e_mail,phone,ext,fax,url,addr1,addr2,zip,announce_cat_name FROM announce_info,announce_cat WHERE announce_cat.announce_cat_id=announce_info.announce_cat_id and sport_code=1 and announce_name like'%>%' and announce_info.announce_cat_id= and ch_date>={ts '2001-02-23 08:22:42'} and del_flag=0 order by ch_date desc"

Data Source = "TDISCOVERY"

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (38:1) to (38:48) in the template file E:\HTTP\TEAMDISCOVERY\Z\QUERIES\ALLANNOUNCESEARCH.CFM.

Date/Time: 03/23/01 08:22:42
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Remote Address: 65.80.86.150
Query String: search=%3E&submit=blehbleh&state=&cat_id=