Data Handling in FrontPage Form

[TAT]

I have an Access database on my FrontPage web where users can enter data. One
table has their ID information and another the data we want them to enter,
specifically comments. Anyway, I have referential integrity set so that they
must enter their correct ID or the data will not be saved into the comments
table. The problem is that when someone submits info with an incorrect ID, a
confirmation page will popup even though the data was not saved due to the
incorrect ID being used. Why doesn't this trigger my error page?

On a side note, this is an intranet site so I am not able to provide an url.

Thanks

 

[Kevin Spencer]

It doesn't trigger your error page because no error occurs. Let's say I
asked you for something you don't have. What would you give me? Nothing.
Would it be a problem (error)? No. When you do a SELECT statement with a
value that returns no records, you get 0 records back. No drips, no runs, no
errors.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Chicken Salad Alchemist

Big thicks are made up of lots of little thins.

 

[TAT]

But when you do it offline using a normal Access form, it gives an error
message saying the records must match. Since that isn't going to happen with
a FrontPage web form, any workarounds so that it will automatically let a
person know that the record was in fact not saved?

 

[Stefan B Rusynko]

In your processing page check the ID DB for their credentials and the response redirect to an error page
- better still have them "log in" first so you know who they are

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| But when you do it offline using a normal Access form, it gives an error
| message saying the records must match. Since that isn't going to happen with
| a FrontPage web form, any workarounds so that it will automatically let a
| person know that the record was in fact not saved?
|
| "Kevin Spencer" wrote:
|
| > It doesn't trigger your error page because no error occurs. Let's say I
| > asked you for something you don't have. What would you give me? Nothing.
| > Would it be a problem (error)? No. When you do a SELECT statement with a
| > value that returns no records, you get 0 records back. No drips, no runs, no
| > errors.
| >
| > --
| > HTH,
| >
| > Kevin Spencer
| > Microsoft MVP
| > Professional Chicken Salad Alchemist
| >
| > Big thicks are made up of lots of little thins.
| >
| >
| > | > >I have an Access database on my FrontPage web where users can enter data.
| > >One
| > > table has their ID information and another the data we want them to enter,
| > > specifically comments. Anyway, I have referential integrity set so that
| > > they
| > > must enter their correct ID or the data will not be saved into the
| > > comments
| > > table. The problem is that when someone submits info with an incorrect ID,
| > > a
| > > confirmation page will popup even though the data was not saved due to the
| > > incorrect ID being used. Why doesn't this trigger my error page?
| > >
| > > On a side note, this is an intranet site so I am not able to provide an
| > > url.
| > >
| > > Thanks
| >
| >
| >