my dog learned polymorphism*
The moose likes JDBC and the fly likes using Strings to query database?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "using Strings to query database??" Watch "using Strings to query database??" New topic

using Strings to query database??

Andres Gonzalez
Ranch Hand

Joined: Nov 27, 2001
Posts: 1561
I have a simple question. Do I have to trim() the strings before using it in a select statement?
for example:
String thisString = request.getParameter("some");
thisString = thisString.trim();
or is it irrelevant??

I'm not going to be a Rock Star. I'm going to be a LEGEND! --Freddie Mercury
Graham Thorpe
Ranch Hand

Joined: Mar 25, 2002
Posts: 265
Yes we can do trim function before select
statement.This is very useful code also why because of not all database are not supported to trim function proprty.
Consider Paul's rocket mass heater.
subject: using Strings to query database??
Similar Threads
Search A String and....
Report Formatting
Empty Array as opposed to Null Array
Question about Static and nonstatic class methods