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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>