pages created by Database interface wizard don't give me edit func

[A. M. Schaer]

In FrontPage 2003 The database interface wizard doesn't seem to be creating a
page that will let me select a record to edit. I see buttons for deleting
records but no way to select an existing record and edit it.

I tried to do it manually by making the name column a link that would pass a
query string to the detail page, but I get "no records returned"

Why doesn't the *$(#(^^$^@ Wizard work in the first place and what can I do
to fix it?

Or if I have to do this manually, what am I doing wrong?

Here is the first part of the link I am using
<a target="detail" href="detail.asp?Name=<%=FP_FieldURL(fp_rs,"Name")%>">

Unfortunately I can't give you the url to the database pages, because the
database contains confidential data and is housed on a secure server

 

[Thomas A. Rowe]

1st, don't use Name as field name or as a variable.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Jim Buyens]

The database interface wizard has been troublesome ever since FrontPage 2002
SR2. Basically, Microsoft put in some security fixes that interfered with
inserts, updates, and deletes.

You may have better luck running the ASP.NET version. Otherwise, some people
have success replacing certain .inc files with pre-FP2002SR2 versions. I have
trouble recommending this second solution, however, because it involves
re-opening a fixed security hole.

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)
|/----------------------------­-----------------------
*-----------------------------­-----------------------

 

[Kathleen Anderson [MVP - FrontPage]]

The database_editor.asp is used to edit existing records. Put a checkmark in
the checkbox next to the record you want to edit, and click the field that
is hyperlinked; usually the ID field. It would be helpful if there was a
button for Edit a Record, but there isn't.