Hi
In my application i am using the jsp and mysql database. in this i am viewing the candidate name , age , Priority ect.. now i want to update my application with some future. That is the headings are in button. if i click the Name button it should shows the name in asc and the next click it shows the desc order. i don't know how can i do it. in the same way i want to do the age and priority also.
Any one please help to...
sang
Last Activity: Feb 14 '08, 10:31 AM
Joined: Sep 12 '06
Location:
-
Listing the data in order
-
Problem in Date selection
Hi
I am working in mysql database system, i want to select the some fields with the date. For Example in a company employers details are stroed the is name, dateofjoin, age, Address etc. I want to select the particular employer those are joing in from date 'somedate' to 'somedate' .
mysql is...Code:create table emp_join(name varchar(20),join_date date,age int); +------+------------+------+ | name |
-
How to send MySQL BLOB data using PHP
Hi
i am doing my project in Mysql and PHP. My problem is i want to send a Blob field to my email using the Php. That is i am storing Candidates Resume in Blob field(Document format). I want to Choose the Particular Candidates Resume and the send to some Email address.But i want to know how can i get the field from mysql and how to send it to the particular emailid.
Please any one help to solve my problem.
Thanks... -
This is already i done. but i want to print the count of domain names. i done that also (ie)
Thank you for your replyCode:Select substring_index(emailid,'@',-1)as domain,count(Emailid) from User_ account group by domain;
Sang... -
How can i count the emaiid in my table
Hi
I had a table with the Emailid, i want to count the particular domain in the Field Emailid.
For Example
I want to count domainsCode:Table User_account; Emailid Id qqq@yahoo.com 1 eee@rediff.com 2 jjjjj@yahoo.com 3
Please give me the query to...Code:Emailid count yahoo.com 2 rediff.com 1
-
How can i get the Resume with the userid?
Please help to solve my problem
Thanks and Regards
Sang...Leave a comment:
-
In my program i am storing different resumes for different Userid.
and also different keywords for different JobRefNo
i want to retrive the keywords and the particular count for the JobRefNo which is matching to the resume. More than one Userid matching to the one JobRefNo so that i want to select it by condition both JobRefNo and Userid mathc to the Resume.
The keywords are retrive corectly but resumes...Leave a comment:
-
My Table Details are give below
...Code:JOB_APPLICATION; +---------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+-------+ | UserId | int(11) | NO | PRI | 0 | | | JobRefNo | int(11) | NO | PRI | 0 | | | A1 | varchar(10)
Leave a comment:
-
How can i get the Resume. Please Give me what correction i can made in my query its very urgent.
Thankyou
Sang...Leave a comment:
-
Yes i am using different resume for keywords.
How can i get the Resume...Leave a comment:
-
The count value is incorrect. That is the sql1 gets the keyword form the dataabase and split it.
The sql2 gets the resume from database and check the resume with the keyword.
I want to count the noof keywords appears in the resume.
in normal java program it works well but in the jsp i got incorrect count values.
The count values are changed after refeshing (every time) of the page.
This is most urget so...Leave a comment:
-
Hello Sir,
I want to use above code in jsp page to print the keywords and count. But the count values is not correct .
please help to do and also how can i place this code in jsp.
my code.
...Code:<table border="0" cellspacing="4"> <tr> <td width="241" align="right" valign="middle" bgcolor="#0F6484"><divLeave a comment:
-
I do this program in jsp. I don't know how to call the function in jsp because the inputs are taken from the database. i think the main method is easly implemented in jsp. I am also do this in jsp but it print the keywords only the count values is 0. so that i ask how can i do this without function call.
Please help to do this
Thanks and Regards
Sang...Leave a comment:
-
Hello Sir
Another help to do the above program in single method.
In the above program the count is seperate function and it is call on the main.
but i want to all this on main there is no other function call.
I will try this one but my output is 0 please help to do this
...Code:public class strcount { public static void main(String arg[]) { String resume = "java,html,jsp,c,java,dhtml,unix,html";Leave a comment:
-
Thankyou very much for your help...Leave a comment:
-
I tried this one but there is no changes in my output.
Thankyou for your kind help,
Sang...Leave a comment:
-
Thanyou for your kind help
I solved the problem and my program is excuted well. But the count will reduce the count by one. my keyword appears actually 3 times but in the output will be printed as 2 times appears.
I am trying to finish that problem if you have any suggestion please give me to solve the problem
I once again Say Thankyou for your timely help.
Thankyou VeryMuch
Sang...Leave a comment:
-
Thankyou very much I solved that problem. but i have another error.
That is DB error please see the code and give the suggesstion to solve it
...Code:public void countKeyword() { try{ String sql1 = "select JobRefNo,ifnull(Keywords,' ') from JOB_ORDER where Status<>'Expired' and ValidUpto >= sysdate()"; Statement stm1 = dbConnection.createStatement(); ResultSet rs1 = null;Leave a comment:
-
My problem is
...Code:public void countKeyword() { try{ String sql1 = "select JobRefNo,ifnull(Keywords,' ') from JOB_ORDER where Status<>'Expired' and ValidUpto >= sysdate()"; Statement stm1 = dbConnection.createStatement(); ResultSet rs1 = null; rs1 = stm1.executeQuery(sql1); while(rs1.next()) { String sql2 = "select UserId from JOB_APPLICATIONLeave a comment:
-
The resume and keywords are taken from different table.
The program is check whether the keywords are in the resume, if the keywords are present Count the each keywords.
In the out put it will be return
Keyword How many times present
for example the keyword is java and it present 3 times
The output is
java ===>3 times
Thankyou
Sang...Leave a comment:
No activity results to display
Leave a comment: