Thanks for your response.

I use mysql.
I wrote the element you told me in one line, not two lines, but it didnt work.

The code line of the master page is:

Recordset1.Source = "SELECT * FROM 29articles WHERE datew<=now() ORDER BY datew DESC"

The code line of detail page is:

Recordset1.Source = "SELECT * FROM 29articles WHERE Id = " + Replace(Recordset1__MMColParam, "'", "''") + ""


Thanks in advance

Where is the AND clause I showed you for the Details page? It's missing.

Also, is Now() supported in MySQL??

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks for your response.

Now() is supported in mysql, i use it in master page.

The code line of detail page is without the addition you told me.
I added it and it gave the error i posted previously.

Here is the complete line that give me the error

Recordset1.Source = "SELECT * FROM 29articles WHERE Id = " + Replace(Recordset1__MMColParam, "'", "''") + "AND datew <= Now()"

What should be changed in order the page display normally?

Thanks in advance

You accidentally left out a space I had in my original post:

 "AND datew <= Now()"

should be

 " AND datew <= Now()"

with a space before the AND keyword to separate it from the first WHERE clause.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

You were right!

Now everything is ok, and nobody can view the records of the future dates.

You really helped me a lot.
Thank you very much, I appreciate much your support.

You're welcome. Glad you got it working.

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.