DBR Fails for some

M

MaureenKLM

Have FP2002 web with lots of forms all saving into tables in Access DBs.
Almost all works fine...

I have a series of forms , each on a separate page, in a sequence that takes
registrations - form1 saves to a table and I get the autonumber ID field back
and save it as a session variable, SAVEDID. Then use this SAVEDID as in
input field on all other successive forms in the registration process - it
all works. I have a confirmation page at the end that has three separate
DBRs on it - each DBR uses the samed SAVEDID field as the criteria to display
only the current visitors registration results. It tests fine for me but I
have another person who is also testing this from her computer - she keeps
getting DB errors - missing parameter, use default values. EVERY field in
EVERY table has something in the default value field (mostly "") - Her form
submissions are getting into the database and I can see that the SAVEDID
field is making it through each form page and into the db just fine - it's
just the confirmation page w/DBRs that errors out on her machine. WHAT COULD
CAUSE THIS? Can you offer some troubleshooting ideas???

THANKS!
 
M

MaureenKLM

I'm pretty sure this must be a COOKIE related issue - although I thought by
creating a session variable that I avoid the whole cookie thing - perhaps not.

The way I got the session variable is I amended the fpdbform.inc file
(spiderweb woman's fantastic tweaks!). After submitting form1, the user goes
to form2 where I retrieve the ID field created in the submission of form1 to
the access db using a confirmtion field and the following code:

SAVED ID = <% Session("SavedID") = FP_SavedFields.item("ID")
response.write(FP_SavedFields.item("ID")) %>

In the FORM on FORM2 I have a textbox with a value of
<%=FP_SavedFields.Item("ID")%> which is where I get the saved ID back into
play - it submits to the next page, form3 and so on - All of this works. The
final page is a confirmation page where I have 3 DBRs each with the samed
SAVEDID as a parameter in the query - when I have cookies enabled all works
fine. It's when I disable cookies that I am able to see the errors some of
my site visitors are getting -

IS THERE A WORK AROUND?? Can anyone correct what I am doing?

I then
 
S

Stefan B Rusynko

Try
<% Session("SavedID")=FP_SavedFields.item("ID") %>
- this has to be in you page after you open the DBRW to get the results for: FP_SavedFields.item("ID")

Then in the forms that use the saved ID use
<input type="hidden" name="SavedID" value="<%=Session("SavedID")%>">

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| I'm pretty sure this must be a COOKIE related issue - although I thought by
| creating a session variable that I avoid the whole cookie thing - perhaps not.
|
| The way I got the session variable is I amended the fpdbform.inc file
| (spiderweb woman's fantastic tweaks!). After submitting form1, the user goes
| to form2 where I retrieve the ID field created in the submission of form1 to
| the access db using a confirmtion field and the following code:
|
| SAVED ID = <% Session("SavedID") = FP_SavedFields.item("ID")
| response.write(FP_SavedFields.item("ID")) %>
|
| In the FORM on FORM2 I have a textbox with a value of
| <%=FP_SavedFields.Item("ID")%> which is where I get the saved ID back into
| play - it submits to the next page, form3 and so on - All of this works. The
| final page is a confirmation page where I have 3 DBRs each with the samed
| SAVEDID as a parameter in the query - when I have cookies enabled all works
| fine. It's when I disable cookies that I am able to see the errors some of
| my site visitors are getting -
|
| IS THERE A WORK AROUND?? Can anyone correct what I am doing?
|
| I then
|
| "MaureenKLM" wrote:
|
| > Have FP2002 web with lots of forms all saving into tables in Access DBs.
| > Almost all works fine...
| >
| > I have a series of forms , each on a separate page, in a sequence that takes
| > registrations - form1 saves to a table and I get the autonumber ID field back
| > and save it as a session variable, SAVEDID. Then use this SAVEDID as in
| > input field on all other successive forms in the registration process - it
| > all works. I have a confirmation page at the end that has three separate
| > DBRs on it - each DBR uses the samed SAVEDID field as the criteria to display
| > only the current visitors registration results. It tests fine for me but I
| > have another person who is also testing this from her computer - she keeps
| > getting DB errors - missing parameter, use default values. EVERY field in
| > EVERY table has something in the default value field (mostly "") - Her form
| > submissions are getting into the database and I can see that the SAVEDID
| > field is making it through each form page and into the db just fine - it's
| > just the confirmation page w/DBRs that errors out on her machine. WHAT COULD
| > CAUSE THIS? Can you offer some troubleshooting ideas???
| >
| > THANKS!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top