RE: $20 bucks to the 1st person who actually solves my problem!!! - WE HAVE A WINNER!!!
These lists are great becuase sometimes you need others to provide a new outlook to the problem -Original Message- From: G.Nagarajan [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 11:38 AM To: [EMAIL PROTECTED] Subject: RE: $20 bucks to the 1st person who actually solves my problem!!! - WE HAVE A WINNER!!! This is off topic but this reminds me that most of the time we try to solve problems thinking that we have understood the problem completely and have an intuition where the solution is. And we spend lots of effort and time trying to fix the imaginary problem. Like in this case, we thought it was due to caching and tried to fix it and it has turned out to be with the database part ! I wonder what Adress would have done without this mailing list! -Original Message- From: Adress, David S. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 5:16 PM To: '[EMAIL PROTECTED]' Subject: RE: $20 bucks to the 1st person who actually solves my problem!!! - WE HAVE A WINNER!!! I guess it appeared to be caching
RE: $20 bucks to the 1st person who actually solves my problem!!! - WE HAVE A WINNER!!!
This is off topic but this reminds me that most of the time we try to solve problems thinking that we have understood the problem completely and have an intuition where the solution is. And we spend lots of effort and time trying to fix the imaginary problem. Like in this case, we thought it was due to caching and tried to fix it and it has turned out to be with the database part ! I wonder what Adress would have done without this mailing list! -Original Message- From: Adress, David S. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 5:16 PM To: '[EMAIL PROTECTED]' Subject: RE: $20 bucks to the 1st person who actually solves my problem!!! - WE HAVE A WINNER!!! I guess it appeared to be caching
RE: $20 bucks to the 1st person who actually solves my problem!!! - WE HAVE A WINNER!!!
I guess it appeared to be caching -Original Message- From: NESTORS Andris (AC-Creation) [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 10:57 AM To: '[EMAIL PROTECTED]' Subject: RE: $20 bucks to the 1st person who actually solves my problem!!! - WE HAVE A WINNER!!! So it was nothing to do with caching ? # -Original Message- # From: Adress, David S. [mailto:[EMAIL PROTECTED]] # Sent: Friday, December 08, 2000 3:09 PM # To: '[EMAIL PROTECTED]' # Subject: FW: $20 bucks to the 1st person who actually solves my # problem!!! - WE HAVE A WINNER!!! # # # FYI # # -Original Message- # From: Adress, David S. # Sent: Friday, December 08, 2000 10:08 AM # To: '[EMAIL PROTECTED]' # Subject: RE: $20 bucks to the 1st person who actually solves my # problem!!! # # # BINGO! # # that's itI wasn't doing a commit and I was connecting to # access...so # access doesn't do a commit until it moves to next row... # # What's your address so I can send you the prize!!! # # -Original Message- # From: Neil H. [mailto:[EMAIL PROTECTED]] # Sent: Friday, December 08, 2000 9:00 AM # To: JRun-Talk # Subject: Re: $20 bucks to the 1st person who actually solves my # problem!!! # # # Make sure you display applet doesn't query the database # BEFORE the action # takes place. We do this in CF all the time. Query the info # we want then # make the change, at that point it was correct in the database but we # requested the info too soon. # # Neil # # - Original Message - # From: "Adress, David S." <[EMAIL PROTECTED]> # To: "JRun-Talk" <[EMAIL PROTECTED]> # Sent: Friday, December 08, 2000 8:29 AM # Subject: $20 bucks to the 1st person who actually solves my problem!!! # # # > I am on this for days and I can't figure out what I'm doing # wrong. I will # > send $20 bucks to 1st person who actually solves my problem. # > # > I am using jsp page's to control the layout of my page and # servlets to # spit # > back # > table data or to do database transactions. # > # > I have a jsp page that displays a list of employees. The jsp page # > has an include statement to include the servlet to spit out # the table. # > The jsp just handles the general look of the page and the # servlet just # > spits out the table and table html tags. Next to each # record I have an add # > and # > delete hyperlink. If someone clicks the add link it # displays another page # to # > add # > an employee and then the action servlet adds the record and # then goes back # > to the jsp # > list page. If some one deletes a record it calls a servlet # to delete and # > then the servlet redirects back to the jsp list page. But # the list doesn't # > display the updated data without having me hit the refresh # button in the # > browser. # > # > I tried using Tomcat and now am using Jrun and am still # having the same # > problem. # > # > I've included all the proper meta tags in the jsp list page # not to cache # but # > it's not working. I've also tries doing it with # reponse.setHeader but it # > doesn't work either. # > # > I've tried sending a random number param to the page # > ShowList?rnd=Randomnumber it still doesn't work. # > # > # > # > Your ad could be here. Monies from ads go to support these lists and # provide more resources for the community. # http://www.fusionauthority.com/ads.cfm # > # > Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ # > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists # > # # # Your ad could be here. Monies from ads go to support these # lists and provide # more resources for the community. # http://www.fusionauthority.com/ads.cfm # # Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ # Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists #
RE: $20 bucks to the 1st person who actually solves my problem!!! - WE HAVE A WINNER!!!
So it was nothing to do with caching ? # -Original Message- # From: Adress, David S. [mailto:[EMAIL PROTECTED]] # Sent: Friday, December 08, 2000 3:09 PM # To: '[EMAIL PROTECTED]' # Subject: FW: $20 bucks to the 1st person who actually solves my # problem!!! - WE HAVE A WINNER!!! # # # FYI # # -Original Message- # From: Adress, David S. # Sent: Friday, December 08, 2000 10:08 AM # To: '[EMAIL PROTECTED]' # Subject: RE: $20 bucks to the 1st person who actually solves my # problem!!! # # # BINGO! # # that's itI wasn't doing a commit and I was connecting to # access...so # access doesn't do a commit until it moves to next row... # # What's your address so I can send you the prize!!! # # -Original Message- # From: Neil H. [mailto:[EMAIL PROTECTED]] # Sent: Friday, December 08, 2000 9:00 AM # To: JRun-Talk # Subject: Re: $20 bucks to the 1st person who actually solves my # problem!!! # # # Make sure you display applet doesn't query the database # BEFORE the action # takes place. We do this in CF all the time. Query the info # we want then # make the change, at that point it was correct in the database but we # requested the info too soon. # # Neil # # - Original Message - # From: "Adress, David S." <[EMAIL PROTECTED]> # To: "JRun-Talk" <[EMAIL PROTECTED]> # Sent: Friday, December 08, 2000 8:29 AM # Subject: $20 bucks to the 1st person who actually solves my problem!!! # # # > I am on this for days and I can't figure out what I'm doing # wrong. I will # > send $20 bucks to 1st person who actually solves my problem. # > # > I am using jsp page's to control the layout of my page and # servlets to # spit # > back # > table data or to do database transactions. # > # > I have a jsp page that displays a list of employees. The jsp page # > has an include statement to include the servlet to spit out # the table. # > The jsp just handles the general look of the page and the # servlet just # > spits out the table and table html tags. Next to each # record I have an add # > and # > delete hyperlink. If someone clicks the add link it # displays another page # to # > add # > an employee and then the action servlet adds the record and # then goes back # > to the jsp # > list page. If some one deletes a record it calls a servlet # to delete and # > then the servlet redirects back to the jsp list page. But # the list doesn't # > display the updated data without having me hit the refresh # button in the # > browser. # > # > I tried using Tomcat and now am using Jrun and am still # having the same # > problem. # > # > I've included all the proper meta tags in the jsp list page # not to cache # but # > it's not working. I've also tries doing it with # reponse.setHeader but it # > doesn't work either. # > # > I've tried sending a random number param to the page # > ShowList?rnd=Randomnumber it still doesn't work. # > # > # > # > Your ad could be here. Monies from ads go to support these lists and # provide more resources for the community. # http://www.fusionauthority.com/ads.cfm # > # > Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ # > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists # > # # # Your ad could be here. Monies from ads go to support these # lists and provide # more resources for the community. # http://www.fusionauthority.com/ads.cfm # # Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ # Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists #
RE: $20 bucks to the 1st person who actually solves my problem!!!
David, This might be worth a shot. in the page you want reloaded, try adding in this this meta tag forces no cache of the page so it is suppose to be refreshed from the server everytime. Let me know if this help. Mike > -Original Message- > From: Adress, David S. [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 08, 2000 7:29 AM > To: '[EMAIL PROTECTED]'; 'JRun-Talk' > Subject: $20 bucks to the 1st person who actually solves my problem!!! > > > I am on this for days and I can't figure out what I'm doing wrong. I will > send $20 bucks to 1st person who actually solves my problem. > > I am using jsp page's to control the layout of my page and > servlets to spit > back > table data or to do database transactions. > > I have a jsp page that displays a list of employees. The jsp page > has an include statement to include the servlet to spit out the table. > The jsp just handles the general look of the page and the servlet just > spits out the table and table html tags. Next to each record I have an add > and > delete hyperlink. If someone clicks the add link it displays > another page to > add > an employee and then the action servlet adds the record and then goes back > to the jsp > list page. If some one deletes a record it calls a servlet to delete and > then the servlet redirects back to the jsp list page. But the list doesn't > display the updated data without having me hit the refresh button in the > browser. > > I tried using Tomcat and now am using Jrun and am still having the same > problem. > > I've included all the proper meta tags in the jsp list page not > to cache but > it's not working. I've also tries doing it with reponse.setHeader but it > doesn't work either. > > I've tried sending a random number param to the page > ShowList?rnd=Randomnumber it still doesn't work. > > >
RE: $20 bucks to the 1st person who actually solves my problem!!!
This last one sounds odd but does work sometimes, alternatively, when you send the add/delete command back, make it a POST on the form, IE will expect this to be dynamic data and not cache. Make the link submit the form with appropriate parameters. Ken. [EMAIL PROTECTED] on 08/12/2000 10:19:25 Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: Ken X Horn) Subject: RE: $20 bucks to the 1st person who actually solves my problem!!! Save your money - if this works, fine. I've had the same problems a time or two myself. First, try putting the meta tags at the end of the page as well as at the start - something about the way the browsers process the information... I don't know. I do it, it helps. Secondly, keeping in mind that a redirect is a browser function and if the above is ineffective, rewrite the page logic to perform the delete and then spit out the HTML from the display page, as opposed to redirecting to it. Hoping this helps, Chris. -Original Message- From: Adress, David S. [mailto:[EMAIL PROTECTED]] Sent: Friday, 8 December 2000 11:29 PM To: '[EMAIL PROTECTED]'; 'JRun-Talk' Subject: $20 bucks to the 1st person who actually solves my problem!!! I am on this for days and I can't figure out what I'm doing wrong. I will send $20 bucks to 1st person who actually solves my problem. I am using jsp page's to control the layout of my page and servlets to spit back table data or to do database transactions. I have a jsp page that displays a list of employees. The jsp page has an include statement to include the servlet to spit out the table. The jsp just handles the general look of the page and the servlet just spits out the table and table html tags. Next to each record I have an add and delete hyperlink. If someone clicks the add link it displays another page to add an employee and then the action servlet adds the record and then goes back to the jsp list page. If some one deletes a record it calls a servlet to delete and then the servlet redirects back to the jsp list page. But the list doesn't display the updated data without having me hit the refresh button in the browser. I tried using Tomcat and now am using Jrun and am still having the same problem. I've included all the proper meta tags in the jsp list page not to cache but it's not working. I've also tries doing it with reponse.setHeader but it doesn't work either. I've tried sending a random number param to the page ShowList?rnd=Randomnumber it still doesn't work.
RE: $20 bucks to the 1st person who actually solves my problem!!!
Save your money - if this works, fine. I've had the same problems a time or two myself. First, try putting the meta tags at the end of the page as well as at the start - something about the way the browsers process the information... I don't know. I do it, it helps. Secondly, keeping in mind that a redirect is a browser function and if the above is ineffective, rewrite the page logic to perform the delete and then spit out the HTML from the display page, as opposed to redirecting to it. Hoping this helps, Chris. -Original Message- From: Adress, David S. [mailto:[EMAIL PROTECTED]] Sent: Friday, 8 December 2000 11:29 PM To: '[EMAIL PROTECTED]'; 'JRun-Talk' Subject: $20 bucks to the 1st person who actually solves my problem!!! I am on this for days and I can't figure out what I'm doing wrong. I will send $20 bucks to 1st person who actually solves my problem. I am using jsp page's to control the layout of my page and servlets to spit back table data or to do database transactions. I have a jsp page that displays a list of employees. The jsp page has an include statement to include the servlet to spit out the table. The jsp just handles the general look of the page and the servlet just spits out the table and table html tags. Next to each record I have an add and delete hyperlink. If someone clicks the add link it displays another page to add an employee and then the action servlet adds the record and then goes back to the jsp list page. If some one deletes a record it calls a servlet to delete and then the servlet redirects back to the jsp list page. But the list doesn't display the updated data without having me hit the refresh button in the browser. I tried using Tomcat and now am using Jrun and am still having the same problem. I've included all the proper meta tags in the jsp list page not to cache but it's not working. I've also tries doing it with reponse.setHeader but it doesn't work either. I've tried sending a random number param to the page ShowList?rnd=Randomnumber it still doesn't work.
RE: $20 bucks to the 1st person who actually solves my problem!!!
It didn't work
Here is a copy of the jsp page and the servlet
JSP PAGE
Employee List
Employee List
List Servlet
import java.io.IOException;
import java.io.PrintWriter;
import java.util.Enumeration;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class EmployeeList extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse
response)
throws ServletException, IOException
{
HttpSession session = request.getSession(true);
response.setIntHeader("Expires",0);
response.setHeader("Cache-Control","no-cache");
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String Logon = session.getAttribute("Logon").toString();
String Level = session.getAttribute("Level").toString();
if (Logon.compareTo("TRUE") == 0);
else
{
out.println("No Access");
return;
}
if (Level.compareTo("A") == 0);
else
{
out.println("No Access you need to be an Admin");
return;
}
String query = "SELECT EmployeeID, LastName, Firstname FROM
employees order by lastname";
out.println("");
out.println(" ");
out.println(" Add New Employee");
out.println(" ");
out.println(" ");
out.println(" EmployeeID");
out.println(" Lastname");
out.println(" Firstname");
out.println(" Commands");
out.println(" ");
try
{
Connection dbconn;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbconn =
DriverManager.getConnection("jdbc:odbc:ADB");
Statement statement = dbconn.createStatement();
ResultSet rs = statement.executeQuery( query );
while(rs.next())
{
String empid = rs.getString(1);
out.println(" ");
out.println(" " + empid +
"");
out.println(" " +
rs.getString(2) + "");
out.println(" " +
rs.getString(3) + "");
out.println(" Delete
Edit");
out.println(" ");
}
}
catch ( Exception excp )
{
// process remaining Exceptions here
excp.printStackTrace();
out.println(excp.toString());
}
out.println("");
}
}
-Original Message-
From: Chad Reese [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 8:59 AM
To: [EMAIL PROTECTED]
Subject: Re: $20 bucks to the 1st person who actually solves my
problem!!!
Try this in your servlet:
res.setIntHeader("Expires", 0);
res.setHeader("Cache-Control", "no-cache");
And this in the page source:
IE ignores the cache directives but seems to respect the Expires header.
Both of
the above probably aren't necessary but they don't hurt. Hope this helps.
Chad
P.S. Help is free but the title did get my attention :-)
"Adress, David S." wrote:
> I am on this for days and I can't figure out what I'm doing wrong. I will
> send $20 bucks to 1st person who actually solves my problem.
>
> I am using jsp page's to control the layout of my page and servlets to
spit
> back
> table data or to do database transactions.
>
> I have a jsp page that displays a list of employees. The jsp page
> has an include statement to include the servlet to spit out the table.
> The jsp just handles the general look of the page and the servlet just
> spits out the table and table html tags. Next to each record I have an add
> and
&
RE: $20 bucks to the 1st person who actually solves my problem!!!
In onload i'm trying a document.refresh. I'm not getting any javascript error so it's definitely calling it but it didn't solve the problem... Thanks -Original Message- From: Stefán F. Stefánsson [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 8:41 AM To: [EMAIL PROTECTED] Subject: RE: $20 bucks to the 1st person who actually solves my problem!!! Try to find some way of using the javascript code "this.location.refresh()" in this. For example... you could have the JSP page or the servlet add the code onLoad="this.location.refresh()" into the body tag of the jsp page if the user has just deleted an entry. That way the client browser should force the page to be refreshed. I hope this helps solving your problem... please forget about the money ;o) Kind Regards, Stefan Freyr -Original Message- From: Adress, David S. [mailto:[EMAIL PROTECTED]] Sent: 8. desember 2000 13:29 To: '[EMAIL PROTECTED]'; 'JRun-Talk' Subject: $20 bucks to the 1st person who actually solves my problem!!! I am on this for days and I can't figure out what I'm doing wrong. I will send $20 bucks to 1st person who actually solves my problem. I am using jsp page's to control the layout of my page and servlets to spit back table data or to do database transactions. I have a jsp page that displays a list of employees. The jsp page has an include statement to include the servlet to spit out the table. The jsp just handles the general look of the page and the servlet just spits out the table and table html tags. Next to each record I have an add and delete hyperlink. If someone clicks the add link it displays another page to add an employee and then the action servlet adds the record and then goes back to the jsp list page. If some one deletes a record it calls a servlet to delete and then the servlet redirects back to the jsp list page. But the list doesn't display the updated data without having me hit the refresh button in the browser. I tried using Tomcat and now am using Jrun and am still having the same problem. I've included all the proper meta tags in the jsp list page not to cache but it's not working. I've also tries doing it with reponse.setHeader but it doesn't work either. I've tried sending a random number param to the page ShowList?rnd=Randomnumber it still doesn't work.
Re: $20 bucks to the 1st person who actually solves my problem!!!
Try this in your servlet:
res.setIntHeader("Expires", 0);
res.setHeader("Cache-Control", "no-cache");
And this in the page source:
IE ignores the cache directives but seems to respect the Expires header. Both of
the above probably aren't necessary but they don't hurt. Hope this helps.
Chad
P.S. Help is free but the title did get my attention :-)
"Adress, David S." wrote:
> I am on this for days and I can't figure out what I'm doing wrong. I will
> send $20 bucks to 1st person who actually solves my problem.
>
> I am using jsp page's to control the layout of my page and servlets to spit
> back
> table data or to do database transactions.
>
> I have a jsp page that displays a list of employees. The jsp page
> has an include statement to include the servlet to spit out the table.
> The jsp just handles the general look of the page and the servlet just
> spits out the table and table html tags. Next to each record I have an add
> and
> delete hyperlink. If someone clicks the add link it displays another page to
> add
> an employee and then the action servlet adds the record and then goes back
> to the jsp
> list page. If some one deletes a record it calls a servlet to delete and
> then the servlet redirects back to the jsp list page. But the list doesn't
> display the updated data without having me hit the refresh button in the
> browser.
>
> I tried using Tomcat and now am using Jrun and am still having the same
> problem.
>
> I've included all the proper meta tags in the jsp list page not to cache but
> it's not working. I've also tries doing it with reponse.setHeader but it
> doesn't work either.
>
> I've tried sending a random number param to the page
> ShowList?rnd=Randomnumber it still doesn't work.
--
Chad Reese
Software Engineer
Presideo
Phone: 561 - 581 - 7079
Email: mailto:[EMAIL PROTECTED]
RE: $20 bucks to the 1st person who actually solves my problem!!!
Try to find some way of using the javascript code "this.location.refresh()" in this. For example... you could have the JSP page or the servlet add the code onLoad="this.location.refresh()" into the body tag of the jsp page if the user has just deleted an entry. That way the client browser should force the page to be refreshed. I hope this helps solving your problem... please forget about the money ;o) Kind Regards, Stefan Freyr -Original Message- From: Adress, David S. [mailto:[EMAIL PROTECTED]] Sent: 8. desember 2000 13:29 To: '[EMAIL PROTECTED]'; 'JRun-Talk' Subject: $20 bucks to the 1st person who actually solves my problem!!! I am on this for days and I can't figure out what I'm doing wrong. I will send $20 bucks to 1st person who actually solves my problem. I am using jsp page's to control the layout of my page and servlets to spit back table data or to do database transactions. I have a jsp page that displays a list of employees. The jsp page has an include statement to include the servlet to spit out the table. The jsp just handles the general look of the page and the servlet just spits out the table and table html tags. Next to each record I have an add and delete hyperlink. If someone clicks the add link it displays another page to add an employee and then the action servlet adds the record and then goes back to the jsp list page. If some one deletes a record it calls a servlet to delete and then the servlet redirects back to the jsp list page. But the list doesn't display the updated data without having me hit the refresh button in the browser. I tried using Tomcat and now am using Jrun and am still having the same problem. I've included all the proper meta tags in the jsp list page not to cache but it's not working. I've also tries doing it with reponse.setHeader but it doesn't work either. I've tried sending a random number param to the page ShowList?rnd=Randomnumber it still doesn't work.
