Need help with saving data to database (via form)

[Tom]

Hi Experts:

I recently purchased FrontPage 2003 and the book "Microsoft FrontPage
2003 -- Inside Out" (by Jim Buyens).

At this time, I need some help with Jim's approach in chapter 36 "Using
Forms and Databases". Here's what I have done thus far:

Background info on website:
- I created a website and uploaded it to my ISP. This website has a link
to the form "sighting.asp"

Creating the form "sighting.asp":
- I right-clicked the Form Properties (sighting.asp) and let the wizard
create the database "sighting.mdb"
- by default, the wizard created a folder called "fpdb" into which the mdb
was added
- also, while creating the database via the wizard, the file "global.asp"
was added to the web's root directory

Uploading data to web:
- I then uploaded the folder (DatabaseTest) that contains the website
"sighting.asp"
- uploaded the folder "fpdb"
- uploaded the file "global.asp"

Now, on the website, clicking on the "link" opens the form "sighting.asp"
successfully. Here's the problem though... when I enter the information
and then click SUBMIT nothing seems to happen. I don't the get the
confirmation page (which according to Jim's chapter should be created by
default).

More importantly though, submitting the record didn't add anything to the
table in the mdb.

What am I doing wrong?


Thanks,
Tom

 

[Ronx]

Database Test - is this a FrontPage web or just a folder? Since FP
created the fpdb folder I will assume it is a web.
Upload - How? You need to http publish (File->Publish Site and use a
destination in the form http://example.com) the site to a server
running the FrontPage extensions. Using http publishing the fpdb
folder on the server will be given the correct write permissions
required for the database application to work.
Giving a link to the published pages may get a better response.

 

[Tom]

Ronx:

Thanks for the response... after having done more research, I realize now
that my ISP does not support "Access / ASP" support.

Anyhow, here's the link:
http://webpages.charter.net/t.bock/Database/

Now, for testing purposes I uploaded the folders & files to
http://localhost.

Here's the weird thing... when I enter data in the form and then submit in
and then locate the mdb at c:\inetpub\wwwroot\fpdb\sighting.mdb, the date
time stamp of the mdb has changed to the DST when I pressed SUBMIT.
However, no records were added to the table "Results".

Do you know as to why it makes the connection and obviously updates the file
(based on the updated date time stamp) but won't add any record to the
table?

 

[Stefan B Rusynko]

Obviously if your host does not support ASP or Access you can not use your Access DB and .asp page online

When working w/ local host and a DB you do not send form results to a file location
(as in c:\inetpub\wwwroot\fpdb\sighting.mdb)

Your open your http://localhost/ in FP and File Import your DB (allowing FP to create the db folder and its permissions, plus the
global.asa required for DB connection)

Suggest you see the FP help on Database Results Wizard or Database Interface Wizard




| Ronx:
|
| Thanks for the response... after having done more research, I realize now
| that my ISP does not support "Access / ASP" support.
|
| Anyhow, here's the link:
| http://webpages.charter.net/t.bock/Database/
|
| Now, for testing purposes I uploaded the folders & files to
| http://localhost.
|
| Here's the weird thing... when I enter data in the form and then submit in
| and then locate the mdb at c:\inetpub\wwwroot\fpdb\sighting.mdb, the date
| time stamp of the mdb has changed to the DST when I pressed SUBMIT.
| However, no records were added to the table "Results".
|
| Do you know as to why it makes the connection and obviously updates the file
| (based on the updated date time stamp) but won't add any record to the
| table?
|
| --
| Thanks,
| Tom
|
|
| | > Database Test - is this a FrontPage web or just a folder? Since FP
| > created the fpdb folder I will assume it is a web.
| > Upload - How? You need to http publish (File->Publish Site and use a
| > destination in the form http://example.com) the site to a server running
| > the FrontPage extensions. Using http publishing the fpdb folder on the
| > server will be given the correct write permissions required for the
| > database application to work.
| > Giving a link to the published pages may get a better response.
| > --
| > Ron Symonds
| > Microsoft MVP (FrontPage)
| > Reply only to group - emails will be deleted unread.
| >
| > | >> Hi Experts:
| >>
| >> I recently purchased FrontPage 2003 and the book "Microsoft FrontPage
| >> 2003 -- Inside Out" (by Jim Buyens).
| >>
| >> At this time, I need some help with Jim's approach in chapter 36 "Using
| >> Forms and Databases". Here's what I have done thus far:
| >>
| >> Background info on website:
| >> - I created a website and uploaded it to my ISP. This website has a
| >> link to the form "sighting.asp"
| >>
| >> Creating the form "sighting.asp":
| >> - I right-clicked the Form Properties (sighting.asp) and let the wizard
| >> create the database "sighting.mdb"
| >> - by default, the wizard created a folder called "fpdb" into which the
| >> mdb was added
| >> - also, while creating the database via the wizard, the file "global.asp"
| >> was added to the web's root directory
| >>
| >> Uploading data to web:
| >> - I then uploaded the folder (DatabaseTest) that contains the website
| >> "sighting.asp"
| >> - uploaded the folder "fpdb"
| >> - uploaded the file "global.asp"
| >>
| >> Now, on the website, clicking on the "link" opens the form "sighting.asp"
| >> successfully. Here's the problem though... when I enter the information
| >> and then click SUBMIT nothing seems to happen. I don't the get the
| >> confirmation page (which according to Jim's chapter should be created by
| >> default).
| >>
| >> More importantly though, submitting the record didn't add anything to the
| >> table in the mdb.
| >>
| >> What am I doing wrong?
| >>
| >>
| >> Thanks,
| >> Tom
| >>
| >>
| >>
| >
| >
|
|

 

[Tom]

Thanks for the info.

--
Thanks,
Tom

Obviously if your host does not support ASP or Access you can not use your
Access DB and .asp page online

When working w/ local host and a DB you do not send form results to a file
location
(as in c:\inetpub\wwwroot\fpdb\sighting.mdb)

Your open your http://localhost/ in FP and File Import your DB (allowing
FP to create the db folder and its permissions, plus the
global.asa required for DB connection)

Suggest you see the FP help on Database Results Wizard or Database
Interface Wizard




| Ronx:
|
| Thanks for the response... after having done more research, I realize
now
| that my ISP does not support "Access / ASP" support.
|
| Anyhow, here's the link:
| http://webpages.charter.net/t.bock/Database/
|
| Now, for testing purposes I uploaded the folders & files to
| http://localhost.
|
| Here's the weird thing... when I enter data in the form and then submit
in
| and then locate the mdb at c:\inetpub\wwwroot\fpdb\sighting.mdb, the
date
| time stamp of the mdb has changed to the DST when I pressed SUBMIT.
| However, no records were added to the table "Results".
|
| Do you know as to why it makes the connection and obviously updates the
file
| (based on the updated date time stamp) but won't add any record to the
| table?
|
| --
| Thanks,
| Tom
|
|
| | > Database Test - is this a FrontPage web or just a folder? Since FP
| > created the fpdb folder I will assume it is a web.
| > Upload - How? You need to http publish (File->Publish Site and use a
| > destination in the form http://example.com) the site to a server
running
| > the FrontPage extensions. Using http publishing the fpdb folder on
the
| > server will be given the correct write permissions required for the
| > database application to work.
| > Giving a link to the published pages may get a better response.
| > --
| > Ron Symonds
| > Microsoft MVP (FrontPage)
| > Reply only to group - emails will be deleted unread.
| >
| > | >> Hi Experts:
| >>
| >> I recently purchased FrontPage 2003 and the book "Microsoft FrontPage
| >> 2003 -- Inside Out" (by Jim Buyens).
| >>
| >> At this time, I need some help with Jim's approach in chapter 36
"Using
| >> Forms and Databases". Here's what I have done thus far:
| >>
| >> Background info on website:
| >> - I created a website and uploaded it to my ISP. This website has a
| >> link to the form "sighting.asp"
| >>
| >> Creating the form "sighting.asp":
| >> - I right-clicked the Form Properties (sighting.asp) and let the
wizard
| >> create the database "sighting.mdb"
| >> - by default, the wizard created a folder called "fpdb" into which
the
| >> mdb was added
| >> - also, while creating the database via the wizard, the file
"global.asp"
| >> was added to the web's root directory
| >>
| >> Uploading data to web:
| >> - I then uploaded the folder (DatabaseTest) that contains the website
| >> "sighting.asp"
| >> - uploaded the folder "fpdb"
| >> - uploaded the file "global.asp"
| >>
| >> Now, on the website, clicking on the "link" opens the form
"sighting.asp"
| >> successfully. Here's the problem though... when I enter the
information
| >> and then click SUBMIT nothing seems to happen. I don't the get the
| >> confirmation page (which according to Jim's chapter should be created
by
| >> default).
| >>
| >> More importantly though, submitting the record didn't add anything to
the
| >> table in the mdb.
| >>
| >> What am I doing wrong?
| >>
| >>
| >> Thanks,
| >> Tom
| >>
| >>
| >>
| >
| >
|
|