java getParameter problem in IE

[hugo]

Hi

I have come across a problem with is very strange:

I have a jsp file where I obtain user input values from a form, then do
a query to my database, see if any of the fields match. This is the
query string:

String project_results_query = "SELECT project_ID,project_name FROM
projects WHERE (project_ID LIKE '%"+project_id+"%' AND project_name LIKE
'%"+project_name+"%' AND project_status LIKE '%"+project_status+"%' AND
project_start_date LIKE '%"+project_start_date+"%') ORDER BY project_name";

If I do this query using Netscape, I get something returned when I
select a value. For example, if the database contains, for project_name,
the value "Codelco", and I select "Codelco" from my page where I have
search forms, a match is found between my input parameter and the
database value and details of project "Codelco" are returned.

However, if I do the same with Internet Explorer, nothing is returned,
although the two values (the input from my form and what is in the
database) seem to match exactly.

If I put the value "Codelco" in manually on the page where the query is
made, it works under IE (database returns result). Hence it must have
something to do with the way IE responds to a java getParameter request
- what is returned must be in some way different than what is returned
by Netscape and also different to the same string put in the page
manually. Is there a linebreak or any other character added on when a
java getParameter request is made using IE?

This is a real impediment to having my program utilised by users, so any
help anyone can give regarding this me will be greatly appreciated.

Thanks

Hugo

[name]

Microsoft is not very 'java' friendly.
When they discontinued <script archive="*.jar"></script>
with IE5 on Wi32, everyone was deprived of compressed javascript
to be called from a webpage.

Thinking along those lines, whatever jsp stands for
(javascript pages, javapages, just stay put, or job service provider),

I have the straight feeling your project lacks a few fundamentals.

I can tell you without blinking that I would not run Sun's, MS's
or your compiled Java code locally, open source or not. {{period}}

"hugo" <hu...@geoinformex.com> wrote in message
news:3DF97DC7...@geoinformex.com...