• Post Reply Bookmark Topic Watch Topic
  • New Topic

Need Help  RSS feed

 
Gaurav Kalra
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,
i'm developing a site in which i am having the following problems.
1) Suppose i wish to show the user some information and then i want to redirect him to another page. How do i do that.
2) Using JSP how can i send mail to someone.
3) How can i have a page be executed every day at a particular time. Will Thread.sleep() help me.
4) Can i have subqueries in MySQL. I have problems in executing my query which has a subquery.
Any help will be greatly acknowledged. I know maha anna will surely reply. Thanx to her.
Gaurav
 
maha anna
Ranch Hand
Posts: 1467
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
1. We may have to use this meta tag.
Here content="1 means the redirection will take place after 1 sec.
<META HTTP-EQUIV="REFRESH" CONTENT="1;URL='nextpage.jsp'">
http://www.javaranch.com/ubb/Forum7/HTML/002604.html

2. Please refer to this discussion
http://www.javaranch.com/ubb/Forum7/HTML/002734.html
3. Please repharse your question
4. No. SubQuery is NOT SUPPORTED in MySql. I experienced the same problem as yours, when the appln used SubQueries. Initially I tested locally with Access and the system worked fine. After deployed in webappcabaret.com that particular feature alone didn't work. Latter when I digged out those online manuals, came to know this. Here are some references from Mysql.com.
We have to re-write the subquery to get the same results.
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html
regds
maha anna
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!