View Single Post
 
Old June 16th, 2004, 12:33 AM
gmoney060 gmoney060 is offline
Authorized User
 
Join Date: Mar 2004
Location: , , .
Posts: 84
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to gmoney060 Send a message via MSN to gmoney060
Default

Set news_recordset = Server.CreateObject("ADODB.Recordset")
news_recordset.Source = "SELECT tdcdate, tdcmessage FROM news_messages WERE date()% => tdcopendate AND =< tdcclosedate"
news_recordset.ActiveConnection = objConn
news_recordset.CursorLocation = 2
news_recordset.CursorType = 0
news_recordset.LockType = 1
news_recordset.Open()

now i am getting the error

Microsoft JET Database Engine error '80040e14'

Syntax error in FROM clause.

/admin/index.asp, line 20