|
 |
access_asp thread: Filter Ordering Possible
Message #1 by jmendez@k... on Tue, 23 Apr 2002 05:39:16
|
|
Thank you Ethan for your help. It worked perfectly...
Now can I also sort by a field using the same Filter, such as:
strCriteria = "prem-type LIKE '%" & strRecord & "%'"
strCriteria = strCriteria & " Order by fld1"
objRS.Filter = strCriteria
Is this possible, or is there another way to go about this. I receive
error messages when I have tried.
Thanks again for those who have given me useful tips and knowledge.
Jeff
Message #2 by "Ethan Selzer" <ethanselzer@a...> on Mon, 22 Apr 2002 21:52:58 -0700
|
|
No I don't think so. Do your sorting in the SQL statement that produces your
record-set.
Ethan
-----Original Message-----
From: jmendez@k... [mailto:jmendez@k...]
Sent: Tuesday, April 23, 2002 5:39 AM
To: Access ASP
Subject: [access_asp] Filter Ordering Possible
Thank you Ethan for your help. It worked perfectly...
Now can I also sort by a field using the same Filter, such as:
strCriteria = "prem-type LIKE '%" & strRecord & "%'"
strCriteria = strCriteria & " Order by fld1"
objRS.Filter = strCriteria
Is this possible, or is there another way to go about this. I receive
error messages when I have tried.
Thanks again for those who have given me useful tips and knowledge.
Jeff
|
|
|
View Cart
