thanks a lot, it helps
Kathy
-Original Message-
From: Bill Easton [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 9:44 AM
To: [EMAIL PROTECTED]
Cc: Kathy Sung
Subject: RE: About escape character '\'
Sorry, I guess I answered too quickly. You have a problem, if you h
th) VALUES (?)");
PreparedStatement ps = con.prepareStatement(sql);
ps.setString(1, "c:\\Repository\\Pack\\");
ps.executeUpdate();
Hope that works for you.
> Subject: RE: About escape character '\'
> Date: Thu, 11 Apr 2002 13:54:46 -0400
> From: "Kathy Sung" <
ginal Message-
From: Bill Easton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 11, 2002 7:27 AM
To: [EMAIL PROTECTED]
Cc: Kathy Sung
Subject: Re: About escape character '\'
Kathy,
You shouldn't have a problem here--it's Java, not MySQL, that requires
the
doubled '
Kathy,
You shouldn't have a problem here--it's Java, not MySQL, that requires the
doubled '\' in a string literal.
In Java, the string literal:
"INSERT INTO files (filepath) VALUES ('c:\\Repository\\Pack\\' )"
represents the string whose content is
INSERT INTO files (filepath) VALUES ('c:\Re