SQL requete

More
11 years 7 months ago #36558 by akalbs
SQL requete was created by akalbs
Hello

I have a field which has to allow me to make choose one or several values in an (exhaustive) given list.
I chose the type of field: "select multiple".
The values are in fact items of contents of the same site.

Is the request according to correct?

Selection of ID as value, the name is #_content for articles the catId of which is in the list 150 - 250, 280, 299, 305.

Thank you for your help(assistant)
Annick

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

More
11 years 7 months ago #36561 by ggppdk
Replied by ggppdk on topic SQL requete
Hello,

what is your question?

you asking for an SQL statement to achieve ... ?


-- 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 7 months ago #36566 by micker
Replied by micker on topic SQL requete
Same i moved its a question lol

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

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

More
11 years 7 months ago #36570 by akalbs
Replied by akalbs on topic SQL requete
Hello,
@Georgio :
No the question of "archives" is another problem.
Here, the need is to make fill(perform) in the creation of an item, a field which is called " real-life in ".
As a result, I am going to explain you the site which is the migration of: www.eglise-protestante-unie-car.org joomla2.5. The working site of the migration is deprived. He(it) requires one to use(wear out) at the moment and a mdp.
1) In the site, there is a part(party) which presents every parish (Where to find us?). In the new site, it is an item of contents (in the former(old) it was by the component svmap that does not exist in 2.5).
2) But there is also a part(party) which is called " box with ideas " (resources / boxes with ideas) which she(it), is completely made with flexicontent even in the former(old) site. In the index cards(forms) of the box with ideas, there is a field which is called " real-life in " and which sends back(dismisses) towards the pages of the parishes which have already lived this idea.

Thus I wonder if a request sql can create me automatically the list of my parishes, it was the purpose of my first message of this subject.
But she has to create the list of parishes and create the link which goes with to allow to send back(to dismiss) on this page. Is it possible?

@micker,
thanks, I have difficulty always a little in knowing or in asking my questions.

Thanks for all.
Annick

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

More
11 years 7 months ago #36580 by ggppdk
Replied by ggppdk on topic SQL requete
Hello,
so you want to query DB tables of the SVMAP component, someone must take time to examine the tables of it and you to describe required functionality and then create the SQL statement that you need, (i am not sure what is needed maybe you can use FLEXIcontent select field , maybe more custom code is needed, i do not know)


-- 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 7 months ago #36585 by akalbs
Replied by akalbs on topic SQL requete
Hello,

No, I do not want to make a request on SVMAP, because on the new version of the site, I do not use him(it) any more.

The information which were in SVMAP is, in the new version of the site, articles of contents Flexicontent.

I put you in MP of the codes to go to see the new site.

Thanks
Annick

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.335 seconds
Save
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