got it
The SQL syntax looked like this:
SELECT text AS __users.name #, # __ users.id AS value
FROM INNER JOIN # # __users __user_usergroup_map
__users.id = ON # # __user_usergroup_map.user_id
WHERE # __user_usergroup_map.group_id = 24
Appears [Faculty Supervisor]
Docentes Responsáveis
http://easycaptures.com/fs/uploaded/726/7363199289.png
But the time of writing does not work, the field in the table is as int (11).
Error message appears [an error occurred]
I tried to change the SQL and field to see if it would:
Now to save as same name ...
Field in the table varchar (255)
SELECT text AS __users.name #, # __users.name AS value
FROM INNER JOIN # # __users __user_usergroup_map
__users.id = ON # # __user_usergroup_map.user_id
WHERE # __user_usergroup_map.group_id = 24
It worked ... is recording, but the error message still appears [an error occurred]
How and why I use the the error message?
Check this out ...
Select
Dynamic FREE, funcioando in SEBLOD and Free Writing Table in MySQL, but
still appears error message [an error occurred] in joomla
Check out the pictures:
http://easycaptures.com/fs/uploaded/727/8507442992.png
http://easycaptures.com/fs/uploaded/727/7896084462.pngSelect FREE Dynamic Field was thus conformed to the image:
http://easycaptures.com/fs/uploaded/727/6206156052.pngSELECT text AS __users.name #, # __users.name AS value
FROM INNER JOIN # # __users __user_usergroup_map
__users.id = ON # # __user_usergroup_map.user_id
WHERE # __user_usergroup_map.group_id = 24
And the field that refers to the table is "responsible" ...
http://easycaptures.com/fs/uploaded/727/9233089968.pngAny idea why the "error" appears in FormSeblod Select the field and also writes the Table!?
Thank you,