Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Server error: Unable to retrieve schema information from the query:

Status
Not open for further replies.

oleghub

Technical User
Dec 21, 2002
2
US
Hello,
I'm trying to extract data from the database using Front Page 2000. The qry is:
"SELECT * FROM Results WHERE MemberID = '" + Replace ( MemberID, "'","''") + "' and (Validated = 'ON');".
It is working fine.
When I opening the file to make some changes using notepad, everything is good. But the problem is that I cannot open the file with this code in Front Page. It is rewriting this code by itself.

What is wrong with this code, and is there some way to fix this.
Any ideas?

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top