Using Database Interface Wizard

[hank]

Its my first time to use Frontpage, particularly FP 2002.
I used Database Interface Wizard to create a website to
that connects to an Access DB, and then view, delete and
add records. When I published my website in a local
computer, the result page returns TRUE or FALSE value in
all my boolean option buttons. How can I change that to
YES/NO?

Also, I tried to edit the Access DB by adding input mask
in some of the fields. When I submit a form, the DB
accepts the values even if they dont match with the mask.
Why?

 

[Jim Buyens]

-----Original Message-----

Its my first time to use Frontpage, particularly FP
2002. I used Database Interface Wizard to create a
website to that connects to an Access DB, and then view,
delete and add records. When I published my website in a
local computer, the result page returns TRUE or FALSE
value in all my boolean option buttons. How can I change
that to YES/NO?

You would have to use a custom query that contained an
expression such as

SELECT IIf([guilty],'Yes','No') as guilty-yn, ...

rather than just

SELECT guilty, ...

Also, I tried to edit the Access DB by adding input mask
in some of the fields. When I submit a form, the DB
accepts the values even if they dont match with the
mask.

I believe that an Access mask executes in the context of
an Access form, and not when you access the database
directly through ODBC or OLEDB.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Jimmy]

Also, I tried to edit the Access DB by adding input mask
in some of the fields. When I submit a form, the DB
accepts the values even if they dont match with the mask.
Why?

You need to use "validation" in the Access d/b instead of
a mask. A mask is just an editing tool. Open the table
design and look at the item "validation rule".

Be aware that if you fail validation, you will not get an error
message returned, just a failure code. You can write some code
to watch the update and see if it works.