"Approve" a new database submission before it goes public

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

"Approve" a new database submission before it goes public

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> "Approve" a new database submission before it goes public

Page: [1]


TravelSite Posts: 4 Joined: 6/11/2006 Status: offline	"Approve" a new database submission before it... - 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 Posts: 1566 Joined: 1/5/2002 From: San Diego Status: offline	RE: "Approve" a new database submission befor... - 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... _____________________________ -brian EnterpriseDB: Enterprise-class relational database management system PostgreSQL: The world's most advanced open source database (in reply to TravelSite)


Spooky Posts: 26599 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: "Approve" a new database submission befor... - 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 _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem §þk¥ Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to TravelSite)


TravelSite Posts: 4 Joined: 6/11/2006 Status: offline	RE: "Approve" a new database submission befor... - 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! (in reply to Spooky)