PAge crashes on entering ' and REPLACE

[SABhatti]

I have an asp page wichh submit two fields, title and contents. Now if user types single code ('), or semi-colon (;) and replace (the word REPLACE) then on submitting the form, page crashes. Any help please.. Note: it is working fine on development server (win 2003) but crashing on production server (win 2000) -----

[Guffa]

Please don't cross post. I replied in the web development forum.

--- "Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things." -- Douglas Adams

[Bino B]

since single quote is a reserved character in SQL, u need to replcae it with some other character before inserting into the DB.u can easily use a simple 'replace' method. like replace("'","~")

Regards Sean http://www.codepal.co.nr

[SABhatti]

Thanks Sean. But this is not the problem, please see this for complete details.

-----