Sorry about that, but I couldn't understand really what I was suppose to do
with the type_scroll_inse...
I'll know for next time.
THANKS!!!
Troy
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
Muthukrishnan Giridhar
Sent: Wednesday, July 26, 2000 2:19 AM
To: [EMAIL PROTECTED]
Subject: Re: Scrollable Result Sets??
people who take pains to write "refer documentation" can write the solution
instead!!!!
anyway,the syntax is
stmt = Conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
Giri
"Moore, Jim" <[EMAIL PROTECTED]> on 07/26/2000 02:42:32 AM
Please respond to "A mailing list for discussion about Sun Microsystem's
Java
Servlet API Technology." <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc: (bcc: Muthukrishnan Giridhar/E-Commerce/DSQ
Software Limited/IN)
Subject: Re: Scrollable Result Sets??
here's a hint--you need to fix the second line of your code. now get the to
the documentation...
--jim
-----Original Message-----
From: Troy Rowe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 25, 2000 4:35 PM
To: [EMAIL PROTECTED]
Subject: Re: Scrollable Result Sets??
Thanks, only HOW would I specify the resultset type?
this is what I got:
Statement stmt=null;
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT batch_cd, called_address, charge_address FROM
raw_ss7");
where would TYPE_SCROLL_SENSITIVE go??
THANKS VERY MUCH
Troy
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
harjit singh
Sent: Tuesday, July 25, 2000 4:08 PM
To: [EMAIL PROTECTED]
Subject: Re: Scrollable Result Sets??
When you create the statement object you can specify the resultset type .
The type to specify for Scrollable is TYPE_SCROLL_SENSITIVE.
Hope that helps
- Harjit
-----Original Message-----
From: Troy Rowe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 25, 2000 1:39 PM
To: [EMAIL PROTECTED]
Subject: Scrollable Result Sets??
How do I make my result set scrollable?
I have the result set populating an html table, and I would like the table
to have a scroll on it, any ideas??
Thanks in advance.
Troy
___________________________________________________________________________
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
___________________________________________________________________________
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
___________________________________________________________________________
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
