Member Avatar for coroll

Hi, i get the following error

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.

this is my code

import java.sql.*; public class DetOrderNum{ public static void main(String[] args){ Connection con=null; ResultSet rs=null; Statement stmt=null; int pkey=0; String itemn="jin"; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:MY-PIZZA","",""); String q="select order_num from Order where recev_fname='"+itemn+"'" stmt=con.createStatement(); // System.out.println("stme ok"); rs=stmt.executeQuery(q); //System.out.println("q exe"); if(rs !=null){ rs.next(); pkey=rs.getInt(1); } }catch(SQLException e){ System.out.println(e); }catch(ClassNotFoundException ee){ }finally{ try{ if(rs !=null){ rs.close(); rs=null; } if(stmt !=null){ stmt.close(); stmt=null; } if(con !=null){ con.close(); con=null; } }catch(SQLException e){} } System.out.println(pkey); } }

oder_num is auto increment field.fname is a text type.

can anyone tell me what is the mistake?

  • 3 Contributors
  • 2 Replies
  • 316 Views
  • 19 Hours Discussion Span
  • Latest Post Latest Post by javaAddict
Member Avatar for NormR1

Have you tried asking this on a database forum?

Member Avatar for javaAddict

Try to print the query, and then take it the way it is and run to an sql editor:

String q="select order_num from Order where recev_fname='"+itemn+"'"; System.out.println("Qeury: "+q);
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.