esql and javascript in xsp

[Jo...@o2.com]

Hi,

                                I' having problems with JavaScript
functions in XSP-Pages. This is part of my
                                funnction:

                                        function
populate_service_dropdown(report_id)
                                                                        {
report_id =

document.reportFrm.report_id.options[document.reportFrm.report_id.selectedIndex].id;
i=0;
<esql:connection>
<esql:driver>oracle.jdbc.driver.OracleDriver</esql:driver>
<esql:dburl>jdbc:oracle:thin:@XXXXXX:XXXX:XXXXX</esql:dburl>
<esql:username>XXXXX</esql:username>
<esql:password>XXXXXX</esql:password>
<esql:execute-query>
<esql:query>
SELECT description, service_id
FROM report_services
WHERE report_id = '16' AND
active_ind = 'Y'
ORDER BY display_order
</esql:query>
<esql:results>

                                I want the passed parameter (report_id) put
in the select-statement like this:
                                ....WHERE id = report_id
                                I was told it would work something like
this:
                                ....WHERE id
= <xsp:expr>report_id<xsp:expr>.
                                But this didnt't help.
                                Do I have to store the passed parameter
first in a variable?
                                What should I do?

                                Thanks
                                Jonny




---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <co...@xml.apache.org>
For additional commands, e-mail:   <co...@xml.apache.org>