Question
SQL Query Problem
I am trying to run a basic query on my Access database, using
ASP.Net code generated through Dreamweaver. The query works when
run directly against the database but hangs when I try and run it
through ASP.Net on my IIS server.
The query is as follows:
myQuery = "SELECT (RatingTotal / RatingNumber) AS Avrating, * FROM Campaign_Table WHERE RatingNumber > 12 AND Status = " + Chr(39) + "Open" + Chr(39) + " ORDER BY 1 DESC"
Strangely this works fine when the RatingNumber > 12 is changed to RatingNumber > 5 (this returns three results rather than two).
No error message is given the page simply hangs before it is loaded and CPU utilisation goes to 100% on the aspnet process.
Any ideas what is causing this?
The query is as follows:
myQuery = "SELECT (RatingTotal / RatingNumber) AS Avrating, * FROM Campaign_Table WHERE RatingNumber > 12 AND Status = " + Chr(39) + "Open" + Chr(39) + " ORDER BY 1 DESC"
Strangely this works fine when the RatingNumber > 12 is changed to RatingNumber > 5 (this returns three results rather than two).
No error message is given the page simply hangs before it is loaded and CPU utilisation goes to 100% on the aspnet process.
Any ideas what is causing this?
