close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Only 1 MRT data inserting

Thread began 4/05/2010 12:54 am by Russell Collins | Last modified 4/09/2010 8:15 pm by Eric Mittman | 1109 views | 10 replies |

Russell CollinsBeta Tester

Only 1 MRT data inserting

Hi,

I'm having a problem using more than 1 MRT on a page.

I can only get the data from no more than one MRT inserting.

I have the redirect url set to the last instance of the mrt but make no difference.
It seems only the MRT behaviour with the redirect applied is the one that will insert.

Any ideas ?

Regards

Russ

Sign in to reply to this post

Eric Mittman

Are the triggers all set the same way? What happens if you comment out the last one and specify a redirect on the next one up? If the triggers are the same the other ones should be firing. If you comment out the last one and put the redirect on the second to the last one it should let you know if it is being triggered independently or not.

Sign in to reply to this post

Russell CollinsBeta Tester

Here is a test page with problem

Hi Eric,

Here is a page I have been testing, only the second instance inputs.

Regards

Russ

Attached Files
mrt_test.zip
Sign in to reply to this post

Eric Mittman

Thanks for the file, it looks like you have the same trigger for both of these MRT server behaviors. I did not see a redirect for either one of them though. What happens if you specify different redirects for both of these server behaviors? Just looking at the code on the page I'm not sure why one would be working but not the other. To test it out I would need a copy of your db as well.

Have you tested this with the different redirects and commenting out one then the other? Please post back with what you discover and the results you are getting.

Sign in to reply to this post

Russell CollinsBeta Tester

2 mrt's into the same database

Eric,

Should 2 MRT's applied to the same page be able to insert into the same database ?

Regards

Russ

Sign in to reply to this post

Eric Mittman

Yes, you can have more than one MRT on a single page and have both of them insert into tables in your db. Were you able to discover anything by testing out the MRTs' on the page? If you are only getting records inserted into one of the tables there must be something on the page that is preventing the other one from triggering, or makes it look like it it not triggering. If you test one then the other you should have a better idea about how it is currently working.

Sign in to reply to this post

Russell CollinsBeta Tester

same table

Sorry Eric,

i was meant to say into the same table of a db

Russ

Sign in to reply to this post

Russell CollinsBeta Tester

Here are my testing pages & db

Hi Eric,

here are my testing pages and db.
I have place a session variable bound to the contactID on the insert form as a substitute for the idPEOPLE session variable from the main table I'm using in my main system.

I'm at a complete loss over this now.

I am wanting to manage 3 address per contact.
Maybe I'm attempting this this the wrong way.

Regards

Russ

Attached Files
mrt test folder.zip
Sign in to reply to this post

Eric Mittman

Thanks for posting back with that, it is very helpful. I was able to craft a page almost just like yours and here is what I have found.

If you have the same $WA_masterKeyValue set for both MRTs then it will only do one of them. I was able to reproduce this and confirm the result. The way around this was to use a different id for the $WA_masterKeyValue in the second MRT and it worked like I thought it should.

I'm not sure that I fully understand what you are trying to accomplish as an end result with the data in the pages that you posted, but if you are only adding records for a single contact then you should only need to have one MRT. You should only have mutiple MRTs if you have multiple master key values to manage with additional records.

Sign in to reply to this post

Russell CollinsBeta Tester

Additional tables

Thanks for that Eric,

My idea was to be able to have 3 addresses for each contact, and manage those with the mrt insert, update.

So I understand now that is not possible if I use the same masterkey, that being the contactID..

Given that, should I add 2 additional tables to incorporate those extra addresses ?
or incorporate an additional relational table as in

1. contact has addresses
2. addresses has type

or some other way


Regards

Russell

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...