Mike Henshaw <mhens...@adcomtechnologies.com> wrote: > 1. The application is from a third party with no access to the source code > but the SQL query can be updated since the SQL query > is used in a custom HTML template which can also be updated. > 2. The calculations to the RowNum would then have to be in the C/CPP > application which would nullify the use of customizable HTML > template.
What kind of template language is being used? Many of them have a built-in way to number rows, or implement alternate coloring (the motivation for your second example, I suspect). There is no built-in mechanism in SQLite for this kind of row numbering. Implementing it in SQL query is very inefficient, and is outright impossible if the resultset needs to contain duplicate rows. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users