i am getting multiple values in listbox

i am getting multiple values in listbox

hi sir, i am using msaccess 2007.my query is look like this. select distinct a.name,b.fee from table1 a,table2 b where a.stuno=b.stuno and b.recdate in(select max(recdate) from table group by stuname) order by a.name

    in a subquery multiple recdates i am getting its working fine, but in main query also i am getting multiple name but i want only distinct names

pls help me

View Answers









Related Tutorials/Questions & Answers:
i am getting multiple values in listbox
i am getting multiple values in listbox   hi sir, i am using... table group by stuname) order by a.name in a subquery multiple recdates i am getting its working fine, but in main query also i am getting multiple name
how to store multiple values from drop down in database where i am using java struts 1.3
how to store multiple values from drop down in database where i am using java struts 1.3  hii, i am coding a form where i need a keyskills attribute... is displaying.. i need code in java so that it takes multiple values
Advertisements
Values to listbox
Values to listbox  I have two textboxes by the name street and city.I have an add button and a name listbox. When I enter street and city and press the add button ,all the names of the people residing there are listed in listbox
I am getting this exception
I am getting this exception   Exception in thread "main" org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java
:( I am not getting Problem (RMI)
I am not getting Problem (RMI)  When i am excuting RMI EXAMPLE 3,2 I am getting error daying nested exception and Connect Exception  
i am Getting Some errors in Struts - Struts
i am Getting Some errors in Struts   I am Learning Struts Basics,I am Trying examples do in this Site Examples.i am getting lot of errors.Please Help me
I am getting error.How can i get details
I am getting error.How can i get details  Exception in thread "main" java.sql.SQLException: Listener refused the connecti n with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect
i am getting an error in adding a menu item to a menu.
i am getting an error in adding a menu item to a menu.   i am not able to execute the menu program. i am getting an error at menu.add(menuitem); it says add method is undefined for type menu. but as far as i know that is only way
I am getting Undefined in Text Box Very Urgent - JSP-Servlet
I am getting Undefined in Text Box Very Urgent  Respected Sir/Madam, I am R.Ragavendran.. Thanks for your superb reply. I got the coding. But I find... and clicking select button, The pop up window gets closes. But, i am getting
i am getting the problem when i am downloading the pdf file from oracle 10g database - Struts
i am getting the problem when i am downloading the pdf file from oracle 10g database  if i created the pdf file from pdf machine,it is storing... but it is not downloading .Please help to me.i am getting the below error when downloading
select tag multiple values
select tag multiple values   I want to insert multiple values in database which i have selected from select tag
using spring rmi+maven but i am getting this exception
using spring rmi+maven but i am getting this exception  D:\Nexustool\integrationengine\trunk>mvn exec:java [INFO] Scanning for projects... [INFO] [INFO
Why the null values are stored in Database when I am sending proper values?
Why the null values are stored in Database when I am sending proper values?  I am making a project in which I am sending the image into a folder &... I am also sending the name, Rate, Dimension to the Database through the text
I want to update the multiple values of database depending on checkbox..? Please help me out..
I want to update the multiple values of database depending on checkbox..? Please help me out..   Hi .. I want to Update the multiple values of database using checkboxes and want to set the session for selected checkboxes
How to pass multiple values from a servlet to JSP?
How to pass multiple values from a servlet to JSP?  hi, I want to pass multiple values form a servlet to JSP. Hw do i do that? I am able to send one value at a time without any prb, but I am unable to carry multiple (from two
getting values from dropdown list
getting values from dropdown list  I am having a dropdown list which has hardcoded values ( we need it hardcoded only and will not be populated from... to the action. My action is getting called however, i am not sure how to pass
multiple select values
multiple select values   can you provide an example for multiple select values for html:select tag
autocomplete(): Spring mvc with jquery: I am not getting correct value in the text filed. Please help me
autocomplete(): Spring mvc with jquery: I am not getting correct value... related birds whenever we give input in the text field. But i am getting the wrong... bird names , but whenever i selected any bird in the text filed the am getting
getting values from database - JSP-Servlet
getting values from database  I tried the following code abc.html aaa.jsp I am not getting exceptions now. But I am not getting output also. Plz help.   Hi Friend, Run your
retrieve multiple attribute values
XML retrieve multiple attribute values  Hello All Am a beginner. Would like some help with this. The following is part of my XML file: <...; What I would like is to retrieve both the attribute values of process
retrieve multiple attribute values
retrieve multiple attribute values  Hello All Am a beginner. Would...; <rdfs:label></rdfs:label> </process:Output> What I would like is to retrieve both the attribute values of process:Output during execution
retrieve multiple attribute values
retrieve multiple attribute values  Hello All Am a beginner. Would...; <rdfs:label></rdfs:label> </process:Output> What I would like is to retrieve both the attribute values of process:Output during execution
How to carry multiple values from a Servlet to a JSP?
How to carry multiple values from a Servlet to a JSP?  By using the below code I am able to carry the username to a JSP (single value). ----response.sendRedirect("index.jsp?uname="+username);---- But I want multiple values
I am getting error org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'IS_AUTHENTICATED_ANONYMOUSLY' is defined - Spring
I am getting error org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'IS_AUTHENTICATED_ANONYMOUSLY' is defined  Hello, I am getting error
when sending the mail from java I am getting the below error - JavaMail
when sending the mail from java I am getting the below error   when sending the mail from java I am getting the below error : Exception in thread "main" java.lang.NoClassDefFoundError: javax.mail.internet.MimeMessage
Getting image pixel values
Getting image pixel values  how to get image pixels values on mouse... JPanel getLabels() { labels = new JLabel[2]; for(int i = 0; i < labels.length; i++) { labels[i] = new JLabel
Retriving multiple values of checkboxes in struts
Retriving multiple values of checkboxes in struts  how to retrive multiple values of checkboxes of jsp in action class   JSP Retrieve checkbox values 1)checkbox.jsp: <html> <body> <form method="post
calling a javascript function by passing multiple values from applet in web application
calling a javascript function by passing multiple values from applet in web application  Hi all, I have a requirement like this, I have to call a javascript function from JApplet by passing 3 values. I am new to Applets
Regarding method returns multiple values
Regarding method returns multiple values  Hi, 1)I have a requirement like,1 method returns multiple values.how to do that one. 2)can i use method, for example like getFile()[] in this way or not. plzzzzzzzzzzzzzzzzzz provide
Java Method Return Multiple Values
statement returns the multiple values. In this example I have created a class...Java Method Return Multiple Values In this section we will learn about how a method can return multiple values in Java. This example explains you how
How to return multiple values from a method - Java Beginners
How to return multiple values from a method  I came the following method "How do I return multiple values from a method?" posted elsewhere. The problem is that I wanted to tested the method posted, but I am getting the incorrect
How to return multiple values from a method - Java Beginners
How to return multiple values from a method  I came the following method "How do I return multiple values from a method?" posted elsewhere. The problem is that I wanted to tested the method posted, but I am getting the incorrect
this is my file upload page, here i am not getting tags input field value to my servlet,please suggest a solution?
this is my file upload page, here i am not getting tags input field value to my servlet,please suggest a solution?  <html> <head> <script type="text/javascript"> var counter =1; function
retrieve multiple columns values from multiple csv files in java
retrieve multiple columns values from multiple csv files in java  Suppose there is folder in C:\fileupload which contains these two csv files...)///// here VendorID is corresponding to file1.csv i want to retrive data from
getting dropdown values using apache commons in servlet
getting dropdown values using apache commons in servlet  i want to get dropdown values in my program in order to merge the string to my file path so...); } i tried to debug and i am getting the wright file path but while proceeding
i want to update values
i want to update values  in my form i have 2 submit buttons one... database and it need to insert automatically in to disabled text boxs and once i press the edit button all text boxs need to enable so that i can edit my details
Page is not getting loaded when I refresh the webpage???
Page is not getting loaded when I refresh the webpage???  **I am... function in JSP. It will get all details of image section from database. *I am... when I refresh the page.* Note: Header section is getting loaded always Could
Option onclick am not getting the value ..
Option onclick am not getting the value ..    function get_val( tot_val ) { document.getElementById('TextBox1').value = tot_val; } <tr> <td><textarea id="TextBox1" name=textarea1 readonly="readonly
@SessionAttributes multiple values
@SessionAttributes multiple values In this section we will see how you can use @sessionattributes to set multiple session values to it. While developing... for multiple values are: @SessionAttributes({"formdata","
getting error while inserting values in database
getting error while inserting values in database  AddUser.java... followin error i don't know why "ORA-00947: not enough values". kindly chk... into LTCINFO.PERSONS values ('"+LASTNAME+"','"+FIRSTNAME+"','"+ADDRESS+"','"+CITY
ModuleNotFoundError: No module named 'will-i-am'
ModuleNotFoundError: No module named 'will-i-am'  Hi, My Python... 'will-i-am' How to remove the ModuleNotFoundError: No module named 'will-i... have to install padas library. You can install will-i-am python with following
i want to display where i entered values to same page
i want to display where i entered values to same page  hi friends !! i have a values from jsp page .and i want to store that values into DB at the same time i want to show immediatlly on same jsp page with tabular format
i want to display where i entered values to same page
i want to display where i entered values to same page  hi friends !! i have a values from jsp page .and i want to store that values into DB at the same time i want to show immediatlly on same jsp page with tabular format
retaining the selected values in html:select multiple="true" in jsp + collection + struts
retaining the selected values in html:select multiple="true" in jsp + collection + struts  Hi, I have a multiple selection box in one of the jsp..., the selected value in the multiple selection box is not retained. I need your
I am new to ML/AI. Where do I start learning?
I am new to ML/AI. Where do I start learning?  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: I am new to ML/AI. Where do I start learning? Try to provide me good
Facing Problem to insert Multiple Array values in database - JSP-Servlet
Facing Problem to insert Multiple Array values in database  Hai... --------------------------------------- i want to insert the data like the above... not insert to next record. i need the solution urgently pl help me thanks
getting int values from form and insert it in data base in jsp
getting int values from form and insert it in data base in jsp  how can i get form input such as id convert it to int insert it into database  ... = request.getParameter("formfieldname"); Then convert it into Integer variable: int i
Call an array from multiple functions
Call an array from multiple functions  I am having two methods in this method i am getting array values from another class. i create same array name for accessing the method values(array) but it will access only one method values
Display JSP selected listbox and checkbox in xml-please help me
, I have three Listbox on my jsp page. I want to do following:ADS_TO_REPLACE_1... selected listbox as well as selected multiple checked checkboxes. Please help in this how to do this.....I am new to java & jsp I need your help.ADS
I cant get values in MS acces in tables
I cant get values in MS acces in tables   I got problem in sending values from servlet . * i am using ms acces * i cant display my values but der... sta = con.createStatement(); int i=sta.executeUpdate("insert

Ads