Retrieve set of records starting with a alphabet

[vasagam]

hi..friends..
I am currently developing a project in jsp using access as the back end
I need to find the maximum value of the id from the list of names starting with a particular character. i get the character from the previous page using request.getParameter() method..when i execute it i get an sql exception sayin too few parameters.. My code goes here..

 
String select_query1="";
v=request.getParameter("val");
try
    {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con1=DriverManager.getConnection("jdbc:odbc:name","","");
    Statement st1=con1.createStatement();
    select_query1="select Max(ID)as di from indianbaby_boysname where name Like "+'"'+v+'*'+'"';
    out.println(select_query1);
    ResultSet rs1=st1.executeQuery(select_query1);
    while(rs1.next())
    {
        cntid=rs1.getInt("di");
    }
    rs1.close();
    con1.close();
    }catch(Exception e)
    {
        out.println(e);
    }
}
 
 

[Ferris]

hi

you miss a space between "Max(ID)" and "as" in line 8 , and I think you should use % replace * to pattern multi-chars.

select_query1="select Max(ID) as di from indianbaby_boysname where name Like "+'"'+v+'%'+'"';

and what's the output in line 9?

[acoder]

Note that JavaScript and JSP are two completely different languages. This is a JSP question and JSP questions belong to the Java forum where I've moved this thread to.

Moderator.