Type mismatch error on ASP Database 1

[hallm]

I have an access table which stores newspaper stories for my online newspaper.&nbsp;&nbsp;On of the table records is publish which is just a yes or no option.&nbsp;&nbsp;<br><br>I've created an html form called submitter where I can add my stories.&nbsp;&nbsp;I have a menu option for the publish option that is set up to give values of yes or no depending on which one is selected.&nbsp;&nbsp;When the form is submitted it is posted to an asp page where I'm getting a type mismatch when a record is added with either publish yes or publish no.&nbsp;&nbsp;How can I convert the information selected in the submitter form to the type and format of the database.<br><br>This is kinda how the asp looks<br><br>dim publish<br>publish = Request.Form(&quot;publish&quot<br>story.AddNew<br>&nbsp;&nbsp;story(&quot;publish&quot = publish<br>story.update

 

[AnandMishra]

Please clarify wheather Publish field in HTML form is radio button or check box or input field?<br><br>if it is radio button with a value of YES or NO then you&nbsp;&nbsp;don't have to do anything.<br><br>if it is check box then<br><br>if Request.Form(&quot;publish&quot = &quot;On&quot; then<br><br>&nbsp;&nbsp;publish = &quot;YES&quot;<br>else<br>&nbsp;&nbsp;publish = &quot;NO&quot;<br><br>end if<br><br>or that is input field the enter value &quot;YES&quot; Or &quot;NO&quot;<br><br>Hope this will help you.<br><br>Anand<br><br><br><br>