approve database entry BEFORE seeing live

[I Need Help!]

I have an insert record page where people can add their details however I do not want to
see the entry live until I approve it first. Can someone point me in the direction of a
tutorial to teach me this.

Thanks

[Julian Roberts]

Add a field called Approved with a default of false. To approve the content
update the field to true. Then, at front end you'd have SQL for the
recordset like

select * from mytable where Approved=true

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[I Need Help!]

I really appreciate your help however I am a complete beginner so I ask for more help!

In Access design view, I set my Approved column default value to False - well I typed it
in. Now all NEW entries have a zero in the approved column.

How do I change to True? Do I just delete the zero?

I also added this to my SQL and get errors so I guess what I am doing in Access is not
correct. As I said in my first post, a URL would be very helpful so I can learn what to
do.

.................................

SELECT *
FROM mytablenamehere = true


Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
..................................

I then tried using Yes/No in the data type with the default value set to False and Format
set to True/False and got check boxes in each field which you tick. I did this after
reading the help files.

See - I am a beginner! :P






"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d0vsbj$abd$1@forums.macromedia.com...
Add a field called Approved with a default of false. To approve the content
update the field to true. Then, at front end you'd have SQL for the
recordset like

select * from mytable where Approved=true

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[chuckomalley]

Instead of giving it the default value of False in Access, put in a hidden
field in your Insert form and give it a value of False. Then you can create an
Update form Iwith restricted access rights) that can change it to True. Cheers
Chuck

[Joe Makowiec]

On 13 Mar 2005 in macromedia.dreamweaver.appdev, chuckomalley wrote:

> Instead of giving it the default value of False in Access, put in a
> hidden field in your Insert form and give it a value of False. Then
> you can create an Update form Iwith restricted access rights) that
> can change it to True.

So that somebody can duplicate your form, change the hidden field to
'True', post whatever, and get it up immediately?

--
Joe Makowiec
[url]http://makowiec.net/[/url]
Email: [url]http://makowiec.net/email.php[/url]

[chuckomalley]

I didn't read it thoroughly. My bust. You are correct. He can make False the
default and then use an Update Behavior page to change it to true. Rough night
last night so I just breezed through the post! Cheers Chuck

[I Need Help!]

I already have hidden fields that are set to true as I was following this tutorial:


[url]http://www.dreamweaverfever.com/pain/ultradev/insert-confirm.asp[/url]

Following this tutorial, you see the entries straight away.







"Joe Makowiec" <makowiec@invalid.invalid> wrote in message
news:Xns9618503C02FDFmakowiecatnycapdotrE@216.104. 212.96...
On 13 Mar 2005 in macromedia.dreamweaver.appdev, chuckomalley wrote:

> Instead of giving it the default value of False in Access, put in a
> hidden field in your Insert form and give it a value of False. Then
> you can create an Update form Iwith restricted access rights) that
> can change it to True.

So that somebody can duplicate your form, change the hidden field to
'True', post whatever, and get it up immediately?

--
Joe Makowiec
[url]http://makowiec.net/[/url]
Email: [url]http://makowiec.net/email.php[/url]

[I Need Help!]

This is why I tried:

In Access -

Field name: approved
Data type: Yes/No
Format: True/False

In my recordset -

SELECT *
FROM myTable
WHERE approved = TRUE

My hidden field -

<input type="hidden" name="approved" value="false">


I can still see all the new entries live doing this.





"I Need Help!" <iamedia-nospam@hotmail.com> wrote in message
news:d0vruq$a06$1@forums.macromedia.com...
I have an insert record page where people can add their details however I do not want to
see the entry live until I approve it first. Can someone point me in the direction of a
tutorial to teach me this.

Thanks

[bthouin]

I Need Help! wrote:

> This is why I tried:
>
> In Access -
>
> Field name: approved
> Data type: Yes/No
> Format: True/False
>
> In my recordset -
>
> SELECT *
> FROM myTable
> WHERE approved = TRUE
>
> My hidden field -
>
> <input type="hidden" name="approved" value="false">
>
>
> I can still see all the new entries live doing this.
>
>
>
>
>
> "I Need Help!" <iamedia-nospam@hotmail.com> wrote in message
> news:d0vruq$a06$1@forums.macromedia.com...
> I have an insert record page where people can add their details however I do not want to
> see the entry live until I approve it first. Can someone point me in the direction of a
> tutorial to teach me this.
>
> Thanks
>
>
>

This Yes/No type is bad news, because it's not stored as True/False. I
think in Access you have to try 1/0 as values in your SQL statement, or
maybe "Y"/"N". This is DB-dependent. Stupid really, that there is no
standard for these things.

Regards
Bernard