odbc & multi-pages

[beichuang <be...@yahoo.com>]

Hello, all

First, thank you DO for your reply.

However, I am using odbc to access database, however, 
 I wonder whether odbc support multi-pages technology with ESQL?
sometimes, a Select request get a large amount records return, so how to
devide all the records into some pages and give user to navigate through
them is a common also impormation feture, so have you ever think of the
question?

I was replied that MySql has this function, but I am using ODBC and MS Access, so anyone know how to get the function?

BTW: my xsp here
<esql:results>
                <ID><esql:get-string column="id"/></ID>
                <FN><esql:get-string column="First_Name"/></FN>
</esql:results>

Get the output here:
<ID xmlns:request="http://www.apache.org/1999/XSP/Request">00001</ID>
<FN xmlns:request="http://www.apache.org/1999/XSP/Request">Bill</FN>

but I do not want the attribute 
xmlns:request=http://www.apache.org/1999/XSP/Request

how can I erase it?


Thank you all, any comments will be appreciated.

best regards