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

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!" (-;
_____________________________________________


"RWS Fl" <(E-Mail Removed)> wrote in message news:5A5C26BC-1EEC-48EB-B3DB-(E-Mail Removed)...
|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

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


"RWS Fl" <(E-Mail Removed)> wrote in message
news:5A5C26BC-1EEC-48EB-B3DB-(E-Mail Removed)...
>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
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.
--
RWS FLorida


"Kathleen Anderson [MVP - FrontPage]" wrote:

> 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
>
>
> "RWS Fl" <(E-Mail Removed)> wrote in message
> news:5A5C26BC-1EEC-48EB-B3DB-(E-Mail Removed)...
> >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
>
>
>

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


"RWS Fl" <(E-Mail Removed)> wrote in message
news:CEE6A069-730A-457E-AEB1-(E-Mail Removed)...
> 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.
> --
> RWS FLorida
>
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
>> 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
>>
>>
>> "RWS Fl" <(E-Mail Removed)> wrote in message
>> news:5A5C26BC-1EEC-48EB-B3DB-(E-Mail Removed)...
>> >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
>>
>>
>>

Ok. How do I create the new query page?
--
RWS FLorida


"Kathleen Anderson [MVP - FrontPage]" wrote:

> 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
>
>
> "RWS Fl" <(E-Mail Removed)> wrote in message
> news:CEE6A069-730A-457E-AEB1-(E-Mail Removed)...
> > 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.
> > --
> > RWS FLorida
> >
> >
> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >
> >> 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
> >>
> >>
> >> "RWS Fl" <(E-Mail Removed)> wrote in message
> >> news:5A5C26BC-1EEC-48EB-B3DB-(E-Mail Removed)...
> >> >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
> >>
> >>
> >>
>
>
>

http://www.microsoftfrontpage.com/co...sults%20Wizard

--

~ 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


"RWS Fl" <(E-Mail Removed)> wrote in message
news:EBDCDA1E-A48B-48CC-B9D2-(E-Mail Removed)...
> Ok. How do I create the new query page?
> --
> RWS FLorida
>
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
>> 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
>>
>>
>> "RWS Fl" <(E-Mail Removed)> wrote in message
>> news:CEE6A069-730A-457E-AEB1-(E-Mail Removed)...
>> > 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.
>> > --
>> > RWS FLorida
>> >
>> >
>> > "Kathleen Anderson [MVP - FrontPage]" wrote:
>> >
>> >> 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
>> >>
>> >>
>> >> "RWS Fl" <(E-Mail Removed)> wrote in message
>> >> news:5A5C26BC-1EEC-48EB-B3DB-(E-Mail Removed)...
>> >> >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
>> >>
>> >>
>> >>
>>
>>
>>

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).



"RWS Fl" <(E-Mail Removed)> wrote in message
news:5A5C26BC-1EEC-48EB-B3DB-(E-Mail Removed)...
>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