database Search with the servlets.
Can you please sort my issue.

1. what method is there to count the no. of records in a resultset(
direct method with out looping).
2. what is the syntax of 'like' in the below line.

   String str1="select * from TableInd where Detail like '"+%kw[0]%+"'";

context: I have a search box in a form and visitor can enter keywords in
the search box(text box). the key word information is tokenized and put
in an array kw[numtokens] (num Tokens is Number of tokens entered in hte
search box)
I want to check the 'Detail' field with the workds matching 'kw[0]';
the above is giving error.

bye
Kaushik

___________________________________________________________________________
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

Reply via email to