• Access to objects within a xe:jdbcQuery

    By Matthias Q Schneider 1 decade ago

    Hi.

    I am currently searching for a way to get a reference to the current JDBC row/column from within a viewPanel that gets its data from a MySQL db. Displaying these data works fine - thanks to all that did such a great job with the JDBC extensions!!

    Now I need to render one column of this JDBC data set as a link, clicking the link should store the value in sessionScope.

    For a Domino view I can use getDocument/getItemValue based on the viewPanel var. For JDBC queries, I found no reference how to pick the current value out of the data set based on the var reference.

    Having a short HowTo would be great ;-)

    Thanks a lot in advance!!

    • How I do it:

      By Jack Wilson 1 decade ago

      Matthias,

      In your viewPanel, assuming you have set your var="rowData", for your link's mouse click event you can use something like:

       sessionScope.currentBilId = (rowData.getColumnValue("bil_id"));

      (This works for me using a table called "bills" with the primary key first column named "bil_id" .)

      I do this using mssql backend, I would think it would work the same for other backends.

      ...jack

       

       

      • Thanks!!

        By Matthias Q Schneider 1 decade ago

        Jack, that works perfect, thanks a lot!