What I have been doing in my custom tags could also apply to any query
output situation. The following is in lieu of declaring your query
TYPE_SCROLL_INSENSITIVE and then calling myquery.first() to reset the
cursor back to the first row.
//Create an ArrayList Of HashMaps
ArrayList rows = new ArrayList();
HashMap columns = null
//as you output the query the first time also add it to the above
structures.
while(myquery.next()){
columns = new HashMap();
colums.put("column_name1",myquery.getObject(1));
colums.put("column_name2",myquery.getObject(2));
//........... and so on.
// add the columns to a row
rows.add(columns)
}
// then loop through your structure like so.
rowIter = rows.iterator();
while(rowIter.hasNext()){
columns = rowIter.next();
thismap.get("column_name1");
thismap.get("column_name2");
}
//.......... and so on.
----- Original Message -----
From: "Balamurugan . R" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 9:40 PM
Subject: Re: preparedStatement
> Use seprate statement for each resultset
>
> "Shahata, Ash" wrote:
>
> > I tried this already, but unfortuanltly I get the same result... the
problem
> > seems that rs2 can not be looped through more than once! Is this how
result
> > sets react in general, would I be able to loop through a resultset more
than
> > once?
> >
> > -----Original Message-----
> > From: Mathias H�ggren [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, February 26, 2003 11:13 AM
> > To: [EMAIL PROTECTED]
> > Subject: SV: preparedStatement
> >
> > Hi!
> >
> > I strongly suspect your problem is right here:
> > if(val1 == val2){
> >
> > Try this instead:
> > if (val1.equals(val2)) {
> >
> > Brgds
> > Mathias
> >
> > -----Ursprungligt meddelande-----
> > Fr�n: A mailing list about Java Server Pages specification and reference
> > [mailto:[EMAIL PROTECTED] Shahata, Ash
> > Skickat: den 26 februari 2003 12:09
> > Till: [EMAIL PROTECTED]
> > �mne: Re: preparedStatement
> >
> > I think I figured it out where the problem is, it'a not from the code
that I
> > sent it's to do with the rs.next! However I still couldnt fix it. The
value
> > of tname is passed correctly and when I retireve it on its own, it works
> > fine. Here's the part of the code that is causing the problem:
> >
> > while (rs.next()){
> > out.println("Inside rs");
> > while(rs2.next()){
> > out.println("Inside rs2");
> > String val1 = rs.getString(2);
> > String val2 = rs2.getString(2);
> > if(val1 == val2){
> > out.println("Inside IF");
> > String id2 = rs2.getString(1);
> > out.println("Sybase Customer Name = " +
> > rs2.getString("swName"));
> > out.println(" | id = " + id2 + "<br>");
> > }//if
> > }//while(rs2.next())
> > }//while(rs.next())
> >
> > I'm looping through both result sets, expecting to see rs2 looping
several
> > times for every value of rs1, but here's what I grt from my println:
> >
> > These Records appear on both systems
> > Inside rs Inside rs2 Inside rs2 Inside rs2 Inside rs2 Inside rs2 Inside
rs2
> > Inside rs2 Inside rs Inside rs Inside rs
> >
> > Any idea why the loop is not functioning as expected?
> > Thanks
> >
> > -----Original Message-----
> > From: Pillai Jaideep, App Spec, SCS-SD [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, February 26, 2003 10:18 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: preparedStatement
> >
> > R U sure tname variable holds exactly the value U want ?
> >
> > -----Original Message-----
> > From: Shahata, Ash [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, February 26, 2003 5:50 PM
> > To: [EMAIL PROTECTED]
> > Subject: preparedStatement
> >
> > Hi there,
> > I'm getting stuck with the following procedure using prepared
statements..
> > it works just fine if I use a normal statement. I need to pass a
prepared
> > statement because I need to pass a valriable to the query. It does not
> > return any records!
> >
> > Statement stmt = con1.createStatement();
> > String query = "Select * from SW_Customer where swName = ?";
> > PreparedStatement ps = con1.prepareStatement(query);
> > ps.setString(1,tname);
> > ResultSet rs = ps.executeQuery();
> > while (rs.next()){
> > String name = rs.getString(1);
> > out.println("Value of field = " + rs.getString("swName"));
> > out.println("Value of field = " + name);
> > }
> >
> > Any help will be appreciated
> >
> > Thanks
> >
> >
===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> > JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> > DIGEST".
> >
> > Some relevant archives, FAQs and Forums on JSPs can be found at:
> >
> > http://java.sun.com/products/jsp
> > http://archives.java.sun.com/jsp-interest.html
> > http://forums.java.sun.com
> > http://www.jspinsider.com
> >
> >
===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> > JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> > DIGEST".
> >
> > Some relevant archives, FAQs and Forums on JSPs can be found at:
> >
> > http://java.sun.com/products/jsp
> > http://archives.java.sun.com/jsp-interest.html
> > http://forums.java.sun.com
> > http://www.jspinsider.com
> >
> >
===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> > JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> > DIGEST".
> >
> > Some relevant archives, FAQs and Forums on JSPs can be found at:
> >
> > http://java.sun.com/products/jsp
> > http://archives.java.sun.com/jsp-interest.html
> > http://forums.java.sun.com
> > http://www.jspinsider.com
> >
> >
===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> > JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> > DIGEST".
> >
> > Some relevant archives, FAQs and Forums on JSPs can be found at:
> >
> > http://java.sun.com/products/jsp
> > http://archives.java.sun.com/jsp-interest.html
> > http://forums.java.sun.com
> > http://www.jspinsider.com
> >
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
> >
> > Some relevant archives, FAQs and Forums on JSPs can be found at:
> >
> > http://java.sun.com/products/jsp
> > http://archives.java.sun.com/jsp-interest.html
> > http://forums.java.sun.com
> > http://www.jspinsider.com
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
>
> Some relevant archives, FAQs and Forums on JSPs can be found at:
>
> http://java.sun.com/products/jsp
> http://archives.java.sun.com/jsp-interest.html
> http://forums.java.sun.com
> http://www.jspinsider.com
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com
