[Beds] JSP Help

[Lee Larcombe]

The only thing which looks like a problem to me, is when the whichsex
variable is substituted in your select statement.

The statement contains single quotes (') around the variable insertion point
which I don't think it should: ie (...upper + "', '" + whichsex + "', order
by...). 

The quotes are corretly in the variable string which will be substituted in:
ie (and sex = 'F')

I don't know much about java/jsp mind you.

Lee


On 2/3/06 14:36, "Stephen Elliott" <techweb at ntlworld.com> wrote:

> Hi,
> 
> I am having some problems with some JSP code I am modifying.
> 
> I have a MySQL database with the following fields:
> 
> firstname
> lastname
> address
> telephone
> birthday
> sex
> email
> 
> Basically my JSP program is able to add, modify and delete these records.
> However, I have tried to add some sorting options based on sex, birthdays
> and order  of first and last name. I have had a go at this and am having no
> success. I believe the problem lies with one of my IF statements and SQL
> syntax and have commented them in the code.
> 
> I have attached my code was wondering if there were any gurus out there who
> could have a quick look through my code and point me in the right direction.
> 
> Many Thanks
> Stephen Elliott
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.375 / Virus Database: 268.1.1/272 - Release Date: 01/03/2006
> _______________________________________________
> Beds mailing list
> Beds at mailman.lug.org.uk
> http://mailman.lug.org.uk/mailman/listinfo/beds