I have a small set of interactive pages to maintain. When the user enters an apostrophe in the year he gets a HTTP 404 with reference to SQL errors about conversion of text to numeric. I want the user to get rturned to the input page with a message about the year. But I cannot trap the exception. I have exception/others in the procedure where the year gets input and in that where writing to the database occurs, but no exception is trapped by this. Any clues you can give me?
