tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Surya Saraff <surya_sar...@yahoo.com>
Subject Column names with spaces in btwn.
Date Tue, 06 Nov 2001 23:03:16 GMT
Hi,
I tried executing:
try{
  PreparedStatement updaterequest;
  String s = new String( "insert into
Request(Priority, Detailed Description, Title)
values('High','Krypton','title' );");
 updaterequest = con.prepareStatement( s );
 updaterequest.execute();
		  }
		
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"

Regards,
Surya


__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com

--
To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>


Mime
View raw message