Limitations of PWS?

Results 1 to 2 of 2

Thread: Limitations of PWS?

  1. #1
    Ashley T. Howes Guest

    Default Limitations of PWS?

    I&#039m developing some ASP scripts which examine records in an Access database. Simple SQL queries to add a new record, delete a record or update an existing record run fine. But when I start sending more complex SQL queries, which ask the database to return 2 fields, with a WHERE clause and GROUP them, PWS hangs. As far as I can see there is no problem with the SQL queries (i&#039m still learning so there could be), so I was wondering if I was asking too much of PWS?<BR><BR>Typical SQL query causing problems:<BR><BR>SELECT categoryFull, accesslevel<BR>FROM productCatalog<BR>WHERE accesslevel = &#039 1&#039<BR>GROUP BY categoryFull<BR><BR>which as far as I understand should only return records from the database which match accesslevel equal to 1, then group by categoryFull (so if there are multiple categories with the same title, only one is shown in the returned recordset).<BR><BR><BR>Thanks for your help.<BR><BR><BR>Ashley

  2. #2
    Join Date
    Dec 1969

    Default RE: Limitations of PWS?

    You want to use an ORDER BY, not GROUP BY.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts