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 '
INSERT INTO files (filepath) VALUES ('c:\Repository\Pack\' )
so what gets inserted is, in fact,
c:\Repository\Pack\
> Subject: About escape character '\'
> Date: Wed, 10 Apr 2002 19:44:21 -0400
> From: "Kathy Sung" <[EMAIL PROTECTED]>
> To: <[EMAIL
Hi all,
I want to insert the string 'c:\Repository\Pack\' into a mysql table
using java and I did it as follows:
sql = "INSERT INTO files (filepath) VALUES ('c:\Repository\Pack\' )";
insertStmt.execute(sql);
I got an error and I know I should add an extra '\' to escape each of
the '\' in the ab
