[solved]virtuemart integration sql request

micker
Topic Author
Offline
Administrator

13 years 4 months ago #12402 by micker

[solved]virtuemart integration sql request was created by micker

hello
i finish my virtuemart integration with flexicontent
i use simple product snapshot to insert add to cart buton on my article
somebody can help my to do a reqest to do an field to list product by ref ?
for mp3 i sue this

Code:

SELECT id AS value, filename AS text FROM #__flexicontent_files WHERE ext = 'mp3'

how to select product by ref field on virtuemart ?
Thanks

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.

micker
Topic Author
Offline
Administrator

13 years 4 months ago #12406 by micker

Replied by micker on topic [solved]virtuemart integration sql request

this doesn't work

Code:

SELECT product_sku FROM #__{vm}_product WHERE product_publish='Y'

any idea ?

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

micker
Topic Author
Offline
Administrator

13 years 4 months ago #12415 by micker

Replied by micker on topic [solved]virtuemart integration sql request

this

Code:

Select product_sku as sku FROM jos_vm_product where product_publish='Y'

works to load field but nothing inside this list ...
somebody can help me ?
Thanks

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

yopyop001
Offline
Moderator

13 years 4 months ago #12432 by yopyop001

Replied by yopyop001 on topic [solved]virtuemart integration sql request

Hey,

May be :

Code:

Select product_sku as value, product_sku as text FROM jos_vm_product where product_publish='Y'

Regards

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

micker
Topic Author
Offline
Administrator

13 years 4 months ago #12433 by micker

Replied by micker on topic [solved]virtuemart integration sql request

perfect thanks !!!!!
je pense que quand j'aurais fini je ferai un tuto sur une intégration possible avec virtuemart ! de bout en bout
Mille merci mon sauveur !

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