[SOLVED] Query to calculate 2 delimiter fields.

I would like to add 2 fields together for example:

cb_number01 + cb_number02

and I have done so using a query:

SELECT TRUNCATE(cb_number01+cb_number02,2) FROM #___comprofiler WHERE id=[user_id]

It did not work but I believe that the challenge here is that cb_number01 and cb_number02 are delimiter field containing some conditions below:

cb_number01 contains the following:

[cb:if cb_age1>=0 and cb_age1<=20]-30[/cb:if]
[cb:if cb_age1>=21 and cb_age1<=50]50[/cb:if]
[cb:if cb_age1>=51]80[/cb:if]

cb_number02 contains the following:

[cb:if cb_age2>=0 and cb_age2<=20]-30[/cb:if]
[cb:if cb_age2>=21 and cb_age2<=50]50[/cb:if]
[cb:if cb_age2>=51]80[/cb:if]

How do i add cb_number01 and cb_number02? Do I a query or I can use another delimiter to add this fields together?

Or the auto action field function would be able to handle this.

Basically, what I am trying to do is to add a few delimiter fields with cb:if condition together..

If I can put in mathematical functions formula in the delimiter fields, it will solve my problem.. so far I am trying the following (below) but it is not working..

[cb_number01]+[cb_number02]

It shows the cb:if value with the "+" in between..

Your table had 1 too many _ (3) as it should be #__ (2). You probably also need to substitution your 2 fields instead of calling from database as a database entry doesn't exist for delimiter fields. Try the below.

Ensure debug mode is enabled and maximum error reporting is set within Joomla global configuration during all tests so you can see if a fatal SQL error occurs.

I guess as much that delimiters do not exist database entry..

I might have to use the auto action to get these results..

Anyway, can i create another delimiter field and add 2 other delimiter fields?

Anyway, can i create another delimiter field and add 2 other delimiter fields?

No, there is no math based substitutions. You can have a 3rd delimiter render the 2 delimiters, but it won't add them together. You should do all your math inside of the SELECT query. Example as follows.

Perhaps the CB team good work on a field delimiter plugin which could do that.. I think that it will be a powerful tool.. thanks for the support!