PC Review


Reply
Thread Tools Rate Thread

Database in subsite

 
 
=?Utf-8?B?SmFjcXVlcw==?=
Guest
Posts: n/a
 
      22nd May 2006
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?
 
Reply With Quote
 
 
 
 
Stefan B Rusynko
Guest
Posts: n/a
 
      23rd May 2006
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/FrontPa...3/Default.aspx
_____________________________________________


"Jacques" <(E-Mail Removed)> wrote in message news:423D3F6C-4FD6-4BEB-8279-(E-Mail Removed)...
| 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?


 
Reply With Quote
 
=?Utf-8?B?SmFjcXVlcw==?=
Guest
Posts: n/a
 
      23rd May 2006
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/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "Jacques" <(E-Mail Removed)> wrote in message news:423D3F6C-4FD6-4BEB-8279-(E-Mail Removed)...
> | 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?
>
>
>

 
Reply With Quote
 
Stefan B Rusynko
Guest
Posts: n/a
 
      23rd May 2006
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/FrontPa...3/Default.aspx
_____________________________________________


"Jacques" <(E-Mail Removed)> wrote in message news:2E96647A-C490-49FD-ACEA-(E-Mail Removed)...
|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/FrontPa...3/Default.aspx
| > _____________________________________________
| >
| >
| > "Jacques" <(E-Mail Removed)> wrote in message news:423D3F6C-4FD6-4BEB-8279-(E-Mail Removed)...
| > | 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?
| >
| >
| >


 
Reply With Quote
 
=?Utf-8?B?SmFjcXVlcw==?=
Guest
Posts: n/a
 
      23rd May 2006
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.

"Stefan B Rusynko" wrote:

> 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/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "Jacques" <(E-Mail Removed)> wrote in message news:2E96647A-C490-49FD-ACEA-(E-Mail Removed)...
> |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/FrontPa...3/Default.aspx
> | > _____________________________________________
> | >
> | >
> | > "Jacques" <(E-Mail Removed)> wrote in message news:423D3F6C-4FD6-4BEB-8279-(E-Mail Removed)...
> | > | 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?
> | >
> | >
> | >
>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to publish a subsite? =?Utf-8?B?bmV2ZXJzYXlkaWU=?= Microsoft Frontpage 8 3rd Apr 2007 08:40 PM
to subsite or not to subsite? =?Utf-8?B?c3ByYW0w?= Microsoft Frontpage 6 26th Nov 2006 09:18 AM
subsite =?Utf-8?B?c2FsbW9uZWxsYQ==?= Microsoft Frontpage 2 28th Jul 2006 08:08 AM
password protected subsite and Access database =?Utf-8?B?SmFu?= Microsoft Frontpage 2 3rd Oct 2005 01:21 PM
subsite =?Utf-8?B?ZGF2aWRpbnRleGFz?= Microsoft Frontpage 8 9th Jun 2005 08:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:49 AM.