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 have to use a literal SQL statement, and the various DBMS's use different escape syntax. However, in Java, you can just use a prepared statement String sql = "INSERT INTO files (filepath) 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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > > sorry, I should say add 3 extra '\' and not just one in my previous > email, since if I add 3 more and it becomes: > "INSERT INTO files (filepath) VALUES ('c:\\\\Repository\\\\Pack\\\\')" > which represents the following string in Java: > "INSERT INTO files (filepath) VALUES ('c:\\Repository\\Pack\\')" > (because in Java '\' is also an escape character) > > So, in MySQL 'c:\Repository\Pack\' will be inserted, while in MS SQL and > Oracle 'c:\\Repository\\Pack\\' will be inserted and that's the problem > for me... > > -----Original 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 '\' 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:\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 PROTECTED]> > > > > Hi all, > > > > I want to insert the string 'c:\Repository\Pack\' into a mysql table > > using java and I did it as follows: > > > > sql =3D3D "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 above sql statement. But, the problem is MS SQL and > > Oracle do not treat '\' as an escape character in sql statements, and > I > > want to keep my Java program as database-independent as possible. (and > I > > don't want the whole string 'c:\\Repository\\Pack\\' to be stored in > the > > database when I use MS SQL server or Oracle) > > > > Any suggestion to my problem will be greatly appreciated. > > > > Thanks, > > Kathy > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
