DBR W/Form submit to database

[MaureenKLM]

FrontPage 02 web with an Access 02 Database.

I have a DBR section with a Search form to return specific records - this
works.
I wish to allow users to update their record (returned in the above DBR
using login/pswd fields to restrict the record) when/if necessary.

I have inserted a form at the end, but within, the DBR section - the form
fields reuse the fields displayed in the DBR section (thanks to help from
S.B.R). I would like to allow the user to update his record back into the
database but the form does not provide the 'update to database' option - it
is not available. This seems to be because the form is within the DBR - but
if I move the form outside of the DBR then I am unable to reuse the DBR
fields in the form. I can not have the users reenter all info to update.

Can you offer any suggestions on how to handle this situation? Thanks in
advance for any assistance you can offer.

 

[Stefan B Rusynko]

The DBRW is just that (shows results from a DB)
You need to look at the DBIW as a subweb to edit DB records
- File New Site - more web site templates




| FrontPage 02 web with an Access 02 Database.
|
| I have a DBR section with a Search form to return specific records - this
| works.
| I wish to allow users to update their record (returned in the above DBR
| using login/pswd fields to restrict the record) when/if necessary.
|
| I have inserted a form at the end, but within, the DBR section - the form
| fields reuse the fields displayed in the DBR section (thanks to help from
| S.B.R). I would like to allow the user to update his record back into the
| database but the form does not provide the 'update to database' option - it
| is not available. This seems to be because the form is within the DBR - but
| if I move the form outside of the DBR then I am unable to reuse the DBR
| fields in the form. I can not have the users reenter all info to update.
|
| Can you offer any suggestions on how to handle this situation? Thanks in
| advance for any assistance you can offer.
|
|
|
|

 

[MaureenKLM]

Thanks once again.

I had started with trying the DBIW but I am unable to see VIEWS as a source
option in the DBIW (lists tables only) which is why I started looking into
using the DBR and forms in the first place.

Do I have to create a whole new sub-web to be able to see VIEWS in the DBIW?
My host is saying "NO" to a subweb so I am trying to do this in the root web.
I've used DBIW elsewhere in this same web. What is the reason I can not
choose a VIEW (query) as a source for the DBIW?

 

[MaureenKLM]

I realize you can not have a DBR (requires .asp page) and a form on the same
page since the FP form requires a .htm page. I found the following line of
code on the MS KB230712which is supposed to allow use of FP Components on an
..ASP page -

<!--#include virtual '"/path/filename.htm"-->

This did not work for me - can you help?

 

[Jens Peter Karlsen[FP MVP]]

Correct it to this:
<!--#include virtual "/path/filename.htm"-->

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

-----Original Message-----
From: MaureenKLM [mailto:[email protected]]
Posted At: 6. april 2005 23:47
Posted To: microsoft.public.frontpage.programming
Conversation: DBR W/Form submit to database
Subject: Re: DBR W/Form submit to database


I realize you can not have a DBR (requires .asp page) and a
form on the same page since the FP form requires a .htm page.
I found the following line of code on the MS KB230712which
is supposed to allow use of FP Components on an .ASP page -

<!--#include virtual '"/path/filename.htm"-->

This did not work for me - can you help?

The DBRW is just that (shows results from a DB) You need to look at
the DBIW as a subweb to edit DB records
- File New Site - more web site templates




"MaureenKLM" <[email protected]> wrote

in message news:[email protected]...

| FrontPage 02 web with an Access 02 Database.
|
| I have a DBR section with a Search form to return specific records -
| this works.
| I wish to allow users to update their record (returned in the above
| DBR using login/pswd fields to restrict the record) when/if necessary.
|
| I have inserted a form at the end, but within, the DBR section - the
| form fields reuse the fields displayed in the DBR section (thanks to
| help from S.B.R). I would like to allow the user to update his
| record back into the database but the form does not provide the
| 'update to database' option - it is not available. This seems to be
| because the form is within the DBR - but if I move the form outside
| of the DBR then I am unable to reuse the DBR fields in

the form. I can not have the users reenter all info to update.

|
| Can you offer any suggestions on how to handle this situation?
| Thanks in advance for any assistance you can offer.
|
|
|
|

 

[MaureenKLM]

Thank you - I see MY typo of the extra " ' " character preceeding the quotes.

My typo is not what is causing the problem though - it still does not work.
I have tried it both with and without the = sign as in: <!--#include
virtual="/path/filename.htm"-->

I do not see the include page in FP Preview but the rest of the page
displays - however, when I preview through browser, I get an error that the
page can not display at all (due to the include file line).

The ASP page I am trying to include a form on has a DBR region on it. I
have placied the include line both BEFORE and AFTER the close of the DBR -
always before the close of the body - nothing seems to work. The path I'm
using is correct but the include line will not work for me.

Can you offer any additional hints or suggestions????

Correct it to this:
<!--#include virtual "/path/filename.htm"-->

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

-----Original Message-----
From: MaureenKLM [mailto:[email protected]]
Posted At: 6. april 2005 23:47
Posted To: microsoft.public.frontpage.programming
Conversation: DBR W/Form submit to database
Subject: Re: DBR W/Form submit to database


I realize you can not have a DBR (requires .asp page) and a
form on the same page since the FP form requires a .htm page.
I found the following line of code on the MS KB230712which
is supposed to allow use of FP Components on an .ASP page -

<!--#include virtual '"/path/filename.htm"-->

This did not work for me - can you help?

The DBRW is just that (shows results from a DB) You need to look at
the DBIW as a subweb to edit DB records
- File New Site - more web site templates




"MaureenKLM" <[email protected]> wrote

in message news:[email protected]...

| FrontPage 02 web with an Access 02 Database.
|
| I have a DBR section with a Search form to return specific records -
| this works.
| I wish to allow users to update their record (returned in the above
| DBR using login/pswd fields to restrict the record) when/if necessary.
|
| I have inserted a form at the end, but within, the DBR section - the
| form fields reuse the fields displayed in the DBR section (thanks to
| help from S.B.R). I would like to allow the user to update his
| record back into the database but the form does not provide the
| 'update to database' option - it is not available. This seems to be
| because the form is within the DBR - but if I move the form outside
| of the DBR then I am unable to reuse the DBR fields in

the form. I can not have the users reenter all info to update.

|
| Can you offer any suggestions on how to handle this situation?
| Thanks in advance for any assistance you can offer.
|
|
|
|

 

[Henry]

I use FP2000 and Access 2000 database on my site and I am able to do this.
In the form properties dialogue of your form select send to other: Custom
ISAPI,NSAPI,CGI,orASP Script. Under options enter a new form name in the
action field ie. form2.asp and Method should be POST.

Create the new form2.asp page and setup a new DBR section that querries the
same information that you querried in the first form. Once you have done
this you should be able to edit the webbot s-sql statement in HTML view to
change it from SELECT SQL to an UPDATE SQL format. See below for example.

s-sql="SELECT * FROM TABLENAME WHERE (ID=::ID:"

Change To

s-sql="UPDATE TABLENAME SET
DBFIELD1='::FORMFIELD1::',DBFIELD2='::FORMFIELD2::' WHERE ID=::ID::"

I have ID being the first field in the database table and also the name of
the first form field. You will need to change it if you called your form
field something else in the first form. Also, text fields in the database
need the ' around them as in FORMFIELD1 and FORMFIELD2 above while Number
fields do not need the ' around them as in ID above.

Finally I would follow the first DBR section with a second DBR section that
will querry the results again to act as a confirmation page for your user
who did the update as they will not see any results from the first DBR
section.

Thank you - I see MY typo of the extra " ' " character preceeding the quotes.

My typo is not what is causing the problem though - it still does not work.
I have tried it both with and without the = sign as in: <!--#include
virtual="/path/filename.htm"-->

I do not see the include page in FP Preview but the rest of the page
displays - however, when I preview through browser, I get an error that the
page can not display at all (due to the include file line).

The ASP page I am trying to include a form on has a DBR region on it. I
have placied the include line both BEFORE and AFTER the close of the DBR -
always before the close of the body - nothing seems to work. The path I'm
using is correct but the include line will not work for me.

Can you offer any additional hints or suggestions????

Correct it to this:
<!--#include virtual "/path/filename.htm"-->

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

-----Original Message-----
From: MaureenKLM [mailto:[email protected]]
Posted At: 6. april 2005 23:47
Posted To: microsoft.public.frontpage.programming
Conversation: DBR W/Form submit to database
Subject: Re: DBR W/Form submit to database


I realize you can not have a DBR (requires .asp page) and a
form on the same page since the FP form requires a .htm page.
I found the following line of code on the MS KB230712which
is supposed to allow use of FP Components on an .ASP page -

<!--#include virtual '"/path/filename.htm"-->

This did not work for me - can you help?

:

The DBRW is just that (shows results from a DB) You need to look at
the DBIW as a subweb to edit DB records
- File New Site - more web site templates

--

_____________________________________________
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.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


in message | FrontPage 02 web with an Access 02 Database.
|
| I have a DBR section with a Search form to return
specific records -
| this works.
| I wish to allow users to update their record (returned in
the above
| DBR using login/pswd fields to restrict the record)
when/if necessary.
|
| I have inserted a form at the end, but within, the DBR
section - the
| form fields reuse the fields displayed in the DBR section
(thanks to
| help from S.B.R). I would like to allow the user to update his
| record back into the database but the form does not provide the
| 'update to database' option - it is not available. This
seems to be
| because the form is within the DBR - but if I move the
form outside
| of the DBR then I am unable to reuse the DBR fields in
the form. I can not have the users reenter all info to update.
|
| Can you offer any suggestions on how to handle this situation?
| Thanks in advance for any assistance you can offer.
|
|
|
|

 

[Jens Peter Karlsen [FP MVP]]

You are not literally typing /path in FP are you? It is meant to be
replaced by the actual path to the include file.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

Thank you - I see MY typo of the extra " ' " character preceeding the quotes.

My typo is not what is causing the problem though - it still does not work.
I have tried it both with and without the = sign as in: <!--#include
virtual="/path/filename.htm"-->

I do not see the include page in FP Preview but the rest of the page
displays - however, when I preview through browser, I get an error that the
page can not display at all (due to the include file line).

The ASP page I am trying to include a form on has a DBR region on it. I
have placied the include line both BEFORE and AFTER the close of the DBR -
always before the close of the body - nothing seems to work. The path I'm
using is correct but the include line will not work for me.

Can you offer any additional hints or suggestions????

:

Correct it to this:
<!--#include virtual "/path/filename.htm"-->

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

-----Original Message-----
From: MaureenKLM [mailto:[email protected]]
Posted At: 6. april 2005 23:47
Posted To: microsoft.public.frontpage.programming
Conversation: DBR W/Form submit to database
Subject: Re: DBR W/Form submit to database


I realize you can not have a DBR (requires .asp page) and a
form on the same page since the FP form requires a .htm page.
I found the following line of code on the MS KB230712which
is supposed to allow use of FP Components on an .ASP page -

<!--#include virtual '"/path/filename.htm"-->

This did not work for me - can you help?

:


The DBRW is just that (shows results from a DB) You need to look at
the DBIW as a subweb to edit DB records
- File New Site - more web site templates

--

_____________________________________________
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.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________



in message
| FrontPage 02 web with an Access 02 Database.
|
| I have a DBR section with a Search form to return

specific records -

| this works.
| I wish to allow users to update their record (returned in

the above

| DBR using login/pswd fields to restrict the record)

when/if necessary.

|
| I have inserted a form at the end, but within, the DBR

section - the

| form fields reuse the fields displayed in the DBR section

(thanks to

| help from S.B.R). I would like to allow the user to update his
| record back into the database but the form does not provide the
| 'update to database' option - it is not available. This

seems to be

| because the form is within the DBR - but if I move the

form outside

| of the DBR then I am unable to reuse the DBR fields in

the form. I can not have the users reenter all info to update.

|
| Can you offer any suggestions on how to handle this situation?
| Thanks in advance for any assistance you can offer.