[résolu]requette SQL pour lié virtuemart

More
13 years 4 months ago #12403 by micker
[résolu]requette SQL pour lié virtuemart was created by micker
hello a tous je suis en train de finri mon intégration entre virtuemarrt et flexiconent
pour cela j'intégre un plugin simpleproduct snapshot dans un article flexicontent ca marche nikel !
le truc c'est que par id c'est pas tres élégant
je voudrais faire une requette sql qui me liste les references de virtumart...
par exemple pour lister des mp3 j'avais fait (avec l'aide de manu)
Code:
SELECT id AS value, filename AS text FROM #__flexicontent_files WHERE ext = 'mp3'
moi je voudrais lister les ref dans virtuemart
Merci d'avance pour votre aide
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
13 years 4 months ago #12407 by micker
Replied by micker on topic [résolu]requette SQL pour lié virtuemart
celle ci ne marche pas
Code:
SELECT product_sku FROM #__{vm}_product WHERE product_publish='Y'
des idées ?
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
13 years 4 months ago #12434 by micker
Replied by micker on topic [résolu]requette SQL pour lié virtuemart
hello grace a yopoyop !
voici la solution
Code:
Select product_sku as value, product_sku as text FROM jos_vm_product where product_publish='Y
bientôt un petit tuto sur les modifications à faire pour plié virtuemart à flexicontent
a+
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.

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

Last FLEXI-site

Last Faq articles

Newsletter

Last Tutos about FLEXIcontent

Login

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