Dear friends,
I am having one problem while using submitting form in servlet
,whenever the the fields of form contains apostrophy symbol that is "
' " my string immidiately terminates in Microsoft Access since it
takes ' as string terminator ,furthor since i am facing this problem
when client enter his details in the form hence i can also not insert
precautions for escape char sequences .Please mail me if you know the
answer as my each form submission terminates in servlet-ms access on
' character.
JAY SHRI KRISHANA.
>-------- ORIGINAL MESSAGE BELOW --------
>We too had the same problem.
>So we decided to use to separate statement object for different resultset.
>It works fine with out any problem.
>
>----- Original Message -----
>From: Mark Weidner <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Wednesday, December 27, 2000 3:22 AM
>Subject: Multiple/Nested Resultsets
>
>
>> Hi Everyone,
>>
>> I'm looking to use nested resultsets to retrieve data. Basically,
>I
>> need to retrieve data based on certain values retrieved by another
>> resultset. The following code is a much simplified version of what I'd
>like
>> to do. The real SQL statements are much more complex, and it would be a
>> huge performance hit to attempt to retrieve all the data in one ResultSet.
>> It is my understanding that executing a query on an existing statement
>> deletes the references to any previous resultset. Therefore, copying the
>> data from a first resultset to an object would work (Vector/Hashtable?),
>but
>> there would be serious performance implications there as well. Any ideas?
>> (I apologize....I come from the ASP world)
>>
>> Thanks.
>>
>> -Mark
>>
>> ---------------
>>
>> file://Connection con has already been created
>>
>> Statement stmt = con.createStatement();
>> ResultSet rsQuestions = stmt.executeQuery("SELECT questionID FROM
>> Questions");
>>
>> file://Loop through questions from first resultset
>> while (rsQuestions.next()) {
>>
>> int ID = rsQuestions.getInt("questionID");
>>
>> file://Lookup results from second resultset which uses paramaters
>from
>> the first resultset
>> ResultSet rsText = stmt.executeQuery("SELECT questionText FROM
>Text
>> WHERE questionID=" + ID);
>> String sText = rsText.getString("questionText");
>> out.println("Question ID: " + ID + " Question Text: " + sText)
>> }
>>
>>
>___________________________________________________________________________
>> 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
>>
>
>___________________________________________________________________________
>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
-->> FREE Perl CGI scripts add WEB ACCESS to your
-->> POP E-Mail accounts! Download today!! http://www.adjeweb.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
