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
INSERT, UPDATE & DELETE records in multiple tables.
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/
Comments
IE Error when running the insert Stored Procedure...
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
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
Well explained and useful article. Thanks
You must me logged in to write a comment.