Solve : Frontpage form query problem?

1.	Solve : Frontpage form query problem?
Answer» When I click Submit Query on my search page, the database returns all results as opposed to the search CRITERIA entered. In fact, I can leave all fields blank and it will STILL return all results in the database. The page (still very much under construction) is located at http://www.driverreport.org/driversearch.asp Any ideas on this one? Is it an IIS server you're using with Access database?It is an Access database, however I am not sure what an IIS server is. I know it is on a Windows server (if that helps) Yes, IIS in the same as Windows. I'm sorry I don't know much about Access databases, so all I can do is point you in the right direction. http://www.stardeveloper.com/articles/display.html?article=2000051001&page=1 http://www.hotscripts.com/category/asp/scripts-components/search-engines/Thanks again kpac. I am glad I cam ACROSS this forum. I have posted to many forums across the web and this one blows all the others out of the water as far as knowledge and promtness. No problem and glad I could help. Quote from: kpac on March 18, 2010, 12:08:33 PM I'm sorry I don't know much about Access databases ACTUALLY- it uses pretty much the same SQL your familiar with from MySQL. in this case, it simply looks like there is no actual query being CREATED from the POST'ed data; that is, it is returning all records simply because it hasn't been told otherwise (think, performing a "query" that is just the table name- it returns the entire contents of the table).

Answer»

When I click Submit Query on my search page, the database returns all results as opposed to the search CRITERIA entered. In fact, I can leave all fields blank and it will STILL return all results in the database. The page (still very much under construction) is located at http://www.driverreport.org/driversearch.asp

Any ideas on this one? Is it an IIS server you're using with Access database?It is an Access database, however I am not sure what an IIS server is. I know it is on a Windows server (if that helps) Yes, IIS in the same as Windows.

I'm sorry I don't know much about Access databases, so all I can do is point you in the right direction.
http://www.stardeveloper.com/articles/display.html?article=2000051001&page=1
http://www.hotscripts.com/category/asp/scripts-components/search-engines/Thanks again kpac. I am glad I cam ACROSS this forum. I have posted to many forums across the web and this one blows all the others out of the water as far as knowledge and promtness. No problem and glad I could help. Quote from: kpac on March 18, 2010, 12:08:33 PM

I'm sorry I don't know much about Access databases

ACTUALLY- it uses pretty much the same SQL your familiar with from MySQL.

in this case, it simply looks like there is no actual query being CREATED from the POST'ed data; that is, it is returning all records simply because it hasn't been told otherwise (think, performing a "query" that is just the table name- it returns the entire contents of the table).

Solve : Frontpage form query problem?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment