|
| |
|
|
jonance
Posts: 299
From: Louisville KY USA
Status: offline
 |
check box in database update - 4/4/2001 14:39:00
I have a few websites that use a checkbox in the add a listing form. For example, in the admin section of a website i created that is a business directory for louisville, ky. There is a checkbox when you add the listing the says "Check this box to feature this business". They can only feature one business. The checkbox value is "featured" and goes to a field in the db called "featured". The "Featured" field in the db has a default value of no. So if they don't check the box then it enters no. If they do check the box it enters "featured". That separates the featured biz from the rest. Now my question lies in the update form for the records. I have the update form so the admin. can update every aspect of the record (name, address, etc.) but i can't figure how to let them change the featured biz. How can i make it so the checkbox is either checked (for the one that is featured) or not checked (for the rest) and so they can easily change the featured biz. Sorry this is so long but i figured the more info the better. Thanks in advance.john
|
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: check box in database update - 4/4/2001 21:37:00
In your update, I assume you are getting the value from a database query, if so, you need to edit the checkbox form element so that the database value is checked for a valid record<input type='checkbox' value='Featured' <%If databaseColumnCode='Featured' then response.write "checked"%>> ------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
