Error Diagnostic InformationODBC 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 |