Hello All! I am trying to use the Select statement to retrieve results from MS Access (2000) Database. I tried to use the 'where' clause in my SQL and I get the error. 'too few parameter expected 1' I tried to use prepared statement, I get the error 'illegal argument exception' In order to send out 20 (at a time ) results to the client to the browser, I set resultset to be cursor_sensitive and I get the same error....So I send out the cursor position manually as a query String on the back and forward buttons and manually (using if statement ) retrieve the complete ResultSet from the database and then get from where I should send the next 20 results. However, what happens when two users attack my servlet at the same time? Threading problems ! All the above are separate cases ! Any help is greatly appreciated ! Does MS Access support any or all three above. Is there a better way of doing all this ? other : jdk1.2.1. jsdk2.1, iis 4.0, JRun 2.3.2 Thankx in advance. Gautam ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
