MySQL Field Type Plugin

I am not a SQL pro... but doesn't "CONCAT" just allow 2 arguments? There is another syntax for multiple... please have a look here .

pepperstreet wrote: I am not a SQL pro... but doesn't "CONCAT" just allow 2 arguments? There is another syntax for multiple... please have a look here .

from your link!

CONCAT(string1, string2, string3, ...)

Thanks for replies

We found the solution after realising that we did not need to include AS in the code. Also, as pepperstreet pointed out, CONCAT only needed two arguments. Fortunately the client only wanted a mean average. So in case this helps others, here is the final code we used, and it works perfectly...

SELECT CONCAT(DATE_FORMAT(FROM_UNIXTIME(date_submitted),'%d/%m/%Y'),' - ',(ROUND(((score_a+score_b+score_c+score_d+score_e+score_f+score_g)/7),2)))
FROM rms_ind_scores
WHERE username = {USERID} AND rms_ind_scores.storeid IN (SELECT DISTINCT store_id FROM rms_users LEFT JOIN rms_user_usergroup_map ON rms_users.id = rms_user_usergroup_map.user_id LEFT JOIN rms_clients ON rms_user_usergroup_map.group_id = rms_clients.usergroups_id LEFT JOIN rms_stores ON rms_clients.client_id = rms_stores.client_id WHERE rms_user_usergroup_map.user_id = {VIEWERID} AND store_id IS NOT NULL)
ORDER BY date_submitted DESC
LIMIT 0, 3

Thanks for the help

This plug-in looks amazing. I've been trying to get it running on my site, with no success - the field does not even show.

Does anyone know if it works with CB 1.7.1? (I assume it does since this thread is still so active - but confirmation would help me persist here!)

Thanks

Hi there,

The site I am using it on is 1.7.3

Hope this helps

Thanks! Sorry - I should have been more clear. I'm on Joomla 1.5, CB 1.7.1.