Help simple query

More
11 years 9 months ago #40007 by brandonking
Help simple query was created by brandonking
In content TYPE A, there is a select field, I want to populate TYPE A text field's value into TYPE B select field. Let's say there are 10 articles in TYPE A, means 10 text field's values.

Can you please give me sample SQL query?

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

More
11 years 9 months ago #40008 by ggppdk
Replied by ggppdk on topic Help simple query
Hello,

what matter is the field id of the text field
Code:
SELECT DISTINCT value, value as text FROM #__flexicontent_fields_item_relations WHERE field_id=57

-- 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.

More
11 years 9 months ago #40009 by brandonking
Replied by brandonking on topic Help simple query
Thank you very much.

I want to add one more condition in WHERE clause, if radio field is yes or no.

Thank you again.

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

More
11 years 9 months ago #40012 by ggppdk
Replied by ggppdk on topic Help simple query
Hello,

which radio field ?

you spoke of a text field

so what does this mean :

brandonking wrote: I want to add one more condition in WHERE clause, if radio field is yes or no.


-- 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.

Moderators: vistamedia, joomlacorner, ggppdk
Time to create page: 0.377 seconds

Last FLEXI-site

Last Faq articles

Newsletter

Last Tutos about FLEXIcontent

Login

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Save