Front Page database Editior

  • Thread starter Thread starter Charlotte Kleinfeld
  • Start date Start date
C

Charlotte Kleinfeld

The Front Page 2002 SP-1 interface for an Access database works fine, except
for one thing; you can not have criteria for selection of records in the
editor.

Is there any way to have selection criteria, as you can have on a normal
results page?
 
No, not in FrontPage.

Depending on your requirements, you may have some luck creating a query in
access, and then running the DB Interface wizard against the query.

The query SQL would be something like:

SELECT * FROM mytable WHERE isactive = true;

But if you're trying to do something like each of many people being able to
update just their own records, you'd have to write custom pages in ASP.NET or
ASP.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------
 
Hi Charlotte:

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.

HTH,
 
Back
Top