This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
February 11, 2008 4:59pm
Subscribe [1]#1 / Feb 11, 2008 4:59pm
i need some kind of “query module for dummies” intro or something. after reading through the docs and the wiki, it’s just not clicking for me. what i’m trying to do is use custom fields inside the calendar tag for a shows calendar i’m building. it seems simple enough, but the queries i’m writing ain’t cuttin’ it. a jpg with field_id and field_name info is attached.
many thanks.
#2 / Feb 12, 2008 5:20pm
I’m thinking it should be something like, but it gives no results:
{exp:query sql="SELECT shows_venue_name, shows_venue_url, shows_location, shows_tix, shows_also FROM exp_weblog_fields WHERE group_id='2'"}
<a href="http://{shows_venue_url}">{shows_venue_name}</a>
{shows_location}
{shows_tix}
{shows_also}
{/exp:query}#3 / Feb 13, 2008 9:45am
does this question belong in the tech support forum instead maybe?