• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Mapping - can this be done?

Mapping - can this be done? 4 years 5 months ago #40762

  • iceferret
  • iceferret's Avatar
  • OFFLINE
  • Gold Boarder
  • Posts: 246
  • Thank you received: 64
I have a membership renewal form that maps members' data to table 1, occasionally they add other members of their household to the form which adds the new entries to table 2. As there is no existing data in table 2 it can't be updated so requires manual entry. This is not a problem for the times it comes up but I wondered if there was a way of implementing an INSERT ... ON DUPLICATE KEY UPDATE query as table 2 contains a unique member id number for the WHERE clause
If you can keep your head when all about you are losing theirs, then you obviously don't understand the situation!
The administrator has disabled public write access.

Mapping - can this be done? 4 years 5 months ago #40768

  • iceferret
  • iceferret's Avatar
  • OFFLINE
  • Gold Boarder
  • Posts: 246
  • Thank you received: 64
The answer is yes it can
I spotted REPLACE in the mapping choices which achieves the same ends but is not mentioned in the documentation. After some careful testing it works perfectly
If you can keep your head when all about you are losing theirs, then you obviously don't understand the situation!
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!