odbc & multi-pages?

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

Hello,

First, thank you for your reply and sorry for sending mail cross-group.


However, I am using odbc to access database, 
I wonder whether odbc support multi-pages technology with ESQL?
I used 
<get-row-number>5<get-row-number>
wish the content document code comes from the 5th, but  no effect, I
am not sure whether it is due to JDBC/ODBC bridge class's fault.

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