Hmm my SQL Query crashes!!!!!

<i><b>Originally posted by : Sheraz (alphajobbeta@hotmail.com)</b></i><br />History:<br /><br />Working with forms and SQL dymaic rookie query .....<br /><br />Now if I type a >>> ' <<<<character in my forms my dynamic query crashes ....<br /><br />How can I make my queys "Super Query " so it just doesn't crashes with inclusion of a useless character like >>> ' <<<<<<<<br /><br />Actually its useful but hey it cuzing a bug in my script hehe ...<br /><br /><br /><br /><br /><br /><br /><br />

<i><b>Originally posted by : ssteve</b></i><br />use the replace statement in your in-line sql statement that gets passed to the database.<br /><br />replace(mystring, "'", "") will replace it with nothing.<br /><br /><br />------------<br />Sheraz at 6/29/2001 2:59:03 PM<br /><br />History:<br /><br />Working with forms and SQL dymaic rookie query .....<br /><br />Now if I type a >>> ' <<<<character in my forms my dynamic query crashes ....<br /><br />How can I make my queys "Super Query " so it just doesn't crashes with inclusion of a useless character like >>> ' <<<<<<<<br /><br />Actually its useful but hey it cuzing a bug in my script hehe ...<br /><br /><br /><br /><br /><br /><br /><br />

<i><b>Originally posted by : Sheeraz</b></i><br /><br />Thanks sSteve<br /><br />------------<br />ssteve at 6/29/2001 9:51:01 PM<br /><br />use the replace statement in your in-line sql statement that gets passed to the database.<br /><br />replace(mystring, "'", "") will replace it with nothing.<br /><br /><br />------------<br />Sheraz at 6/29/2001 2:59:03 PM<br /><br />History:<br /><br />Working with forms and SQL dymaic rookie query .....<br /><br />Now if I type a >>> ' <<<<character in my forms my dynamic query crashes ....<br /><br />How can I make my queys "Super Query " so it just doesn't crashes with inclusion of a useless character like >>> ' <<<<<<<<br /><br />Actually its useful but hey it cuzing a bug in my script hehe ...<br /><br /><br /><br /><br /><br /><br /><br />