CoSIS1

Hi everyone; I’ve written the following for some purpose : [CODE] <% Vector v1,v2; String sql; String sqlvsp; sqlvsp= "select distinct(question_text) from question where type = 'UStudent' "; Vector vc=database.jdbcOneRowQuery(sqlvsp); for(int n=0;n<vc.size();n++){ %> <table border="0" width="100%"> <tr> <td colspan="6"><font size="2"><b><% out.print(n+1); %>)<% out.print(vc.get(n)); %></b></font> </td> </tr> <tr> <td></td> <td align="center" …

[CODE] SELECT (MONTH(CURDATE-MONTH(issudate)) AS ' Months' FROM table Union SELECT (DAY(CURDATE-MONTH(issudate)) AS 'Days' FROM table Union SELECT (YEAR(CURDATE-MONTH(issudate)) AS 'Year' FROM table [/CODE] it may help

indeed , am not using MVC structure but i have done what you want before, you can take a look [CODE] <select name="select" size="1" > <% String sql = "select *from table "; Vector v1=database.jdbcMultipleRowQuery(sql); for(int i=0;i<v1.size();i++){ Vector v2 = (Vector)v1.elementAt(i); for(int j=0;j<v2.size();j++){ out.print("<option>"+v2.get(0)+"</ption>"); } } %> [/CODE] it may …

you need to update the primary key when you delete the record example [CODE] delete from number1 where name in ('Nico ','Joy') [/CODE] then [CODE] UPDATE number1 SET number= number- 1 where name ='Marko'; UPDATE number1 SET number= number- 1 where name ='Peter '; UPDATE number1 SET number= number- 2 …

take a look on the following tutorial [URL="http://roseindia.net/jsp/online-quiz-application-jsp.shtml"]http://roseindia.net/jsp/online-quiz-application-jsp.shtml[/URL]

when you post the error , please post your code

ajax take a look [URL="http://www.daniweb.com/forums/thread197237.html"]http://www.daniweb.com/forums/thread197237.html[/URL]

you do not really need to use jsp to create tabs you can use javascript [URL="http://www.roseindia.net/html/Tab.shtml"]http://www.roseindia.net/html/Tab.shtml[/URL] or ajax [URL="http://www.roseindia.net/struts/struts2/struts2uitags/tabbedpanel.shtml"]http://www.roseindia.net/struts/struts2/struts2uitags/tabbedpanel.shtml[/URL] they are more easier

Hi everyone ; I have read The JFreeChart Class Library Version 1.0.13 Installation Guide and I follow the instruction there but I got some errors while the Installation; allow me to show the steps that I have followed and the errors I got : 1. Download jfreechart-1.0.13.zip and jcommon-1.0.16 files …

Hi everybody, I am going to develop a web application by using jsp, in this application when I retrieve multiple rows from table into form as following : [code=jsp]<%Vector v1,v2; jmm.Database database = new jmm.Database(pageContext.getServletContext().getRealPath("/WEB-INF/config.txt")); database.jdbcConnect(); String sql; sql = "select question_text from tableA where type = 'Student'' "; v1=database.jdbcMultipleRowQuery(sql); …

I want to find the percentage for each question’s answer and how many user response to that question The answer either yes , no, escaped (null) Table structure :[CODE] CREATE TABLE useranswers ( userAnswerID int(10) unsigned NOT NULL auto_increment, answer varchar(45) default NULL, userType varchar(45) default NULL, ques_tesxt varchar(300) default …

Hi everyone; I have table contains question and answer columns , the answer either yes or no , I want to count the answer yes and answer no then compare the two results and if the count(answer) yes is greater than count (answer) no print yes else print no I …

double check on database schema and tables and columns are they exactly what you have in the code?

the best answer is ajax and actually you do not to learn ajax just copy the code i will gave and follow the guidlines copy and paste the attached file into your project folder : 1- copy and paste the attached file into your project folder 2- copy the following …