Using INSERT with Multiple Tables

[Tim Mannah]

After seeing different tutorials I have reached the conclution to hand code
the insert page on my site since it has to update mutliple tables something
that is hard to do with a server behaviour.

I have a main table with data in it called tbMembers containing heaps of
personal data.
I have a second table called tbMembersExtra containing other member relevant
data.

tbMembers has a primary key called SysMemId
tbMembersExtra has a primary Key called MemExtraID and foreign key called
SysMemId.

The data i want to insert is stored in session variables and NOT a form.

Some data belongs in one table the rest in the other.

Do i really have to have separate SQL insert statements to cater for this or
can it be done using one SQL insert statement. I obviously want to store the
relevant data without losing the relationship.

Can someone put me on the right track for doing INSERTS as mentioned above
into different tables?

Thanks.

[Paul Whitham TMM]

You have to construct an insert statement for each table. The exact code
will depend upon the server language being used

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Tim Mannah" <timm@diabetesnsw.com.au> wrote in message
news:d5rljp$i72$1@forums.macromedia.com...

> After seeing different tutorials I have reached the conclution to hand

code

> the insert page on my site since it has to update mutliple tables

something

> that is hard to do with a server behaviour.
>
> I have a main table with data in it called tbMembers containing heaps of
> personal data.
> I have a second table called tbMembersExtra containing other member

relevant

> data.
>
> tbMembers has a primary key called SysMemId
> tbMembersExtra has a primary Key called MemExtraID and foreign key called
> SysMemId.
>
> The data i want to insert is stored in session variables and NOT a form.
>
> Some data belongs in one table the rest in the other.
>
> Do i really have to have separate SQL insert statements to cater for this

or

> can it be done using one SQL insert statement. I obviously want to store

the

> relevant data without losing the relationship.
>
> Can someone put me on the right track for doing INSERTS as mentioned above
> into different tables?
>
> Thanks.
>
>
>

[Alexandru COSTIN]

Hi,
We have included this functionality in MX Kollection 3 - that is in
beta right now. So - it's possible with server behaviors.

If you want to take part in the beta - just contact me at
[email]acostin@interaktonline.com[/email] and I will register you in about one week.

Alexandru

Tim Mannah wrote:

> After seeing different tutorials I have reached the conclution to hand code
> the insert page on my site since it has to update mutliple tables something
> that is hard to do with a server behaviour.
>
> I have a main table with data in it called tbMembers containing heaps of
> personal data.
> I have a second table called tbMembersExtra containing other member relevant
> data.
>
> tbMembers has a primary key called SysMemId
> tbMembersExtra has a primary Key called MemExtraID and foreign key called
> SysMemId.
>
> The data i want to insert is stored in session variables and NOT a form.
>
> Some data belongs in one table the rest in the other.
>
> Do i really have to have separate SQL insert statements to cater for this or
> can it be done using one SQL insert statement. I obviously want to store the
> relevant data without losing the relationship.
>
> Can someone put me on the right track for doing INSERTS as mentioned above
> into different tables?
>
> Thanks.
>
>
>

--
InterAKT Online - Dreamweaver extensions
[url]http://www.interaktonline.com/[/url]

[Julian Roberts]

I've an article on the subject that may be useful

[url]http://www.charon.co.uk/content.aspx?CategoryID=27&ArticleID=47[/url]

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Glitch808]

I recommend using the Insert Behavior, then passing all the form values in a
session variable to a second page.
Then on the second page populate hidden form fields with the session
variables. Use the same insert behavior for the 2nd table you want to insert
to.

Here?s the page to explain the set up to pass the session variable:
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_16516[/url]

Here?s what you need to auto submit the form.
<body onLoad="document.forms[0].submit()">