Hello,
question regarding the DWX Tutorials...I'm creating a page for a restaurant that wants daily specials to be shown on their site everyday. I created such a page using the book...however...would it be possible to set up a page for the manager in which he can go and see all records and select (probably via check box) only the ones he wants to display?. I already created the add record page, edit record page, etc. Thanks a lot guys. Any ideas will be greatly appreciated.

Tulio Murillo,
New Jersey, USA

Hi Tulio,

Yeah, that's definitely possible. However, before I suggest a solution, can you elaborate a bit about what you're trying to accomplish? Are you trying to "mark" records that you want to display? And then save these marks in the database so just the correct specials are shown?

Also, how often do you want the manager to update these things? Should this be a daily task?

If you supply me with some more info, I can make up a possible solution.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks for taking the time to elaborate a possible solution Imar.
ok... basically the daily specials will be shown on the main page. On the admin page...I would like the manager to see all the records (restaurants usually have 15 dishes set up to be daily specials, that they rotate)...the manager will distinguish the records(dishes) that are currently being displayed, because they are checked. I want him to have the ability not only to edit a record..but also being able to check the ones he wants to display, and unchecked the ones he doesn't. Hope I was clear.
Again, thanks for your time and courtesy.

Well, in that case, do as the Events list was maintained in the Admin section of TheSoccerSite in the book.

1. Instead of adding a delete checkbox to the list, add a ShowMeToday checkbox (or whatever you call it).

2. Have the page post to UpdateDailySpecials.asp

3. On UpdateDailySpecials.asp use the same code as on deleteEvents.asp, but instead of deleting records, execute an UPDATE statement. First, you'll need to execute a statement that disables all specials, and then you'll need to loop through the posted IDs to see what ID's you need to enable again.

Alternatively, instead of clearing all old values first, you can use WHERE IN and WHERE NOT IN to distinguish between specials you need to show, and those you need to hide.

4. On the specials page, you'll need to modify your WHERE clause, so it only queries WHERE Specials.Today = True

This is just the general idea on how you should do this. There are many ways to accomplish the same thing, but I am sure this will get you started. If you have specific questions, or need more help, please let me know.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

cool!! I'll start working on it. I'll let you know if I was able to do it. Thanks again.
Tulio Murillo,
New Jersery, USA