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
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) field,'ABC
Padding the ? with spaces did nothing... Still returns false in that
instance...
Very strange...
Hunter
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
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]' [EMAIL PROTECTED]
Subject: RE
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 output
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 Query in Tomcat
pst = con.prepareStatement("S
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 guess is that it
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?
Don't think so, but why make extra method calls