I can't use dbman sort options(so, sb) in dbman sql.
Whe I use '&sb=29&so=ascend', I met the following error message.

"Unable to query database. Reason: You have an error in your SQL syntax near 'ascend
LIMIT 0, 20
' at line 5. Query:
......."
Anybody know sorting method in SQL?

Look in the LINKS SQL Forum for ideas about sorting codes in SQL.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. :)
----------------------