Re: insert question mark into character field (JDBC)

I didn't check what you are trying to do, but the most obvious way is to prepare the statement like: pstmt = conn.prepareStatement("insert into tab1 values (?, ?)"); and then just call: pstmt.setString(1, "chacacters"); pstmt.setString(2, "more characters ?"); Best Regards, Octav On Mon, Aug 16, 1999 at 10:34:24AM -0400, Charly Bauer wrote: > > Can someone help w/ the syntax for inserting a question mark into a > character field, through JDBC? > > I'm attempting to do something like this: > > pstmt = conn.prepareStatement("insert into tab1 values ('characters', 'more > characters ?' )"); > > > According to the JDBC Driver Programmer's Guide, the escape character syntax > is {escape 'escape-char'} though I'm unable to use this successfully. > > Thanks. > > Charly Bauer > Columbus, OH > charly@ohiolink.edu > -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com