INSERT, UPDATE & DELETE records in multiple tables.

Using Dreamweaver's standard insert, update, and delete server behaviours you can't modify records in multiple database tables using input from a single form. This article shows how to use the Command behaviour which enables you to do this. This is essential if you need to modify records in separate database tables and maintain relationships between them.

http://www.drdev.net/article01.htm

Owen Eastwick

I have over a dozen years experience in the IT industry and in the past 5 I have focussed exclusively on web site design and development. I'm familiar with all aspects of web site design from planning through to launch. I specialise in developing dynamic, ASP/VBScript web sites utilising either a Microsoft Access or a SQL Server database back end. I also create logos, artwork and design web site interfaces so I am able to develop a complete web site from “front-end” through to “back-end” if required.

In addition to developing sites directly for clients I also undertake sub-contract projects developing ASP and database solutions for other web site designers. If you've got a rush job and a fast approaching deadline or you've simply reached a seemingly impassable sticking point within a project, get in touch.

Check out my sites for more information:

http://www.drdev.net/
http://www.tdsf.co.uk/

See All Postings From Owen Eastwick >>

Comments

IE Error when running the insert Stored Procedure...

December 2, 2003 by ben dykes

Has anyone seen or know a reason for the following error when loading an asp page that uses a Stored Prcedure to INSERT data into a DB?

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/fusion/asp/cust_detail_location_add.asp, line 17

line 17 is the last line of the command code:

insertCustID.Execute()

Any ideas / help would be appreciated.  Jet drivers are up and running and this error is starting to hurt my head!

Cheers

Ben

where is the form supposed to post to

June 16, 2004 by John Moen

Is there a way to post a re-diredt page as well??

I am getting an error "Data type mismatch in criteria expression"  My data types are fine, and equal to what they are supposed to be.

Has anyone else seen this error type.

If anyone is listening....I can post my code too.

Thanks!

Well Explained and Useful

April 4, 2005 by Elizabeth Martinez

Well explained and useful article. Thanks

You must me logged in to write a comment.