Re: Confusing Problem with SQL Query in Tomcat

2001-03-27 Thread Hunter Hillegas
Title: Re: Confusing Problem with SQL Query in Tomcat Using rtrim() had no effect... This is starting to bum me out... Hunter From: "Cox, Charlie" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 27 Mar 2001 08:50:24 -0500 To: "'[EMAIL PROTECTED]'&q

Re: Confusing Problem with SQL Query in Tomcat

2001-03-27 Thread Hunter Hillegas
ject: Re: Confusing Problem with SQL Query in Tomcat > > On Mon, 26 Mar 2001, Hunter Hillegas wrote: >>> >>>> pst.clearParameters(); >>> >>> >>> No need for clearParameters(). The setString will override any old >>> para

RE: Confusing Problem with SQL Query in Tomcat

2001-03-27 Thread Cox, Charlie
Title: RE: Confusing Problem with SQL Query in Tomcat Some data types(char) are fixed length on some databases. I'm not familiar with postgres, but you may want to try 'where upper(rtrim(name)) = upper(?)' to trim any trailing spaces. I have run into cases where in a char(10)

Re: Confusing Problem with SQL Query in Tomcat

2001-03-27 Thread Joe Laffey
On Mon, 26 Mar 2001, Hunter Hillegas wrote: > I just tried this again, replacing the ? with a test value and it works so > the problem is the pst.setString() call. > > I know the String I'm passing to setString is valid because I can print it > to the screen just find... > > Is preparedStatement.

Re: Confusing Problem with SQL Query in Tomcat

2001-03-26 Thread Hunter Hillegas
<[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Tue, 27 Mar 2001 00:07:44 -0600 (CST) > To: Tomcat User List <[EMAIL PROTECTED]> > Subject: Re: Confusing Problem with SQL Query in Tomcat > > You tried pasting a plain SELECT string with no "?"s in the

Re: Confusing Problem with SQL Query in Tomcat

2001-03-26 Thread Hunter Hillegas
> From: Joe Laffey <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Tue, 27 Mar 2001 00:07:44 -0600 (CST) > To: Tomcat User List <[EMAIL PROTECTED]> > Subject: Re: Confusing Problem with SQL Query in Tomcat > >> Can't hurt though, can it? >

Re: Confusing Problem with SQL Query in Tomcat

2001-03-26 Thread Joe Laffey
On Mon, 26 Mar 2001, Hunter Hillegas wrote: > > > >> pst.clearParameters(); > > > > > > No need for clearParameters(). The setString will override any old > > parameters (if their were any). > > Can't hurt though, can it? Don't think so, but why make extra method calls ;-) > > > > My

Re: Confusing Problem with SQL Query in Tomcat

2001-03-26 Thread Hunter Hillegas
> From: Joe Laffey <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Mon, 26 Mar 2001 23:38:48 -0600 (CST) > To: Tomcat User List <[EMAIL PROTECTED]> > Cc: Hunter Hillegas <[EMAIL PROTECTED]> > Subject: Re: Confusing Problem with SQL Q

Re: Confusing Problem with SQL Query in Tomcat

2001-03-26 Thread Joe Laffey
On Mon, 26 Mar 2001, Hunter Hillegas wrote: > I have a strange problem with my Servlet app running in Tomcat 3.2.1 on > Linux. > > The method posted below takes a String and uses it in conjunction with a > PreparedStatement to create a query. I've added debugging code to the method > to print out

Confusing Problem with SQL Query in Tomcat

2001-03-26 Thread Hunter Hillegas
I have a strange problem with my Servlet app running in Tomcat 3.2.1 on Linux. The method posted below takes a String and uses it in conjunction with a PreparedStatement to create a query. I've added debugging code to the method to print output to the screen to help me but I can't figure it out.