MySQL Field Type Plugin

Hello,
there are also two SQL related incubator fields... are there any pros and cons? What are the differences or benefits?

I am trying to read from extenral ms sql database table, is it possibly to modify the plugin to read to this table??

I got a unique selection of table and wanted to show this field in a list of users. She no longer works in 1.3.1 using PHP5.3. An installation with 5.2.9 is still working.

I would really like this feature as well. Get my vote as a vice function to added.

Thanks - ZF

There is an sql error when I attempt to open User Manangement Tab.

From the tools section, found this:

There are 2 column(s) missing in the comprofiler table, which are defined as fields (rows in comprofiler_fields):

- Field cb_make - Column cb_make is missing from comprofiler table.

- Field cb_country - Column cb_country is missing from comprofiler table.

This one can be fixed by deleting and recreating the field(s) using components / Community Builder / Field Management.
Please additionally make sure that columns in comprofiler table are not also duplicated in users table.

This is a great addition to CB

I am using Joomla 1.7 with CB 1.7 and I have 2 fields using this plugin.

The first field is a simple single result and works just fine...

SELECT CONCAT ('User ID',' ',id)
FROM #__users
WHERE id = {USERID}

The second is a more complex multiple result and doesn't appear to work at all....

SELECT CONCAT(DATE_FORMAT(FROM_UNIXTIME(date_submitted),'%d/%m/%Y'),' Time Keeping = ',score_a,' Appearance = ',score_b,' Accuracy = ',score_c,' Productivity = ',score_d,' Follow Instructions = ',score_e,' Client Knowledge = ',score_f,' Interaction = ',score_g) AS 'detail'
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

We have also tried substituting #__ for the prefix rms_ but get no results displayed.

Any suggestions would be appreciated.