Hello Witold, Are you checking the users response for the percent and changing the SQL to use the WHERE ColumnName LIKE 'parameter' syntax in the query? Our database maintenance application does this to allow the user to select multiple records for update and it works very well.
Regards, Gary ----- Original Message ----- From: "Witold Iwaniec" <[EMAIL PROTECTED]> To: "JDJList" <[EMAIL PROTECTED]> Sent: Tuesday, May 28, 2002 11:09 AM Subject: [jdjlist] Servlet Request parameters and % > Hi all > > In my servlet application I need to allow users to use wildcards in > queries. The Oracle wildcard character is the "%" so e.g. in the user > could type street name as: "Uni%" instead of "University" > But if I use the "%", the URL parameters get messed up. For example > if I have on my page textboxes STREET_NO and STREET_NAME and > fill: > STREET_NO: 2% > STREET_NAME: UNI% > > in the request URL I don't see STRETE_NO and STREET_NAME > appears as: 2 TREET_NAME with unprintable character. > Sometimes the value is changed. > > I believe the "%" has special use in servlet request/response. I guess I > could change the wildcard to a "*" or something else. But wonder if > there is a way to handle the % properly > > Thanks > > Witold > > ================================== > Witold Iwaniec > Sr Software Developer > NovaLIS Technologies > [EMAIL PROTECTED] > http://www.novalistech.com > > > To change your membership options, refer to: > http://www.sys-con.com/java/list.cfm > > To change your membership options, refer to: http://www.sys-con.com/java/list.cfm
