This is Interesting: Free Magazines for Graphics designers and webmasters  


Home > Archive > Front Page > May 2004 > Database integration with fp 2000





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Database integration with fp 2000
Mike

2004-05-30, 4:14 am

is is possible to have a form from your database such as
the one in Northwind sample automatically update records
from your website if used in the same manner as a
guestbook. Thanks
Andrew Murray

2004-05-30, 4:14 am

If you set the form to connect to a database, then yes, you can use it for
anything you like.
I don't know what you mean 'automatically' but you can have a form (which is your
"guest book submission" form) and have the entries saved to a database, then a
link to your asp page using the results wizard to display the entries.

If I'm off the ttack here with answering, please clarify what it is you're
asking. If you want an automatic update or something you'll probably need to
write a custom ASP code.


"Mike" <anonymous@discussions.microsoft.com> wrote in message
news:14f4a01c445f6$14a18ea0$a401280a@phx.gbl...
> is is possible to have a form from your database such as
> the one in Northwind sample automatically update records
> from your website if used in the same manner as a
> guestbook. Thanks



Mike

2004-05-30, 12:15 pm

Andrew
thanks for your response. What I want to do is use the
guest book form on my website to update my database table
name "customers" when the user fills out the form. I now
know what you mean by update to db but all the current
fields on the form do not show up in my table. I have
updated my table thru access but it doesnt show in FP. Am
I making sense
Mike
>-----Original Message-----
>If you set the form to connect to a database, then yes,

you can use it for
>anything you like.
>I don't know what you mean 'automatically' but you can

have a form (which is your
>"guest book submission" form) and have the entries saved

to a database, then a
>link to your asp page using the results wizard to

display the entries.
>
>If I'm off the ttack here with answering, please clarify

what it is you're
>asking. If you want an automatic update or something

you'll probably need to
>write a custom ASP code.
>
>
>"Mike" <anonymous@discussions.microsoft.com> wrote in

message
>news:14f4a01c445f6$14a18ea0$a401280a@phx.gbl...
as[color=darkred]
records[color=darkred]
>
>
>.
>

Thomas A. Rowe

2004-05-30, 12:15 pm

Just create a form that has the same fields as your database in FP, then under Form Properties,
select the send to database option.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Mike" <anonymous@discussions.microsoft.com> wrote in message
news:1553f01c44642$51f51aa0$a001280a@phx.gbl...[color=darkred]
> Andrew
> thanks for your response. What I want to do is use the
> guest book form on my website to update my database table
> name "customers" when the user fills out the form. I now
> know what you mean by update to db but all the current
> fields on the form do not show up in my table. I have
> updated my table thru access but it doesnt show in FP. Am
> I making sense
> Mike
> you can use it for
> have a form (which is your
> to a database, then a
> display the entries.
> what it is you're
> you'll probably need to
> message
> as
> records


Sponsored Links


Copyright 2003 - 2008 forum4designers.com  Software forum  Computer Hardware reviews