SQL Query Problem

Check your MDAC version. If it's less than 2.81, then you need to go
update.


"Yooma" <webforumsuser@macromedia.com> wrote in message
news:em6pss$855$1@forums.macromedia.com...
>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?
>