"Approve" a new database submission before it goes public (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

TravelSite -> "Approve" a new database submission before it goes public (6/11/2006 16:20:01)

I have created a simple database with a form using FP built in scripting (Database Result Wizard). It is a access DB created by Front Page. All using the DB wizard.

One database is a list of certain restaurants. Everything works beautiful. Users can add their restaurant to the database and it the data is added to the database and available right away.

I would like to know it there is a way that the data should not be entered automatically. More like me having to “Approve” the listing before it goes public. However, I do not want to require uses to have a login.

I’m really a very beginner so please try no to be very technical. Simple answers will help best.



ou812 -> RE: "Approve" a new database submission before it goes public (6/11/2006 16:32:49)

I've never used DRW (only directly in ASP), but I would think you should be able to do something like this in DRW anyway - add a new column to your restaurant table, maybe called "approved" and then when people submit their restaurant this is set to "N", when inserting the new record. Then you can have another form where you retrieve (select) that data to read, or whatever, and then submit for approval and when you do this it changes the "approval" column to "Y". Then when you are displaying the restaurants you only display with approval="Y".

Just one way to go about it...



Spooky -> RE: "Approve" a new database submission before it goes public (6/11/2006 16:35:53)

If you have a database, you can display records based on a criteria.
With the database design, open the access database and add a new text field called "approve"
Allow it to have zero length (ie not required)

Now, update all existing fields (that you approve of ) with the text "yes"

In your database display page, change the display criteria from "select * from database" to "select * from database WHERE approve='yes'"

When a user adds a submission, this field is not populated.

You would then either need to make an administration page or manually update the database with your approvals



TravelSite -> RE: "Approve" a new database submission before it goes public (6/12/2006 10:50:26)

[:)]You know what I love about this message board (or blog…)? Everybody here is very nice and helpful. You won’t believe how new I am in using Frontpage and designing forms and databases. In other words, a real NEWBIE. I don’t understand half the stuff discussed here. However, I found so much good advice already on this board.

Thank you ou812 and Spooky. This should help. Will try it soon. I did created a database interface with Frontpage where I can log in with my suername and pass to update, manage and delete entries. So it should be a breeze.

Now to my site… I almost gave up on my project! I ordered hosting from one company (all I needed was ASP and Frontpage extensions, no?) just to find out they don’t support Access databases (hey felle, you need Windows hosting).

Ordered hosting from another provider just to have most scripts not working. (You need NET IIS version 6.0). etc.

So I almost gave up till I found OUTFRONT!

Thank you for all your help!
[:)]



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.09375