tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Surya Saraff <>
Subject Column names with spaces in btwn.
Date Tue, 06 Nov 2001 23:03:16 GMT
I tried executing:
  PreparedStatement updaterequest;
  String s = new String( "insert into
Request(Priority, Detailed Description, Title)
values('High','Krypton','title' );");
 updaterequest = con.prepareStatement( s );
It gives me "java.sql.SQLException: [Microsoft][ODBC
Microsoft Access Driver] Syntax error in INSERT INTO
statement. "

But, when I have "Description" instead of "Detailed
Description" it works fine. (I have both those fields
in my database)

Does anyone have any idea how I can handle the extra
space btwn "Detailed" and "Description"


Do You Yahoo!?
Find a job, post your resume.

To unsubscribe:   <>
For additional commands: <>
Troubles with the list: <>

View raw message