Acajoom SQL Integration

14 years 2 months ago #121150 by nant
Replied by nant on topic Re:Acajoom SQL Integration
coachnet wrote:

Thanks for that.

I've just test the activation code and it didn't work for me. The code on this topic didn't work for me either.

I've just copied and pasted the code as is into the SQL Action tab for the appropriate plan and substituted <listid> with 2.

I notice there are some spaces before and after some of the (), symbols... can't this be a problem?


Sorry, should have tested better before I posted.

Think I fixed it - please use updated statements in first post.

Please Log in to join the conversation.

14 years 2 months ago #121212 by ThePiston
Replied by ThePiston on topic Re:Acajoom SQL Integration
that code looks different from the official Acajoom SQL code I posted here: www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/id,118827/catid,90/limit,6/limitstart,12/

Nant, can you decipher what the differences are?

CB 2.3, CBsubs 4.3, PHP 7.1, J! 3.9.X

Please Log in to join the conversation.

14 years 2 months ago #121219 by nant
Replied by nant on topic Re:Acajoom SQL Integration
ThePiston wrote:

that code looks different from the official Acajoom SQL code I posted here: www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/id,118827/catid,90/limit,6/limitstart,12/

Nant, can you decipher what the differences are?


Sure, if you tell me what "official" means?

Please Log in to join the conversation.

14 years 2 months ago #121220 by ThePiston
Replied by ThePiston on topic Re:Acajoom SQL Integration
they have a page on their site that lists SQL actions for integration into 3rd party components:
www.ijoobi.com/help/acajoom/sql-queries.html#integrate

Post edited by: ThePiston, at: 2010/01/08 17:58

CB 2.3, CBsubs 4.3, PHP 7.1, J! 3.9.X

Please Log in to join the conversation.

14 years 2 months ago #121222 by nant
Replied by nant on topic Re:Acajoom SQL Integration
ThePiston wrote:

they have a page on their site that lists SQL actions for integration into 3rd party components:
www.ijoobi.com/help/acajoom/sql-queries.html#integrate

Post edited by: ThePiston, at: 2010/01/08 17:58


hmmm, ok need to study this further.

Please Log in to join the conversation.

14 years 2 months ago #121371 by coachnet
Replied by coachnet on topic Re:Acajoom SQL Integration
nant wrote:

Sorry, should have tested better before I posted.

Think I fixed it - please use updated statements in first post.


Unfortunately still not working. Could it be a problem that I have the plan set up to require approval? Does the SQL Action run before or after the approval?

I have checked both before and after I approve the subscription and the user is still not subscribed to the Acajoom list.

Renee Hasseldine
CoachNetwork Founder
Life Coaches | Business Coaches | Executive Coaches

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.301 seconds