Database in subsite

J

Jacques

In a subsite, I created a form where the results are saved to a Access
database. After the user fill out and submit the form, the same page appear
instead of going to a confirmation page. Then I check my database and I see
that no record has been added.
So I converted my subsite to a folder and retried but this time, it worked.
I saw the confirmation page and a record was added.
Do you know how I can make it work in a subsite?
 
S

Stefan B Rusynko

Depends on your host settings and whether parent pathing is enabled on whether you can use a DB in the root from a subweb (if using
the DBRW)
If using hand coded ASP
- Does the subweb have DB Connection (a global.asa file) w/ the correct path to the DB

--

_____________________________________________
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
_____________________________________________


| In a subsite, I created a form where the results are saved to a Access
| database. After the user fill out and submit the form, the same page appear
| instead of going to a confirmation page. Then I check my database and I see
| that no record has been added.
| So I converted my subsite to a folder and retried but this time, it worked.
| I saw the confirmation page and a record was added.
| Do you know how I can make it work in a subsite?
 
J

Jacques

I have Fontpage web hosting on a windows server 2003. I went to Plesk 7.5
control panel but I don't know what to change there. I don't know what is
parent pathing and DBRW. As a test, in the subsite, I changed in global.asa
DBQ=URL=fpdb/Feedback-tax.mdb to the full address of the db starting with
http: and it inserted the record correctly. But I didn't see the confirmation
page.
Is there a way to make it work more easily?
 
S

Stefan B Rusynko

DBRW - DataBase Results Wizard

Have no ideas what is calling your confirmation page
- ASP hand coded?

--

_____________________________________________
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
_____________________________________________


|I have Fontpage web hosting on a windows server 2003. I went to Plesk 7.5
| control panel but I don't know what to change there. I don't know what is
| parent pathing and DBRW. As a test, in the subsite, I changed in global.asa
| DBQ=URL=fpdb/Feedback-tax.mdb to the full address of the db starting with
| http: and it inserted the record correctly. But I didn't see the confirmation
| page.
| Is there a way to make it work more easily?
|
| "Stefan B Rusynko" wrote:
|
| > Depends on your host settings and whether parent pathing is enabled on whether you can use a DB in the root from a subweb (if
using
| > the DBRW)
| > If using hand coded ASP
| > - Does the subweb have DB Connection (a global.asa file) w/ the correct path to the DB
| >
| > --
| >
| > _____________________________________________
| > 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
| > _____________________________________________
| >
| >
| > | In a subsite, I created a form where the results are saved to a Access
| > | database. After the user fill out and submit the form, the same page appear
| > | instead of going to a confirmation page. Then I check my database and I see
| > | that no record has been added.
| > | So I converted my subsite to a folder and retried but this time, it worked.
| > | I saw the confirmation page and a record was added.
| > | Do you know how I can make it work in a subsite?
| >
| >
| >
 
J

Jacques

In "Form Properties" then "Options" button, you'll see "URL of confirmation
page".
I don't hand code ASP, I just did it in global.asa to do a test because it
didn't find the database so I put the full address. But I would like to avoid
hand coding in ASP. Forms with database works well without coding in the root
web site but not in a subsite.
 

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