[ic] Problems with [query]

[Stefan Hornburg Racke]

patrick.bennett@ccgenesis.com writes:

> So I'm trying to do something with this tag
> and having no luck.  I have a 'section_display' table
> which links sections in the 'section' table to each
> other in a hierarchy with section 0 being the root.
> 
> Here's the code:
> 
> [query sql="select sd.sub_section_id, s.name, s.description from
> section_display as sd, section as s where sd.section_id = 0 and s.section_id
> = sd.sub_section_id and sd.workflow_status='a' order by sd.display_seq"
> type=list ]
>     [list]
>        <tr><td>[sql-param name]</td><td>[sql-param description]</td></tr>
>     [/list]
> [/query]

What's the result ? Anything in your error log ?
Shot in the dark: Try [sql-param 1] and [sql-param 2] instead.

Ciao
        Racke

-- 
Racke happily hacks Interchange and maintains Debian packages like Courier.

For projects and other business stuff please refer to COBOLT NetServices
(URL: http://www.cobolt.net; Email: info@cobolt.net; Phone: 0041-1-3884400)