SQL and CHECKBOX

igcorreia
Topic Author
Offline
Platinum Member

12 years 5 days ago - 12 years 5 days ago #31955 by igcorreia

SQL and CHECKBOX was created by igcorreia

Please consider adding the SQL field to the checkbox plugin.

Can't belive I never need this until today.

PS: this request comes from a client using J1.5 in FLEXIcontent version 1.5.6 beta2 (r948)

Last edit: 12 years 5 days ago by igcorreia.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 5 days ago #31960 by ggppdk

Replied by ggppdk on topic SQL and CHECKBOX

Code of all indexable field is now unified in most of its parts,

So i ll add parameters:
trigger content plugins, remove space, field open Text, field closing Text, SQL mode
to fields:
radio, radioimage, checkbox and checkboximage

and value prefix, value postfix to checkbox, checkboximage only

To test this now:

1. add the parameter to checkbox.xml file:

Code:

<param name="sql_mode" type="radio" default="0" label="FLEXI_FIELD_SQL_MODE" description="FLEXI_FIELD_SQL_MODE_DESC">
	<option value="0">FLEXI_NO</option>
	<option value="1">FLEXI_YES</option>
</param>

to checkboximage.xml

2. Just now you need to add one more column to SELECT SQL statement the 'image' column which is the image file!!:

-- So enable the new parameter and in "field elements" textarea enter:
SELECT col1 AS value, col2 AS text, col3 AS image FROM myDBtbl

Regards

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.