-
Access Select problem
Here is a seemly simple problem that is stumping me:
I have a select statement that uses Access' DISTINCTROW clause for performance reasons.
The problem is that ASP-db does a SELECT COUNT(*) FROM X WHERE Y to determine
the rowcount to control the buttons. Unfortunately, the COUNT(*) is different then when
you do SELECT DISTINCTROW A,B,C FROM X WHERE Y. Is there anyway I can tell
ASP-db to use the recordset's RecordCount instead of the default COUNT(*)? Or can
you think of any otherway I can get ASP-db to work properly?
Yes, I can write the SQL statement another way to avoid the DISTINCTROW, but I
was getting unexceptable performance. I will have to switch to SQL Server if this
doesn't work.
Any help would be appeciated,
-Doug
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|