Update or delete db records with ASP and .net

[Guest]

I created a form that will update or delete a record using ASP and FrontPage 2002. This worked fine until I loaded the .Net framework 1.1 on my Win 2K server. Now when a user tries to delete a record or perform an update of a record the following error is given

Your page contains a query with user input parameters that could not be resolved
This could happen if your DatabaseRegionStart webbot has an empty or missing s-columnnames or s-columntypes attributes
You may need to read Microsoft Knowledge Base Article 817029

This article only refers to how to fix the problem in FrontPage 2003. What do we do to fix the error for those of us who have not updated to FP 2003

 

[Jim Buyens]

I believe the six-step fix at the end of the article will
work in FP2002 as well.

Alternatively, you could just code the whole page by hand,
which probably involves less code than you think. To get
started, browse:

Saving Form Data in a Database
http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=44


Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| 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)
|/---------------------------------------------------
*----------------------------------------------------

-----Original Message-----
I created a form that will update or delete a record

using ASP and FrontPage 2002. This worked fine until I
loaded the .Net framework 1.1 on my Win 2K server. Now
when a user tries to delete a record or perform an update
of a record the following error is given.

Your page contains a query with user input parameters that could not be resolved.
This could happen if your DatabaseRegionStart webbot has

an empty or missing s-columnnames or s-columntypes
attributes.

You may need to read Microsoft Knowledge Base Article 817029.

This article only refers to how to fix the problem in

FrontPage 2003. What do we do to fix the error for those
of us who have not updated to FP 2003?