Feeds Query
- Andre Chernyshev
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 3
- Thank you received: 0
6 years 7 months ago #6673
by Andre Chernyshev
Feeds Query was created by Andre Chernyshev
Is there an example or guide to see feeds query? what kind of syntax it uses and stuff like that just using regular SQL query produces error.
SELECT jos_melsongs.id, jos_melsongs.name, jos_melsongs.audio_folder, jos_melsongs.dur_hrs,jos_melsongs.dur_mins, jos_melsongs.dur_secs, jos_melfilepath.folder FROM jos_melsongs JOIN jos_melfilepath ON jos_melsongs.audio_folder=jos_melfilepath.id ORDER BY jos_melsongs.id DESC LIMIT 50
{"result":"error", "error":"Table '{table omited}.#__melsongs join' doesn't exist"}
SELECT jos_melsongs.id, jos_melsongs.name, jos_melsongs.audio_folder, jos_melsongs.dur_hrs,jos_melsongs.dur_mins, jos_melsongs.dur_secs, jos_melfilepath.folder FROM jos_melsongs JOIN jos_melfilepath ON jos_melsongs.audio_folder=jos_melfilepath.id ORDER BY jos_melsongs.id DESC LIMIT 50
{"result":"error", "error":"Table '{table omited}.#__melsongs join' doesn't exist"}
Please Log in to join the conversation.
6 years 7 months ago #6675
by Daniel
Thanks
Daniel
Replied by Daniel on topic Feeds Query
Hi,
You just need to use #__tablename instead of jos_tablename. If the query runs in PhpMyAdmin, it should run in vData as well.
You just need to use #__tablename instead of jos_tablename. If the query runs in PhpMyAdmin, it should run in vData as well.
Thanks
Daniel
Please Log in to join the conversation.