[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] Problems with [query]
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)
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users