Tick Boxes

I have had to design a page for students at our school. They are asked to submit stories etc for the website. I have set it up so I have to authorise the information before it goes live. This works fine but for one small problem. My admin page shows all the submitted information. Each one has a tick box next to it. Default is False not to show. If I tick the box the information is shown on the site. Great so far. Now when I go back to my admin page, any items that have been authorised to be shown do not have a tick in the box. All boxes are empty so I have no way of knowing which one is showing. I am already using the WebWiz Guestbook on our site but I don't want to use this for this kind of form. Thanks

Yes, like michael said, store the state of the checkbox in the db, that info should be submited along with the rest.

Then, when you read back, don't forget to read the status of the check box, and on rendering the list you have to do a [ If chkStatus from DB = true then ] ... inside the check box to render the check box and assign the property [checked] to it, so it shows the check box ticked up accordingly.

Ok, you have an ACCEPT property on the INPUT that you might not need, anyway, here's how you do it:

This is when you are reading from the database:

Dim checkED checkED = "" '// Here goes you database conn and recordset '// Then you start rendering If RS("fld_chkStatus") Then checkED = "checked" <input name="checkbox" type="checkbox" value="true" <%= checkED %>/>

Note that RS("fld_chkStatus") should be changed to the db field you are storing the true/flase state of the checkbox.

This should work, let me know.

RS stands for RecordSet, but you have to change it to what you call it in your declarations, such as:

Set RS = Server.CreateObject("ADODB.Recordset")

Look in your code where you have this declaration and change RS in my code to whatever you have in yours.