Hello,
I am working on an inquiry form and I am kind of stuck in thinking of
an optimum way to write the sql to do the inquiry. The form consists
of 8 fields and the user needs to fill out atleast one field. A
servlet will take the values entered(atleast one) by the user and
search a table based on the values entered by the user.
Now, there can be so many combinations since the user may enter one
field or two ..etc.Any suggestions on how I could write the sql?
Also, the sql may return a thousand records..how do I display about 50
records per page. If the user clicks on a next button, the next 50
records are displayed. Any idea on how I could split the retrieved
records into pages.Thanks,JGM
_____________________________________________________________
Do You Yahoo!?
Free instant messaging and more at http://messenger.yahoo.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
