Posted by Karin Jensen on 08/26/05 12:40

Hi

I am running a PHP program that connects to an Access 2000 database
via ODBC:
$results = odbc_exec($connection_id, $sql_select);

Is it possible to sort the contents of $results? I wish to use a
regex-based sort order that you can't do in Access 2000* SQL with
"ORDER BY".

Thanks!

Karin

* There is the function rgxValidate by John Nurick, which uses
VBScript.Regexp to provide a regex fn for Access, but this is slow
in queries because it creates a RegExp object and compiles the
regular expression every time it is called.

[Back to original message]