Database update and delete in ASP

[Mettá]

In the good old days these worked within a custom DRW

DELETE DISTINCT from tTable
WHERE ID=::ID:: and fieldx='::fieldx::'


UPDATE tTable
Set
add1='::add1::',add2='::add2::',from1=#::from1::#,to1=#::to1::#,approve='::approve::'
WHERE ID=::ID:: and fieldx='::fieldx::'


ID is record id and fieldx is a text field, I know I could use just ID but
for added protection I always add another field to an update or delete
query.

I have a feeling that the updates to FP and IIS etc from MS which have
caused all sorts of database problems are the cause, but can someone tell me
how to get update and delete queries to work?

Thanks
M

 

[Guest]

To plug some security holes, Microsoft applied service pack
changes to FrontPage 2002 (and carried them over to FrontPage
2003) that inadvertently interfered with the use of INSERT, UPDATE,
and DELETE statements in the ASP version of the Database Results Wizard.

The files affected are FPDBRGN1.ini, FPDBRGN2.ini, and FPDBLIB.ini.
The contain model statements that FrontPage converts to
FPDBRGN1.inc, FPDBRGN2.inc, and FPDBLIB.inc the first time you run
the DRW in a Web site. So, one fix (although a poor one) is to get
the FP2000 or original FP2002 (non-service pack) version of these
files. The problem with this, of course, is that you re-introduce
the security holes.

As a result, you'll probably have greater success using the ASP.NET
version of the DRW, or writing your own ASP code.

Writing your own ASP code for inserting records isn't
difficult. Try the advice at:

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

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

 

[Guest]

Hi Jim.

I am trying to UPDATE a database using the DRW FP2003 with ASP. I see that
there is a problem with this and as you suggest I want to try using ASP.NET

However the DRW in asp.net gives me a functioning results form does NOT have
a Submit or Update button. What do I need to do to get an update option with
the DRW using ASP.NET?

Thanks for your input,
EdH