Ive got a few questions with some asp programming that I'm having a really hard time solving. If anybody out there can give me a hand with my questions it would be greatly appreciated.
What I'm dealing with is several tables with 100,000 records in each. It all has to be searchable and display the appropriate information depending on the search queries. One of the fields needs to be totaled up and I'm running into an issue with memory use. 100,000 records does not total up very nicely.
The other thing that i'm working with is being able to access each table via a seach box on a previous page. My current problem is that I'm getting this error
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in query. Incomplete query clause.
and the query clause looks as such:
SQL = "SELECT * From '" & strSearch & "'"
So if there is anybody that might have a few things for me to try, or even better solutions to these problems that would be great.
You can e-mail me, msn, icq or just a simple reply to this thread.
Question
mstrmind
Ive got a few questions with some asp programming that I'm having a really hard time solving. If anybody out there can give me a hand with my questions it would be greatly appreciated.
What I'm dealing with is several tables with 100,000 records in each. It all has to be searchable and display the appropriate information depending on the search queries. One of the fields needs to be totaled up and I'm running into an issue with memory use. 100,000 records does not total up very nicely.
The other thing that i'm working with is being able to access each table via a seach box on a previous page. My current problem is that I'm getting this error
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in query. Incomplete query clause.
and the query clause looks as such:
SQL = "SELECT * From '" & strSearch & "'"
So if there is anybody that might have a few things for me to try, or even better solutions to these problems that would be great.
You can e-mail me, msn, icq or just a simple reply to this thread.
Many thanks,
Mstrmind
Link to comment
Share on other sites
2 answers to this question
Recommended Posts