CB Query Field

hi,

I just bought the QueryField plugin, I did a test to copy a field in another:

1. on my 'drop down_single' field I add the UPDATE query, the request that copies the selection to another field; in 'integration' part of 'drop/down(unique)' selection (cb_thisfield) , I activated the Query Validation :

UPDATE `#_comprofiler` SET `cb_field` = `cb_thisfield`

But when I edit a user to change the selection of the fields (for testing), the copy is done on other users but not on the one I edited / saved and closed (I purged the cache, refresh.. but nada with the one I edited )


Thank you in advance for your answer

CB Query Field is for SELECT queries. It is not for updating anything. If you want to update on various criteria you need CB Auto Actions and its Query action. CB Query Field simply displays the results of an SQL query, it can validate a field based off an SQL query, or build a dropdown list of options based off an SQL query. In no usecase should you be performing an update query from CB Query Field.

damn! I bought the wrong plugin :dry:

However, you and nant, advised me to buy the 2 plugins including this one,

Kyle mentioned:
CB Query Field:
www.joomlapolis.com/addons/cb-query-field
and CB Code Field:
www.joomlapolis.com/addons/cb-code-field

i think you are familiar with my pb now , I can not afford to buy all the plugins
so please, are you sure that the one you just mentioned

CB Auto Actions

will do the job????


:huh: So.

You were advised below that you can query for or use PHP to parse out the last value of a multiselect or multicheckbox field using CB Query Field (SQL) or CB Code Field (PHP). What you're trying to do is not that. You are trying to COPY the entire value of 1 field to another in which case you were advised you would need CB Auto Actions to do (or possibly need both CB Auto Actions and CB Query/Code Field). This is all stated below in your topic.

www.joomlapolis.com/forum/146-general/237533-copy-record-fields?start=12#298072

Use the below query to do what you're wanting in a Query fieldtype to extract the last value of a multiselect or multicheckbox field. No this won't copy it and it won't be stored in the database. It'll be visible on their profile and that's it (it can not be searched either).