Re: Moving through the resultset

[Dan Lopez]

I think the best solution for this is James' pager
taglib from http://www.jsptags.com

Try it out, there is an example on his page.


That way it is more dynamic, and you dont have to
specify # to select in SQL stmt.

Hope that helps






--- EJB ForAll <[EMAIL PROTECTED]> wrote:
> hi dear,
>
>
> if You are using MySQL database then use the
> following
> query.
>
> select * from abc limit 0,20
>
> this will retrive only first 20 records.
>
> and in next page you can use the following query
>
> select * from abc limit 20,21
>
> Regards
> Deepak Kumar
> http://www.geocities.com/deepak_38
>
>
>
>
>
>
> --- ems vasudevan <[EMAIL PROTECTED]> wrote:
> > Hi All !
> >I want to select only a particula no of records
> > from the database to display like goolge is
> doing.I
> > don't want to select the entire set of resultset
> and
> > process in the clientside or storing in the
> > vector.If
> > a table contains large no of records, I want to
> > display it chunk by chunk.For that whenever i am
> > contacting the database i want to select a set of
> > records.Any ideas?
> >
> > __
> > Do You Yahoo!?
> > Spot the hottest trends in music, movies, and
> more.
> > http://buzz.yahoo.com/
> >
> >
>
===
> > To unsubscribe: mailto [EMAIL PROTECTED] with
> > body: "signoff JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with
> body:
> > "set JSP-INTEREST DIGEST".
> > Some relevant FAQs on JSP/Servlets can be found
> at:
> >
> >  http://java.sun.com/products/jsp/faq.html
> >  http://www.esperanto.org.nz/jsp/jspfaq.html
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
> __
> Do You Yahoo!?
> Spot the hottest trends in music, movies, and more.
> http://buzz.yahoo.com/
>
>
===
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body:
> "set JSP-INTEREST DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets


__
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: Combo Box problem

[Dan Lopez]

Thanks for the help,

unfortunately, my system that I am working on does not
like beans and the system fails when I use them.  Any
strait java code would be helpful so that I may parse
them right into  tags.  Thanks







--- "Middleton, Jorge Luis" <[EMAIL PROTECTED]>
wrote:
> I use my combo own classes that populate combos and
> set various properties.
>
> With this properties setOnchange("buscarEstado()");
> I'm setup which method
> execute this combo when the onchange event occur.
> This method (buscarEstado() = findStates()) submit
> the page and reload all
> combos.
>
> I wish that you can use this and understand me.
> Jorge Middleton
> MENDOZA - ARGENTINA
>
> /jsp example
> */
>
> <%@page language="java" import="java.util.*,
> java.sql.*,
> com.alterbrain.ar.*" errorPage="../errorPage.jsp"%>
>  class="com.alterbrain.ar.Usuarios"/>
>  class="com.alterbrain.ar.Domicilios"/>
>  class="com.alterbrain.ar.ComboBean"/>
>  class="com.alterbrain.ar.MensajesColeccion"/>
>
> <%
> javax.servlet.http.HttpSession sesion=
> request.getSession(false);
> usuario.setSesion(sesion);
>
> //PARA LA CARGA DE LOS COMBOS
> Vector v= new Vector();
> o.setSesion(sesion);
>
> Integer iIdioma=
>
Integer.decode((String)sesion.getValue("config.idioma"));
> Mensaje mensaje= new Mensaje();
>
> //llena los valores de los text con null por eso se
> verifica antes
> String entrada=
>
Conversor.HTMLEncode(request.getParameter("entrada"),
> "1");
> String oper=
>
Conversor.HTMLEncode(request.getParameter("operacion"),
> "nulo");
> String rAceptaTerminos=
> request.getParameter("aceptaTerminos")== null ||
>
!request.getParameter("aceptaTerminos").equals("1")?"":"checked";
>
usuario.setRecibeInfo(Conversor.HTMLEncode(request.getParameter("recibeInfo"
> ), "N"));
>
> //datos del movimiento cuando se ingresa a esta
> pagina por un link de una
> solicitud
> //o envio de dinero
> String rUid=
> Conversor.HTMLEncode(request.getParameter("uid"),
> "0");
> String rMoviTipo=
>
Conversor.HTMLEncode(request.getParameter("moviTipo"),
> "0");
> String rMoviNume=
>
Conversor.HTMLEncode(request.getParameter("moviNume"),
> "0");
> int uid= Integer.parseInt(rUid);
> int moviTipo= Integer.parseInt(rMoviTipo);
> int moviNume= Integer.parseInt(rMoviNume);
> %>
>
> 
> 
>  src="../js/rlov_prlo.js">
>  src="../js/Mascara.js">
>
> 
> 
> var glMarca= true; //variable global para evitar que
> se ejecute dos veces la
> //funcion validarNroInt.
>
> function validarNroInt(obj, mascara) {
> var correcto= ValidoNumeInt(obj.value, mascara);
> glMarca= true;
> if (!correcto){
> <%mensaje= mensajeCol.getMensaje(iIdioma,
> new Integer(20118));%>
> alert("<%=mensaje.getMensaje()%>\n");
> obj.value="";
> obj.focus();
> glMarca = false;
> }
> }
>
> function Ventana(path){
> window.open(path,"Ventana",
>
>
"height=450,width=450,left=300,top=50,scrollbars=yes,toolbar=no,status=no,me
> nubar=no,location=no,resizable=no")
> }
>
> function Confirmar(){
> if (glMarca && verificarDatos() &&
> verificarPassword()){
> if
> (document.forms[0].aceptaTerminos.checked== true){
>
> document.forms[0].operacion.value="C_REGIS";
> //confirmar
> document.forms[0].domiTipo.value=
> "1";
> document.forms[0].submit();
> }else{
> //no aceptó las condiciones de
> TePago.com
> <%mensaje=
> mensajeCol.getMensaje(iIdioma, new
> Integer(20103));%>
>
> alert("<%=mensaje.getMensaje()%>\n");
> }
> }
> return;
> }
>
> function buscarEstado(){
> document.forms[0].operacion.value="X";
> document.forms[0].estado.selectedIndex= -1;
> document.forms[0].action="Registracion.jsp";
> document.forms[0].submit();
> }
>
> function buscarLocalidad(){
> document.forms[0].operacion.value="X";
> document.forms[0].localidad.selectedIndex=
> -1;
> document.forms[0].action="Registracion.jsp";
> document.forms[0].submit();
> }
>
> function verificarPassword(){
> var mensaje = "";
>
> if (mensaje == "") return true;
>
> window.alert(mensaje);
> return false;
> }
>
> 
>
>  href="../estilos/general.css">
>
>  marginwidth="0"
> marginheight="0">
> 
> 
>  value="<%=entrada%>">
> 
>
>width="100%">
>   
>  class="TituloCelda"> Id=pais>País:
> 
>
> <%v.removeAllElements();
>
> o.abrirConexion();
>
>
o.setStore("PA_TEP_COMBOS_REG.PR_TEP_PAISES_CONSUL");
>
> v.addElement(o.NULO_INTEGER);
>
> v.addElement(iIdioma);
>
> o.setParam(v);
>
> o.setName("pais");
>
> o.setColumnaCodigo(1);
>
> o.setColumnaDescrip(2);
>
> o.setInicial("Seleccione un Pais");
>
> o.setClase("Combo");
>
> o.setWidth("133");
>
> o.setOnchange("buscarEstado()");
>
=== message truncated ===


__

Combo Box problem

[Dan Lopez]

I have two combo boxes that I would like to populate
from my database (for states and countries).  What
method(s) do I use to do this using JDBC and combo
boxes?

Need help ASAP!

Thanks All.

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Getting error in compilation of page

[Dan Lopez]

SortEmployee.java:129: Return required at end of
Edinc.empcompsys.EmployeePayInfo readEmployeeFile().
   private EmployeePayInfo readEmployeeFile()


--

Any suggestions?


Thanks



__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: Chat

[Dan Lopez]

Try www.hotscripts.com

No app servers, but some JSP-based chat programs with
source code etc...

Hope that helps


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: Rowcolor...

[Dan Lopez]

I pulled the int count = 0; out of the loop and it
worked great!

Thanks for the help

-Dan

--- creeves <[EMAIL PROTECTED]> wrote:
> what is the resulting html?
>
> -Original Message-----
> From: Dan Lopez [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 14, 2001 10:57 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Rowcolor...
>
>
> I followed the mod2 framework as provided in the
> example.  It still doesnt change color :(.  Provided
> is a sample of the code I have been trying
> out...Please
> point me in the right direction, I am stuck.  Thanks
> a
> bunch!
>
>
CODE==
>
> <% {Resultset Gotten here and formatted with
> taglibs}%>
>
> <%
> int count = 0;
> String bgcolor;
> if (count%2 == 0) {
> bgcolor="lightgrey";
> } else {
> bgcolor="lightblue";
> }
> count++;
> %>
>
> 
>  
><%= a %>
>  
><%= b %>
> 
>   .
>   .
>   etc...
>   
>
>
=
>
>
> --- "Straight, Christian" <[EMAIL PROTECTED]> wrote:
> > This works fine but shouldn't that be mod2 as
> > follows:
> >
> > int count = 0
> > String bgcolor;
> >
> > if (count%2 == 0)
> >bgcolor="some color";
> > else
> >bgcolor="some other color";
> >
> > count++;
> >
> >
> > Christian Straight
> > Inovant
> >
> >
>
>
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail -
> only $35
> a year!  http://personal.mail.yahoo.com/
>
>
===
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff
> JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body:
> "set JSP-INTEREST
> DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
===
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body:
> "set JSP-INTEREST DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: Rowcolor...

[Dan Lopez]

I followed the mod2 framework as provided in the
example.  It still doesnt change color :(.  Provided
is a sample of the code I have been trying
out...Please
point me in the right direction, I am stuck.  Thanks a
bunch!

CODE==

<% {Resultset Gotten here and formatted with
taglibs}%>

<%
int count = 0;
String bgcolor;
if (count%2 == 0) {
bgcolor="lightgrey";
} else {
bgcolor="lightblue";
}
count++;
%>


 
   <%= a %>
 
   <%= b %>

  .
  .
  etc...
  

=


--- "Straight, Christian" <[EMAIL PROTECTED]> wrote:
> This works fine but shouldn't that be mod2 as
> follows:
>
> int count = 0
> String bgcolor;
>
> if (count%2 == 0)
>bgcolor="some color";
> else
>bgcolor="some other color";
>
> count++;
>
>
> Christian Straight
> Inovant
>
>


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: Row Color

[Dan Lopez]

I followed the mod2 framework as provided in the
example.  It still doesnt change color.  Provided is a
sample of the code I have been trying out...Please
point me in the right direction, I am stuck.  Thanks a
bunch!

CODE==

<% {Resultset Gotten here and formatted with
taglibs}%>

<%
int count = 0;
String bgcolor;
if (count%1 == 0) {
bgcolor="lightgrey";
} else {
bgcolor="lightorange";
}
count++;
%>


 
   <%= a %>
 
   <%= b %>

  .
  .
  etc...
  

=


--- "Straight, Christian" <[EMAIL PROTECTED]> wrote:
> This works fine but shouldn't that be mod2 as
> follows:
>
> int count = 0
> String bgcolor;
>
> if (count%2 == 0)
>bgcolor="some color";
> else
>bgcolor="some other color";
>
> count++;
>
>
> Christian Straight
> Inovant
>
>


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

mySQL driver install?

[Dan Lopez]

How do i go about installing mySQL driver for jdbc on
Windows 2000?  I have my db and JSP pages done, just
need connectivity.  I would appreciated the help.

Thanks

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: Session Object Persistence

[Dan Lopez]

James,

I dont get a null exception any more, however, I am
getting a strange result.  I get the first ten.  Then
when I go to the 1/2/3/4 etc it is blank, except for
the links.  There is no data, not even rows with null
values.  Any ideas would help eliminate my headache ;)

-Dan

Sample Code===

<%@ taglib uri="http://someurl" prefix="pg" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page session= "true" %>




A.nodec { text-decoration: none; }




<% //Get the fields passed from Search request page
from form submission
  String field = request.getParameter("fieldname");
  String field2 = request.getParameter("fieldname2");
  String equal = request.getParameter("equals");
  String sqlstmts = request.getParameter("sqlstmt");
%>


<%

  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection myConn =
DriverManager.getConnection("jdbc:odbc:cpedb");
Statement stmt = myConn.createStatement();
ResultSet myResultSet = stmt.executeQuery("SELECT
"+field+" FROM tbl_cpetest"+
" WHERE " +field2+ "='" 
+sqlstmts+ "'");

%>

<%
String requestUri = request.getRequestURI();
int indexOfqm = requestUri.indexOf('?');
if (indexOfqm != -1)
requestUri = requestUri.substring(0, indexOfqm);

String style = request.getParameter("style");
%>



 <% /* keep track of style and
variables */ %>
 <% /* keep track of variables
*/ %>
 <% /* keep track of
variables */ %>
 <% /* keep track of
variables */ %>




  
Search
Results 

  <%
if (myResultSet != null) {
while (myResultSet.next()) {
String a = myResultSet.getString(1);
  %>
  

  

<%= a %>
 
  
  
  <%
}
 }

   stmt.close();
   myConn.close();
%>



 
  
  

[ (<%= pageNumber %>) <<
Previous ]


   <%= pageNumber %>


  [ Next >> (<%=
pageNumber %>) ]

  






__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: Session Object Persistence

[Dan Lopez]

James,

Here is my current (sample) code I am working with.  I
Now do not get a null pointer exception.  But now the
first page with the first 10 rows from query come up.
Then when I go to next pages, the counter is there but
no data. Not even rows with null values.

Any ideas would be helpful.

This little thing is causing such a headache!

Thanks for all the help.

SAMPLE
CODE

<%@ taglib uri="http://someurl.net" prefix="pg" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page session= "true" %>




A.nodec { text-decoration: none; }
<!--
 A:link {text-decoration: none;}
 A:visited {text-decoration: none;}
 A:hover {text-decoration: underline;}
-->





<% //Get the fields passed from Search request page
from form submission
  String field = request.getParameter("fieldname");
  String field2 = request.getParameter("fieldname2");
  String equal = request.getParameter("equals");
  String sqlstmts = request.getParameter("sqlstmt");
%>


<%

  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection myConn =
DriverManager.getConnection("jdbc:odbc:cpedb");
Statement stmt = myConn.createStatement();
ResultSet myResultSet = stmt.executeQuery("SELECT
"+field+" FROM tbl_cpetest"+
" WHERE " +field2+ "='" 
+sqlstmts+ "'");

%>

<%
String requestUri = request.getRequestURI();
int indexOfqm = requestUri.indexOf('?');
if (indexOfqm != -1)
requestUri = requestUri.substring(0, indexOfqm);

String style = request.getParameter("style");
%>



 <% /* keep track of style and
variables */ %>
 <% /* keep track of variables
*/ %>
 <% /* keep track of
variables */ %>
 <% /* keep track of
variables */ %>




  
Search
Results 

  <%
if (myResultSet != null) {
while (myResultSet.next()) {
String a = myResultSet.getString(1);
  %>
  

  

<%= a %>
 
  
  
  <%
}
 }

   stmt.close();
   myConn.close();
%>



 
  
  

[ (<%= pageNumber %>) <<
Previous ]


   <%= pageNumber %>


  [ Next >> (<%=
pageNumber %>) ]

  





--- James Klicman <> wrote:
> Hi Dan,
>
> First you should make sure field != null before
> trying to put it
> in the session. That is what is causing the
> NullPointerException.
>
> Then add a  tag inside
> the 
> tag. This will add "fieldname" to the list of
> parameters that will
> be preserved and passed to future pages.
>
> -James
>
> On Mon, Feb 12, 2001 at 09:02:00AM -0800, Dan Lopez
> wrote:
> > I am using pager taglib from www.jsptags.com.  I
> get
> > data from a database fine when I get ALL the data.
> >
> > However when a user enters info from a form to be
> used
> > in SQL clause, the data comes up on the first page
> (of
> > 1/2/3/4/5... etc) but when you go to the next
> page,
> > the values are null.  Included is some sample code
> and
> > the error 500 that I get.  Please Help
> >
> > Thanks
> >
> > Dan
> >
> >
> > Sample Code
> >
> > <%@ taglib uri="http://someurl.net" prefix="pg" %>
> > <%@ page language="java" import="java.sql.*" %>
> > <%@ page session= "true" %>
> >
> >
> > 
> > <%! String field=""; %>
> >
> > <% //Get the fields passed from Search request
> page
> > from form submission
> >   field = request.getParameter("fieldname");
> >   session.putValue("fieldname", field);
> >
> > %>
> >
> > <% //Get the fields passed from session values
> > String field = (String)
> session.getValue("fieldname");
> > %>
> >
> > <%
> >
> >   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> >   Connection myConn =
> > DriverManager.getConnection("jdbc:odbc:test_db");
> > Statement stmt = myConn.createStatement();
> > ResultSet myResultSet =
> stmt.executeQuery("SELECT "
> > +field+ " FROM tbl_test");
> >
> > %>
> >
> > <%
> > String requestUri =
> request.getRequestURI();
> > int indexOfqm = requestUri.indexOf('?');
> > if (in

Session Object Persistence

[Dan Lopez]

I am using pager taglib from www.jsptags.com.  I get
data from a database fine when I get ALL the data.

However when a user enters info from a form to be used
in SQL clause, the data comes up on the first page (of
1/2/3/4/5... etc) but when you go to the next page,
the values are null.  Included is some sample code and
the error 500 that I get.  Please Help

Thanks

Dan


Sample Code

<%@ taglib uri="http://someurl.net" prefix="pg" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page session= "true" %>



<%! String field=""; %>

<% //Get the fields passed from Search request page
from form submission
  field = request.getParameter("fieldname");
  session.putValue("fieldname", field);

%>

<% //Get the fields passed from session values
String field = (String) session.getValue("fieldname");
%>

<%

  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection myConn =
DriverManager.getConnection("jdbc:odbc:test_db");
Statement stmt = myConn.createStatement();
ResultSet myResultSet = stmt.executeQuery("SELECT "
+field+ " FROM tbl_test");

%>

<%
String requestUri = request.getRequestURI();
int indexOfqm = requestUri.indexOf('?');
if (indexOfqm != -1)
requestUri = requestUri.substring(0, indexOfqm);

String style = request.getParameter("style");
%>


   <% /* keep track of style
*/ %>



  
Search
Results 

  <%
if (myResultSet != null) {
while (myResultSet.next()) {
String a = myResultSet.getString(1);
  %>
  

  

<%= a %>
 
  
  
  <%
}
 }

   stmt.close();
   myConn.close();
%>



 
  
  

[ (<%= pageNumber %>) <<
Previous ]


   <%= pageNumber %>


  [ Next >> (<%=
pageNumber %>) ]

  



ERROR===
null
java.lang.NullPointerException
at java.util.Hashtable.put(Unknown Source)
at
allaire.jrun.session.JRunSession.setAttribute(JRunSession.java:240)
at
allaire.jrun.session.JRunSession.putValue(JRunSession.java:226)
at
jrun__test__po_srch_result2ejsp18._jspService(jrun__test__po_srch_result2ejsp18.java:46)
at
allaire.jrun.jsp.HttpJSPServlet.service(HttpJSPServlet.java:40)
at
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1013)
at
allaire.jrun.servlet.JRunSE.runServlet(JRunSE.java:925)
at
allaire.jrun.servlet.JRunNamedDispatcher.forward(JRunNamedDispatcher.java:34)
at
allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:175)
at
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1013)
at
allaire.jrun.servlet.JRunSE.runServlet(JRunSE.java:925)
at
allaire.jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:88)
at
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1131)
at
allaire.jrun.servlet.JvmContext.dispatch(JvmContext.java:330)
at
allaire.jrun.http.WebEndpoint.run(WebEndpoint.java:107)
at allaire.jrun.ThreadPool.run(ThreadPool.java:272)
at
allaire.jrun.WorkerThread.run(WorkerThread.java:75)




__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Row Color

[Dan Lopez]

I want to alternate row color.  I have seen it...how
is it done?  Need help asap!

Thanks

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Dynamic Drop Down

[Dan Lopez]

I have three drop down menus:

1. Field Name of column from differect db tables
2. All fields in column (I would like to populate this
drop down from the field name from db, depending on
field name, do a distinct and populate the drop down)

more questions:
how do you hide a form, until something is clicked?

How do I make a text box case "insensitive" when
submitting form to query?

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Off Topic - EJB Question

[Dan Lopez]

Where is a good site with EJB tutorials?

THanks

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Get/Post question

[Dan Lopez]

For security reasons, I was trying to use "post" and
passing the values on to another page.  On the new
page it uses these values to submit a query.  That
works fine for the first display of the query.
However, when I hit [Next >>>] I get a SQL error
stating that the value "x" "y" and "z" (which are the
values I passed to this variable...) are NULL.  Would
using "get" eliviate this problem?

Thanks for the help.

__
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Forms Problem

[Dan Lopez]

I have several forms on one JSP page.

One of the forms has 3 fields (Month Day Year) that
are drop down menus.  The variables are passed to
another page via post and getResult(), etc.  The
variables are then used in my SQL query to define a
date parameter for the query.

The initial data shows up fine.

Here is where it gets wierd.  I am using a taglib (see
www.jsptags.com - pagerlist) to parse the data to
separate pages, ie 1 2 3 4 5, etc.  The links to the
pages come up after the query is made.  However, when
I click on page 2 to go to the next set of results, I
get a SQL error: Cannot convert VARCHAR (null null
null) to SimpleDateTime.  I would assume that this is
from the design of my post and get methodology.  The
variable is passed to the first initial page but not
to any of the other pages.  How do I get around this??

Thanks for the help all.

__
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

JSP/Array/JDBC

[Dan Lopez]

Need Help!

I had been retrieving data from Sybase databse.  This
was working fine.  I was querying views created from
external db outside my sybase environment.  I
displayed the data on JSP page.  The only problem is
that I cannot sort, since the views that were created
(which I cannot change, since this is out of my
control...change management, blah!) do not allow SQL
functions other than "select * from my_view".  I would
like to know if it is possible to put the data into
variables and place them into an array.  Then sort
using the array.  I have never really used arrays
before.

So, in short:
1.  Can this be done?
2.  HOW is it done?


Thanks All

Dan

__
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: Anybody thinking of using JRun just don't.

[Dan Lopez]

I use it in production of high traffic site and is
working great...



--- "M. Simms" <[EMAIL PROTECTED]> wrote:
> Hard to believe Jrun is that bad.
> Allaire just won a ton of awards from some leading
> journals.
>
> > -Original Message-
> > From: A mailing list about Java Server Pages
> specification and reference
> > [mailto:[EMAIL PROTECTED]]On Behalf Of
> Chin Sung Kit
> > Sent: Monday, October 30, 2000 9:54 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Anybody thinking of using JRun just
> don't.
> >
> >
> > hi,
> >
> > i plan to buy JRun pro, reading from what u
> commented, is Jrun
> > really that bad?
> > appreciate if you can give me some inside-out of
> jrun.  what
> > about servletexec?
> >
> > thanks.
> >
> > ced
> >
> > Nicholson Robert wrote:
> >
> > > Configuring this thing is a real pain. Half the
> time any change in JMC
> > > stops it subsequently starting up again and I
> already know that it
> > > consistently will remove any welcome-file-lists
> that you define in
> > > web.xml. In short configuring this thing is a
> complete joke.
> > >
> > > I would mind if everything was consistent but
> half the time it does
> > > different things and it's just too darn unstable
> to work with.
> > Deployment
> > > is a pain also.
> > >
> > > Anybody here pro JRun? I'm not after using it.
> > >
> > >
> >
>
==
> > =
> > > To unsubscribe: mailto [EMAIL PROTECTED]
> with body:
> > "signoff JSP-INTEREST".
> > > Some relevant FAQs on JSP/Servlets can be found
> at:
> > >
> > >  http://java.sun.com/products/jsp/faq.html
> > >  http://www.esperanto.org.nz/jsp/jspfaq.html
> > >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > >
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
> > --
> >
> > "Never let yesterday's disappointments overshadow
> tomorrow's dreams"
> >
> >
>
==
> > =
> > To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff
> > JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found
> at:
> >
> >  http://java.sun.com/products/jsp/faq.html
> >  http://www.esperanto.org.nz/jsp/jspfaq.html
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
>
>
===
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets


__
Do You Yahoo!?
>From homework help to love advice, Yahoo! Experts has your answer.
http://experts.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

If stmt syntax problem

[Dan Lopez]

How do you do multiple conditions in an if statement?

EX:

<% if (condition1 > condition2 "and" condition2 =
condtion3 "and" condition3 < condition4 "and"
condtion5 <> condition6) %>

<% else. %>

What is the syntax for "and"

Thanks

-D

__
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: ResultSet Type

[Dan Lopez]

The list is acting funny today...rejects everytime I
send.

I am conerned with getting the Day of the Month.  Most
important question labeled with **.

Right now I can format the date by doing something
like:

===
Query:
===
...
Date x = myResultSet.getDate(3)
...

===
Code:
===
Date d = new Date();
SimpleDateFormat datef, timef;
   datef = new SimpleDateFormat("MMM dd ");
   timef = new SimpleDateFormat("HH:mm")

int days;
int months;
int years;

days = d.getDay();
months = d.getMonth();
years = d.getYear();

===
Display method:
===
<%= datef.format(x) %> to display formatted date
<%= days %>
<%= Months %>
<%= Years %>

===
Questions:
===
1. myResultSet.getDate() yields date only and
myResultSet.getTime() yields time only.  How do I
display both since my field contains both? (When I do
Object o = myResultSet.getObject() it shows date and
shows place holder for time but time is 00:00:00.)

**2.How do I get a numeric Day of the Month instead of
day of week?  Days yields 1-7.  I need 1-31 or
whatever it is for each month.**  (This is most
important)

3. years = d.getYear() yields "100" since it is
century or something.  How do I display the year 2000
as numeric?



What I am trying to do is compare today's date to a
date on the database.  If the date is older than say 5
days then do something, if the day is today then do
something else, etc...)

Help needed ASAP!!! Thanks, Dan








--- Magesh CS <[EMAIL PROTECTED]> wrote:
> Can u get the object as
>
> Object o = resultset.getObject(n);
>
> and manipulate it later.
>
>
> --- Dan Lopez <[EMAIL PROTECTED]> wrote:
> > I am trying to query a simpledatetime field in my
> > db.
> > I have a problem with Date type in JSP code.  I
> > import
> > java.sql.* and Date and Time work fine.  However
> > when
> > I try to import java.util.* and
> > java.text.SimpleDateFormat for formating date,
> time
> > and locale, I get error since java.sql.* and
> > java.util.* both import Date.
> >
> > I can do something like this for date formating
> > alone
> > and it works for me with util and
> SimpleDateFormat:
> > <%
> > SimpleDateFormat datef, timef;
> > Date tim = new Date();
> > Locale fi = new Locale("fi", "FI");
> > datef = new SimpleDateFormat("MM-dd-",
> fi);
> > timef = new SimpleDateFormat("HH:mm:ss", fi);
> > %>
> > Display formatted date only:<%= datef.format(tim)
> %>
> >
> > But here I display query resultset with java.sql.*
> > in
> > which I can do Date or Time and not both:
> > <%
> > if (myResultSet != null) {
> > while (myResultSet.next()) {
> > Date x = myResultSet.getDate(n);
> > ...
> > or
> > Time x = myResultSet.getTime(n);
> > ...
> >
> > 1.How do I display both time and date?
> > 2.How do I format date?
> > 3.How is date arithmetic done in JSP? on DB side
> or
> > in
> > JSP code?
> >
> > **Note I display as**
> >
> > 
> >   
> > <%= x %>
> >   
> > 
> >
> >
> >
> > __
> > Do You Yahoo!?
> > Yahoo! Messenger - Talk while you surf!  It's
> FREE.
> > http://im.yahoo.com/
> >
> >
>
===
> > To unsubscribe: mailto [EMAIL PROTECTED] with
> > body: "signoff JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found
> at:
> >
> >  http://java.sun.com/products/jsp/faq.html
> >  http://www.esperanto.org.nz/jsp/jspfaq.html
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
> __
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf!  It's FREE.
> http://im.yahoo.com/
>
>
===
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets


__
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: ResultSet Type

[Dan Lopez]

How do I get Day of the Month with this methdology:

like x.getDay() or x.getMonth()
is there a way (I know there should be...) to
x.getDayOfMonth()








--- Magesh CS <[EMAIL PROTECTED]> wrote:
> Can u get the object as
>
> Object o = resultset.getObject(n);
>
> and manipulate it later.
>
>
> --- Dan Lopez <[EMAIL PROTECTED]> wrote:
> > I am trying to query a simpledatetime field in my
> > db.
> > I have a problem with Date type in JSP code.  I
> > import
> > java.sql.* and Date and Time work fine.  However
> > when
> > I try to import java.util.* and
> > java.text.SimpleDateFormat for formating date,
> time
> > and locale, I get error since java.sql.* and
> > java.util.* both import Date.
> >
> > I can do something like this for date formating
> > alone
> > and it works for me with util and
> SimpleDateFormat:
> > <%
> > SimpleDateFormat datef, timef;
> > Date tim = new Date();
> > Locale fi = new Locale("fi", "FI");
> > datef = new SimpleDateFormat("MM-dd-",
> fi);
> > timef = new SimpleDateFormat("HH:mm:ss", fi);
> > %>
> > Display formatted date only:<%= datef.format(tim)
> %>
> >
> > But here I display query resultset with java.sql.*
> > in
> > which I can do Date or Time and not both:
> > <%
> > if (myResultSet != null) {
> > while (myResultSet.next()) {
> > Date x = myResultSet.getDate(n);
> > ...
> > or
> > Time x = myResultSet.getTime(n);
> > ...
> >
> > 1.How do I display both time and date?
> > 2.How do I format date?
> > 3.How is date arithmetic done in JSP? on DB side
> or
> > in
> > JSP code?
> >
> > **Note I display as**
> >
> > 
> >   
> > <%= x %>
> >   
> > 
> >
> >
> >
> > __
> > Do You Yahoo!?
> > Yahoo! Messenger - Talk while you surf!  It's
> FREE.
> > http://im.yahoo.com/
> >
> >
>
===
> > To unsubscribe: mailto [EMAIL PROTECTED] with
> > body: "signoff JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found
> at:
> >
> >  http://java.sun.com/products/jsp/faq.html
> >  http://www.esperanto.org.nz/jsp/jspfaq.html
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
> __
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf!  It's FREE.
> http://im.yahoo.com/
>
>
===
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets


__
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: ResultSet Type

[Dan Lopez]

I try to do date arithmetic but I keep getting error:

Error: The type of this expression, "Date", is not
numeric.

I am trying to understand how to subtract a date from
query from today's date.

Sample code:
Date Format:
SimpleDateFormat datef, timef;
  datef = new SimpleDateFormat ("MMM dd ");
  timef = new SimpleDateFormat ("HH:mm")


In my query:
Date x = myResultSet.getDate(n)

In page display:
<% Date tim = new Date(); %>
Date from Query <%= datef.format(x) %>
Today's Date <% datef.format(tim) %>
<% Date d = (tim - x) %>
Arithmetic <%= d %>


Need some assistance asap!  THanks for the help

-Dan








--- Magesh CS <[EMAIL PROTECTED]> wrote:
> Can u get the object as
>
> Object o = resultset.getObject(n);
>
> and manipulate it later.
>
>
> --- Dan Lopez <[EMAIL PROTECTED]> wrote:
> > I am trying to query a simpledatetime field in my
> > db.
> > I have a problem with Date type in JSP code.  I
> > import
> > java.sql.* and Date and Time work fine.  However
> > when
> > I try to import java.util.* and
> > java.text.SimpleDateFormat for formating date,
> time
> > and locale, I get error since java.sql.* and
> > java.util.* both import Date.
> >
> > I can do something like this for date formating
> > alone
> > and it works for me with util and
> SimpleDateFormat:
> > <%
> > SimpleDateFormat datef, timef;
> > Date tim = new Date();
> > Locale fi = new Locale("fi", "FI");
> > datef = new SimpleDateFormat("MM-dd-",
> fi);
> > timef = new SimpleDateFormat("HH:mm:ss", fi);
> > %>
> > Display formatted date only:<%= datef.format(tim)
> %>
> >
> > But here I display query resultset with java.sql.*
> > in
> > which I can do Date or Time and not both:
> > <%
> > if (myResultSet != null) {
> > while (myResultSet.next()) {
> > Date x = myResultSet.getDate(n);
> > ...
> > or
> > Time x = myResultSet.getTime(n);
> > ...
> >
> > 1.How do I display both time and date?
> > 2.How do I format date?
> > 3.How is date arithmetic done in JSP? on DB side
> or
> > in
> > JSP code?
> >
> > **Note I display as**
> >
> > 
> >   
> > <%= x %>
> >   
> > 
> >
> >
> >
> > __
> > Do You Yahoo!?
> > Yahoo! Messenger - Talk while you surf!  It's
> FREE.
> > http://im.yahoo.com/
> >
> >
>
===
> > To unsubscribe: mailto [EMAIL PROTECTED] with
> > body: "signoff JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found
> at:
> >
> >  http://java.sun.com/products/jsp/faq.html
> >  http://www.esperanto.org.nz/jsp/jspfaq.html
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
> __
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf!  It's FREE.
> http://im.yahoo.com/
>
>
===
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets


__
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: ResultSet Type

[Dan Lopez]

I am trying to query a simpledatetime field in my db.
I have a problem with Date type in JSP code.  I import
java.sql.* and Date and Time work fine.  However when
I try to import java.util.* and
java.text.SimpleDateFormat for formating date, time
and locale, I get error since java.sql.* and
java.util.* both import Date.

I can do something like this for date formating alone
and it works for me with util and SimpleDateFormat:
<%
SimpleDateFormat datef, timef;
Date tim = new Date();
Locale fi = new Locale("fi", "FI");
datef = new SimpleDateFormat("MM-dd-", fi);
timef = new SimpleDateFormat("HH:mm:ss", fi);
%>
Display formatted date only:<%= datef.format(tim) %>

But here I display query resultset with java.sql.* in
which I can do Date or Time and not both:
<%
if (myResultSet != null) {
while (myResultSet.next()) {
Date x = myResultSet.getDate(n);
...
or
Time x = myResultSet.getTime(n);
...

1.How do I display both time and date?
2.How do I format date?
3.How is date arithmetic done in JSP? on DB side or in
JSP code?

**Note I display as**


  
<%= x %>
  




__
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: Form Mail

[Dan Lopez]

Need good example to get started.

Thanks

__
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: Concatenate

[Dan Lopez]

Code:

ResultSet myResultSet = stmt.executeQuery(Select from .);

Would like to concatenate at end of line to make code
look nicer.  Thanks for the help.

-D


__
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: Concatenate

[Dan Lopez]

How do I concatenate in JSP SQL statement?

Help needed asap.

Thanks

__
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: JRUN performance

[Dan Lopez]

Jrun performance REALLY slow on resultset.  I am even
caching some resultset and only display 5% of data and
still SO SLOW!  Any suggestions?

-D

__
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: Result Sets

[Dan Lopez]

Try http://www.jsptags.com

**pagerlist**
If you know a little XML, can do wonders

Hope this helps



--- info <[EMAIL PROTECTED]> wrote:
> Hi ...
> Anybody have source of result set dispalying 1-10
> records per page.
> Caution: I dont want that to take all the resultset
> in vector . Coz if have
> millions of records it can cause shortage of
> memeory.
>
> thanks
> william
>
>
===
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets


__
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Netscape/Tomcat

[Dan Lopez]

I have installed Tomcat on my server.  My Webserver is
Netscape Enterprise.  Can I use Tomcat as a standalone
and map path to/from Netscape.  Not sure where to go
from here.



__
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: RecordSet

[Dan Lopez]

Try:



<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection yourConn =
DriverManager.getConnection("jdbc:odbc:your_dsn","usrname","passwd");
Statement stmt = yourConn.createStatement();
ResultSet yourResultSet = stmt.executeQuery("Select *
from your_table");

if (yourResultSet != null) {
while (yourResultSet.next()) {
String a = yourResultSet.getString(1);
(so on and so on)

%>

<%= a %>
(so on and so on...)



<%
} /*close while
 } /*close if

   stmt.close();
   myConn.close();
%>

"(1)" as place holder in parameter (but 1 could be
anything, make sure syntax is correct though), display
value "a". this is basically what i do and it works.
hope this helps.




--- Sanjay Vashisht <[EMAIL PROTECTED]> wrote:
> You cannot pass a parameter to the getString( )
> method. Remove the
> parameter
> passed, before retrieving just have a reference of
> Metadata interface
> for recordset
> and traverse  through recordset using rs.next().
>
> Rgds
>
> Sanjay
>
> Modassir Sattar wrote:
>
> > Hi,
> >
> > I am trying to execute a query in a JSP page, but
> I am getting a page full
> > of errors.
> > The code is working fine upto the
> executeQuery("select * from sss")
> > statement, but when I tried to disply the
> recordset using
> > rs.getString("Name") these errors are displayed.
> >
> > I am using IBM's WebSphere server and DB2
> Database, and I used jdbc.odbc
> > bridge to access the database.
> >
> > Does any body know what I am doing wrong.
> >
> > Your help is appreciated.
> >
> > Thanks.
> >
> > Modassir
> >
> >
>
===
> > To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found
> at:
> >
> >  http://java.sun.com/products/jsp/faq.html
> >  http://www.esperanto.org.nz/jsp/jspfaq.html
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
===
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets


__
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: SQL Date Arithemtic

[Dan Lopez]

Right now I do something like this for an example:

<%@ page import="java.util.*,
java.text.SimpleDateFormat"%>

<%
   SimpleDateFormat datef, timef;
   Date tim = new Date();

  Locale fi = new Locale( "fi", "FI" );
  datef = new SimpleDateFormat( "MM.dd.", fi
);
  timef = new SimpleDateFormat( "HH:mm:ss", fi);

int hours;
hours = tim.getHours();
int days;
days = tim.getDay();
%>

The current date at the server is <%= tim %>.



Display date only: <%= datef.format(tim) %>



Display numeric value of the day of the week only
(i.e. Thursday = 4):  <%= days %>



Display comparison of numeric conversion days of the
week:
  <% if (days > 1) { %>
  Text is orange but could be row
color   <% } %>
  <% if (days == 3) { %>
  Text is blue

but could be row color, etc
  <% } %>
  <% if (days < 5) { %>
  Text is red but
could be row color
  <% } %>



Display time only: <%= timef.format(tim) %>

And so forth...All works fine.  But I cant seem to be
able to compare values of that date and the date from
the database.

So how should I change my page objective (ie
java.util*) to be able to do date arithmetic?  My SQL
query gets a value like "Oct 1 2000 12:00AM" as a
smalldatetime.

I think the way I did it in JSP looks like "TUES OCT 2
2000 GMT 1200AM."

Suggestions?





--- Ajit Bhingarkar <[EMAIL PROTECTED]> wrote:
> 1. First you have to create a proper util.Date
> object
> by parsing the date string selected in the table.
> You can use standard parsers. Refer to java.text.
> 2. You then have to get the java.util.Calendar
> object for the
> Date so created. This class has many util methods to
> compare, add to, subtract from the your Date.
> You can also set individual attributes like day of
> the week,
> day of the month, month of the year etc.
>
> Hope this helps ..
>
> - Ajit
>
> Dan Lopez wrote:
> >
> > I am selecting smalldatetime field from a table in
> my
> > db. I would like to know how to compare the date
> > values in the query to certain criteria (eg 48
> hours
> > ago, 10 days from now, etc...) that I specify in
> my
> > JSP code and then display.  Please help
> >
> > __
> > Do You Yahoo!?
> > Yahoo! Photos - 35mm Quality Prints, Now Get 15
> Free!
> > http://photos.yahoo.com/
> >
> >
>
===
> > To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found
> at:
> >
> >  http://java.sun.com/products/jsp/faq.html
> >  http://www.esperanto.org.nz/jsp/jspfaq.html
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
===
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets


__
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: SQL Date Arithemtic

[Dan Lopez]

I am selecting smalldatetime field from a table in my
db. I would like to know how to compare the date
values in the query to certain criteria (eg 48 hours
ago, 10 days from now, etc...) that I specify in my
JSP code and then display.  Please help

__
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: Converting int to String on a JSP page

[Dan Lopez]

I have relatively the same question.  If I query
smalldatetime from one of my tables, how do I do
arithmetic with that date.  Do I have to convert the
value of the date to an int?






--- Duncan Rose <[EMAIL PROTECTED]> wrote:
> The same one you'd use anywhere else in Java -
> String.valueOf(int).
>
> As in:
>
> ...
> int var = 1;
> String stringified = String.valueOf(var);
> %>
> Stringified value == <%= stringified %>
> ...
>
>
> -Original Message-
> From: Lorena Carlo [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 07, 1999 3:43 PM
> To: [EMAIL PROTECTED]
> Subject: Converting int to String on a JSP page
>
>
> Hi all,
>
> Can anybody tell me which function could to convert
> a variable from int to
> String on a JSP page.
>
> Thanks in advance
>
> Lorena
>
>
===
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff
> JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
===
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets


__
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: Jsp With XML

[Dan Lopez]

Take a look at Pager Taglib from
http://www.jsptags.com

-D


--- Pranav Bansal <[EMAIL PROTECTED]> wrote:
> Hi all,
>  Could anyone tell me the way for using XML
> as middle tier with Jsp
> Application?
> Let me explain you that what I want to Do. I have a
> jsp page at which I have
> some drop downs like for selecting country, for
> state, for city etc. Now
> depending upon the selection I have to fire a
> database query fro retrieving
> records from the database. Records can be 5, 10 or
> more then 10 Here I
> want to use XML as middle tier in such a way that at
> first time when
> query'll fire, XML document should populate with
> records and I could use
> this populated XML document for displaying the
> records. I don't want to
> display more then 5 records on a page, so I have to
> access this XML document
> again and again but without firing database query
> again and again.
> Please give me some suggestions or code or example
> regarding this. If anyone
> know some other method then Please tell me. I don't
> want to use CachedRowSet
> because records could be more then 100.
> Please help me.
> Thanks
> With Regards,
> Pranav Kumar
> Software Engineer
> Informica India Pvt. ltd.
> Noida,India
> Phone: -91-118-4514702
> www.informica.com
>
>
===
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets


__
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: TOMCAT Questions for Netscape Enterprise??

[Dan Lopez]

How do I install Tomcat for Netscape enterprise
server.  The howto on the jakarta page is for NT.  Can
someone help me or point me in the right direction.
Thanks




__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Form Handling

[Dan Lopez]

Where is a good place to look for JSP tutorial on form
handler for login page?

-D

__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Pager Tag Lib Help! (Very Cool by the way...)

[Dan Lopez]

Hi James,

Thanks for pointing me in the right direction.  The
Pager Tag library is exactly what I needed, and is
very cool! I am sure many others out there have been
looking for this solution. However, I am stuck on
trying to configure it for Jrun.  I need a hand
getting started.  I have my app residing in the defaut
dir:

/JRun/default/demo-app/jsp

I am not sure which WEB-INF dir to edit web.xml file
and to copy the *.tld file.  Please help!  Thanks for
all your time and effort.

-Dan

PS:  do I edit the following:


http://jsptags.com/tags/navigation/pager


/WEB-INF/jsp/pager-taglib.tld



to point to my url and my dir where the *.tld file resides?

__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Tomcat

[Dan Lopez]

I am using Jrun for development but would like to use
a free implementation of some kind for production
deployment.  I have thought of using Tomcat but is
there a win32 version that I can use for testing and
deployment? Thanks

__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Re: PagesList Howto

[Dan Lopez]

What I know is this:

ASP has built in features for this.  However, JSP does
not.  You have to trick the application by doing a row
count, defining how many rows per page an then making
links point to each page number.  It was mentioned to
my that I should try vector methodology.  But since I
an new to JAVA (only a couple of days) I dont think I
am up to that level yet.

Please advise..


--- Robert Gutman <[EMAIL PROTECTED]> wrote:
> I need help on that too. Is there an answer for it
> ?
>
> -Original Message-
> From: Dan Lopez [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 21, 2000 2:13 PM
> To: [EMAIL PROTECTED]
> Subject: PagesList Howto
>
>
> I would like to know how to write a PagesList
> navigation for my JSP app that gets a resultset from
> a
> database query and depending on how many records
> there
> are print out navigation like 1|2|3|4|5 etc.
>
> Thanks
>
> __
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo!
> Messenger.
> http://im.yahoo.com/
>
>
===
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff
> JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
> Visit our website at http://www.p21.com/visit
> The information in this e-mail is confidential and
> may contain legally
> privileged information.  It is intended solely for
> the person or entity to
> which it is addressed.  Access to this e-mail by
> anyone else is
> unauthorized. If you are not the intended recipient,
> any disclosure,
> copying, distribution, action taken, or action
> omitted to be taken in
> reliance on it, is prohibited and may be unlawful.
> If you received this
> e-mail in error, please contact the sender and
> delete the material from any
> computer.
>
>
===
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets


__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

PagesList Howto

[Dan Lopez]

I would like to know how to write a PagesList
navigation for my JSP app that gets a resultset from a
database query and depending on how many records there
are print out navigation like 1|2|3|4|5 etc.

Thanks

__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets