Database Editor Problems

[Guest]

I have searched through many threads regarding database updating and I can
not find a solution to my problems. Following is a brief description:

I created a form to gather input from users. Then I had FP create a database
for me on my server. Next I used the Database Interface Wizard and set up a
format to display search results. I had FP create every page it could
(results_page, database-editor, confirm, delete, edit, list, new,submission
and update). Next I used the Database Results Wizard to add a Search Form to
the results.asp page. This allows the user to search for specific record
types in the database. Up to this point, everything was going well. Then I
tried to add a search form to the database_editor and of course it does not
work. I want to be able to delete or change data in specific records. Since
the database is quite large, I need to be able to search for specific types
of records, from which I want to select one and perform the delete or update
process. I have tried adding search forms to other pages including the edit,
list, and delete pages without success. Is there a way to add a search form
so I can search for specific types of records to be updated? This problem is
driving me crazy. I have read and re-read the help pages over and over and I
am still having no success.

 

[Stefan B Rusynko]

Beyond the capability of wizards
Hand code the search using say
http://www.asp101.com/samples/db_paged_search.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I have searched through many threads regarding database updating and I can
| not find a solution to my problems. Following is a brief description:
|
| I created a form to gather input from users. Then I had FP create a database
| for me on my server. Next I used the Database Interface Wizard and set up a
| format to display search results. I had FP create every page it could
| (results_page, database-editor, confirm, delete, edit, list, new,submission
| and update). Next I used the Database Results Wizard to add a Search Form to
| the results.asp page. This allows the user to search for specific record
| types in the database. Up to this point, everything was going well. Then I
| tried to add a search form to the database_editor and of course it does not
| work. I want to be able to delete or change data in specific records. Since
| the database is quite large, I need to be able to search for specific types
| of records, from which I want to select one and perform the delete or update
| process. I have tried adding search forms to other pages including the edit,
| list, and delete pages without success. Is there a way to add a search form
| so I can search for specific types of records to be updated? This problem is
| driving me crazy. I have read and re-read the help pages over and over and I
| am still having no success.
| --
| RWS FLorida

 

[Kathleen Anderson [MVP - FrontPage]]

RWS:
You can create a new database results query page in the editor folder, keep
the search form, delete the results table, and have it posts the results to
the list.asp page. (in Normal View, right-click on the form, select Form
Properties, Send to other: Custom ISAPI, NSAPI, CGI, or ASP Script. Click on
Options, and set the Action to: list.asp). You need to add the criteria used
in the query page to the SQL in the list page using a WHERE clause; WHERE
(company = '::company::') company is the search field from the query page.


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Guest]

Kathleen
When you say right click on the form, which form are you talking about? I
have several different forms in various pages. Can you please be more
specific.
Thank you in advance.

 

[Kathleen Anderson [MVP - FrontPage]]

Right-click on the form in your new query page.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Guest]

Ok. How do I create the new query page?

 

[Kathleen Anderson [MVP - FrontPage]]

http://www.microsoftfrontpage.com/c...base Results with the Database Results Wizard

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Andrew Murray]

I had problems with the DIW in FP too. I found an alternative, purely
usable for updating a database online
www.1clickdb.com

Free version is available, simple to use, but only if you don't have your
customers or clients updating records, as it is not really that user
friendly to the novice web user (but fine for using as an Admin function for
the webmaster for examle).