I wasn't sure whether to post in the Javascript forums or in here, but having googled around, I can't find any clear explanation on the problems with ADO and the usage of ORDER BY through Javascript. I'm trying to Order the results of an SQL query from an Access 97 Database and failing miserably. No errors are thrown, but the sort order doesn't change either.

Browser: MSIE6SP1
OS: Windows NT 4.0
MDAC: 2.5

Any help, or pointers to any useful info would be most appreciated!

Thanks
Joe

Brandoe85

Dec 19th, 2006, 08:49 PM

I've never used client side ado, but what's the query look like that you are trying to order? What order by clause did you try?

QAGrades is the table I'm querying. qTypeUser is a variable to store the query type (numeric or text). op is the operator they will be using (<, > or = for now). strVal is the string value. then we get to ORDER BY. oBySetUp sets up the order by string (generated from a select box). Then ascDesc is either ASC or DESC from the select box above. generated text-type query string would look like this: