View Single Post
 
Old June 15th, 2004, 09:44 PM
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 Source Selection

I have a database that displays news from a "Open Date" to a "Close Date". Althought I can not get it to work properly. This is the script that selects the stuff from my database.

news_recordset.Source = "SELECT * tdcdate, tdcmessage FROM news_messages WERE date()% => tdcopendate AND =< tdcclosedate"

Please tell me what is wrong, and if i am doing this right at all....

This is the error i am getting:

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression '* tdcdate'.

/testing/index.asp, line 20