File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes quotation marks problem of access db,SOS! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "quotation marks problem of access db,SOS! " Watch "quotation marks problem of access db,SOS! " New topic
Author

quotation marks problem of access db,SOS!

Tom Keaton
Greenhorn

Joined: Feb 24, 2004
Posts: 17
I use java to connect access db,the code appear like this:
It is no problem,but
is wrong,though the sql sentence can correctly execute by copying to access
[ March 25, 2004: Message edited by: tvbas ]

undefined
eammon bannon
Ranch Hand

Joined: Mar 16, 2004
Posts: 140
Not sure I understand your question - what exactly are you worried about?
Tom Keaton
Greenhorn

Joined: Feb 24, 2004
Posts: 17

it wrong,why?
eammon bannon
Ranch Hand

Joined: Mar 16, 2004
Posts: 140

it wrong,why?

C'mon tvbas - you're not giving us much to work with here. By "wrong" do you mean:
- your code doesn't compile?
- you get a SQLException when you run it?
- you get some other kind of Exception?
- you get unexpected results?
- you get no results?
- you are worried it might be incorrect SQL?
- you are worried it could be better designed?
[ March 25, 2004: Message edited by: eammon bannon ]
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61415
    
  67

"tvbas",
We're pleased to have you here with us in the JSP forum, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
Thanks!
bear
Forum Bartender


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Tom Keaton
Greenhorn

Joined: Feb 24, 2004
Posts: 17
this is my code.
java.sql.SQLException
Tom Keaton
Greenhorn

Joined: Feb 24, 2004
Posts: 17
nobody can help me?
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61415
    
  67

"Tom K', thanks for changing your display name, but please read my response and the naming policy as your newly chosen name is still not valid.
bear
JDBC Forum Bartender
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61415
    
  67


nobody can help me?

Did you read eammon's reply? We can't help you unless you help yourself by answering requests for more information about your problem.
Tom Keaton
Greenhorn

Joined: Feb 24, 2004
Posts: 17
Originally posted by tvbas:
this is my code.
java.sql.SQLException

I have putted my code,please click "this",it is hyperlink of my code.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: quotation marks problem of access db,SOS!