[Beds] JSP Help

[Stephen Elliott]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jdbc4.jsp
Type: application/octet-stream
Size: 5761 bytes
Desc: not available
Url : http://mailman.lug.org.uk/pipermail/beds/attachments/20060302/cf4cf2d0/jdbc4.obj