Need Help

[Gaurav Kalra]

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]

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