Disagree any of this will work as simply as "just sending a few files to
the client"
1) To use an Access DB it needs to be a Windows Server that supports
Access
- and the Access DB needs to be added to the client server w/ the correct
permissions
(the client will need to know how to add a DB connection since there are
no FP SE available)
2) The server side code (ASP or PHP) will need to have the correct DB
connection
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
| Yes but the form page might need to be .php and not .html (not sure -
don't
| use PHP). And you should have then check with their web host to see if
it
| supports PHP.
|
| You could also look up examples using ASP. If it's a Windows Server
then it
| supports ASP. You can see some examples at
|
http://www.asp101.com/samples/form_to_db.asp or other ones at
|
http://www.asp101.com/samples/
|
| --
| David Berry
| FrontPage Support:
http://www.frontpagemvps.com/
|
|
|
| | > David,
| >
| > Thanks. Just to recap:
| >
| > - will develop a basic form in FP creating a .htm to send to client.
Will
| > also send along an Access database configured to save the data.
| > - in the .htm form, will include a call to a .php script file (not yet
| > familiar with PHP, but will have to teach self) that will run when
form is
| > submitted. It will collect the info in the form and deliver it to the
| > database for storage. Will also send this script file to client with
the
| > .htm file and database.
| >
| > All this assumes this client supports PHP on their web server.
| >
| > I understood that PHP script files can collect the info on the form
after
| > submit. Is that correct? If yes, will probably take the chance that
most
| > servers will support use of PHP and will hit the books to start the
| > learing.
| >
| > Many thanks for all your help in getting me started.
| >
| > Mark
| >
| >
| > "David Berry" wrote:
| >
| >> Yes, you could send it to your site or their site BUT it can't be an
HTML
| >> file. It needs to be PHP, ASP, JSP or whatever you're going to
script it
| >> in
| >> and their server would need to support the type of scripting you're
going
| >> to
| >> use UNLESS you're going to use a CGI script (or something that will
pass
| >> the
| >> information from an HTML page). For example, PayPal uses a CGI Script
to
| >> pass information from an HTML page on your site to their server.
| >>
| >> You can develop the form in FrontPage and then give it to the client
to
| >> put
| >> on their site (FP or Non-FP). I'd make it generic looking (no
layout) so
| >> they can integrate it with their own site layout/look easily.
| >>
| >> --
| >> David Berry
| >> FrontPage Support:
http://www.frontpagemvps.com/
| >>
| >>
| >> | >> > David,
| >> >
| >> > Thanks. This sounds promising.
| >> >
| >> > If I understand, I could develop a form in FP, then give the .htm
file
| >> > for
| >> > this form to a client to post on their site, a non FP site. Since
the
| >> > form
| >> > is an html file, it can be opened with a link to it on their site
and
| >> > will
| >> > perform as it would in FP.
| >> >
| >> > If their site supports PHP, then I could write the submit code in
PHP
| >> > to
| >> > send the form info to another site. You said this could be my
site,
| >> > but
| >> > it
| >> > seems like it could be sent anywhere, including to their (my
client's)
| >> > web
| >> > server. Another PHP scrpt would then upload this info into a
database,
| >> > also
| >> > on their server.
| >> >
| >> > Do I have this right? Is there any references or other help you
might
| >> > suggest for accomplishing this task?
| >> >
| >> > Many thanks for your help on this,
| >> > Mark
| >> >
| >> >
| >> >
| >> > "David Berry" wrote:
| >> >
| >> >> He could with ASP (or another scripting language). On their site
the
| >> >> Form
| >> >> Action would need to send to an ASP page on his site that would
then
| >> >> pick
| >> >> up
| >> >> the information and update the database. It's the same principle
as
| >> >> putting
| >> >> a Papal cart/button on your page and then posting to their server.
| >> >> (hidden
| >> >> fields, querystrings etc)
| >> >>
| >> >> --
| >> >> David Berry
| >> >> FrontPage Support:
http://www.frontpagemvps.com/
| >> >>
| >> >>
| >> >> | >> >> > You can not create a form that will work on someone else's web
site
| >> >> > or
| >> >> > server, especially writing to a DB
| >> >> > Depending on your host and what DB & server side script they
support
| >> >> > you
| >> >> > may be able to create a form on your site that writes to a
| >> >> > DB on your server
| >> >> >
| >> >> > --
| >> >> >
| >> >> > _____________________________________________
| >> >> > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| >> >> > "Warning - Using the F1 Key will not break anything!" (-;
| >> >> > _____________________________________________
| >> >> >
| >> >> >
| >> >> > | >> >> > | Need some help for a beginner just starting to use FP and a
| >> >> > database.
| >> >> > |
| >> >> > | I need to create a data collection form that I can deliver to
| >> >> > clients
| >> >> > who
| >> >> > | will post the form on their web site. Their customers will
click
| >> >> > on
| >> >> > a
| >> >> > link
| >> >> > | to that form, enter their info, and click submit. I will need
to
| >> >> > write
| >> >> > the
| >> >> > | code for the submit to send the data to a database (probably
| >> >> > Access).
| >> >> > |
| >> >> > | As I understand it, I can create this form and save it using
FP.
| >> >> > It
| >> >> > saves
| >> >> > | as any other page (i.e., as a .htm) and I then simply give the
| >> >> > form
| >> >> > to
| >> >> > my
| >> >> > | clients, along with the Access database that will be used to
| >> >> > collect
| >> >> > the
| >> >> > data
| >> >> > | from the form. Do I understand correctly that this .htm will
run
| >> >> > for
| >> >> > clients
| >> >> > | that do not even use FP for their web site?
| >> >> > |
| >> >> > | The other issue is putting the code together for the submit
| >> >> > button.
| >> >> > Do
| >> >> > I
| >> >> > | need to learn something like PHP for this, or does FP have
| >> >> > standard
| >> >> > methods
| >> >> > | to accomplish this task? Can anyone provide a coding example
of
| >> >> > how
| >> >> > this
| >> >> > | data transfer gets done from a submit button on a FP form?
| >> >> > |
| >> >> > | Thanks in advance for help on this,
| >> >> > | Mark
| >> >> > |
| >> >> >
| >> >> >
| >> >>
| >> >>
| >> >>
| >>
| >>
| >>
|
