Hi all, I would really appreciate some assistance

I have a simple table with the fields SectionOne, SectionTwo, SectionThree

I am generating a jump menu with the values from SectionOne and passing the value to create a recordset to find matches for SectionTwo

My problem is when the value of SectionOne contains an apostrophe eg Children's Services no results are returned.....why is this? Any help would be really appreciated

Thanks

Ooops...forgot to add, I'm using SQL 2005 database, ASP VBScript pages

Hi Peter,

The following article discusses this issue:
www.aspisfun.com/sql/basics/apostrophe.html

I hope this helps you.

Regards,

Georgi Kralev

Homepage: gdkralev.googlepages.com