Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

SQL Query Problem

New Here ,
Dec 18, 2006 Dec 18, 2006
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?
TOPICS
Server side applications
197
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Dec 18, 2006 Dec 18, 2006
LATEST
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?
>


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines