Web Development

Ask something
Discussion Locked

Error information for Frontpage + Access

0 helpful
2 replies

by hunterzh

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Error information for Frontpage + Access (ASP)

I use Access designing a database for project management, including tables and queries; and furthermore use Frontpage to write into (table) and read from (query) this database, as active server pages.
Now we need to search all records whose complete date is between date 1 and date 2; in Access, I have designed a query, with criteria between [date1] and [date2], and it works well. But while I try to read it in Frontpage, it always shows error message, as following:
Database Results Error
Description: Parameter object is improperly defined. Inconsistent or incomplete information was provided.
Number: 3708 (0xE7C)
Source: ADODB.Recordset
Can someone teach me how to make it work properly?

2 replies

by adasys

use this in your sql statement.

select * from tablename where datediff("d",date(),date1) > 0 and ("d",date(),date2) > 0.

Hope this help. Please post more detatila e.g your codes in asp.

This discussion is closed to new replies.