[SOLVED] Updating fields in database row

OK, understood - thanks a lot!

Hi again. I've been struggling with this since my last reply - I've replaced the DATE_FIELD_NAME and CARER_FIELD_NAME with the correct field names, but the Query Field is not showing in the tab at all unless I remove the WHERE FIND_IN_SET condition.

In the sql:- WHERE FIND_IN_SET( `id`, REPLACE( '[CARER_FIELD_NAME]', '|*|', ',' ) ) > 0 can you tell me what id the `id` is expecting to find as I have a feeling that I might not be capturing the id correctly?

Thanks for any help you can bring, as I can understand this is really outside of basic CB support.

Strongly suggest using the Code field usage. The SQL usage isn't efficient SQL (there's no way to make it efficient due to how multi-selects are stored). Code usage is in my below reply.

www.joomlapolis.com/forum/153-professional-member-support/241916-updating-fields-in-database-row?limitstart=0#315832

Thanks. I should have said that I also tried the code usage, but it comes up with a blank result as well (just a "-").

I am allowing the selection of the Carer name by using this query - could that be causing a problem?

SELECT CONCAT (firstname,' ',lastname) FROM `#__comprofiler` WHERE `cb_shac_role` LIKE '%Befriender%' OR '%Office|*|Befriender%'

Yes, that'd be a problem as you're doing selection based off first and last name. The code examples I've provided are using their user id. You should not be storing the selection in the database by first and last name as name is not unique so you could have 5 people with the same name for example. I suggest changing your query select to use the following.

Query: Value Column: id
Label Column: name

Note all existing selections for that field will lose their values and need to be re-selected. This will then store by id and allow the code examples I've provided you to work fine.

Oh, thanks so much again - will give that a try. Guidance much appreciated!!