Frontpage 2003 DataBase Edit Question

[Guest]

Using DBW I have created a functional database I can edit, but what if you
have a Database of 10,000 records and need to search for just one
record(direct search and edit). I know I need a form, but how do I make that
form search for a specific record, then give the option to edit.

Thanks

 

[Guest]

Hey you are like the only person in the world that can get the database to
edit. HELP how did you do it?

 

[Kathleen Anderson [MVP - FrontPage]]

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/

 

[Guest]

I am trying to get my database records editable. I have created the entry
form, and was successful at creating a search page to post my results in a
results table. I have been TRYING to follow Kathleen's instructions below,
but I must be missing something. I cannot get the 'searched for' record to
display in the form to edit it. The form itself displays, due to modifying
the the Action field, but it comes up blank. If I leave the result table on
the form, I can see my search is finding the record.

So, how do I get the record fields to display in the form fields to be
editable? I am not understanding Kathleen's instruction: "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.", since my list page (I am assuming this means my entry form page) does not contain SQL to edit? What am I missing?

Any assistance would be appreciated.

Thank you!
Theresa

 

[Kathleen Anderson [MVP - FrontPage]]

Hi Theresa:
The "list" page refers to the list.asp page that's created when you use the
Database Interface Wizard. IIRC, list.asp displays all the records in the
database, and provides a checkbox for you to select the record you want to
edit, which then passes you off to edit.asp. The SQL is a way to cut down on
the number of records displayed on list.asp, by acting on search fields
passed from a query page.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Guest]

Thank you Kathleen. After posting that, I visited your website and learned
how to use the Database Interface Wizard. I think I am on track now...
Making progress anyway. Thank you very much for your response, and for
your informative website!

Theresa

 

[Kathleen Anderson [MVP - FrontPage]]

You're welcome - and thanks

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Guest]

I have added a field to my database, and am able to see it everywhere except
list.asp. I know the proper procedure is to run the Database Results wizard
and add the field, but when I run/finish the wizard on the list.asp page, the
Checkbox that allows me to select a record for edit immediately disappears.
How can I update the database results region to display the new field without
losing my edit checkbox?

Any help would be most appreciated! Thanks, Theresa

 

[Kathleen Anderson [MVP - FrontPage]]

Theresa:
Try making a copy of list.asp and save the copy. Then rerun the wizard on
list.asp, when it's done copy the checkbox code from the copy back into
list.asp.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/