I try make select record from a ADABSE Tables with one ODBC with some script JSP (java)
con=DriverManager.getConnection("jdbc:odbc:YourId;APPLICATION=YourFrame; Uid=YourUser;"); Statement st = con.createStatement(); sql = "SELECT "+champs+" as col1 FROM YourFrame.dbo."+DDM+" WHERE "+champs+" LIKE '"+requete+"%' OR "+champs+" LIKE '%"+requete+"%' "; rs = st.executeQuery(sql);
and the code is running
But I want have a similar mySQL instruction as
SELECT champs FROM YourFrame.dbo.DDM WHERE blabla… LIMIT 0, 5
How have a similar instruction with the sql of ConnX ?