Hello Guys,

I'm new to java programming, I'm trying to fill a table with data from a SQL database.
The code below works fine for my page but i don't want the var="SerialNr" set to be "1", I want to set var="SerialNr" = sessionstorage.serialnr
Java Code:
        
        <c:set var="SerialNr" value = "1"/>
        <sql:query var="dbq_machinenummer" dataSource="jdbc/EMD_Rapportage" >
            SELECT DISTINCT SerialNr,Make
            FROM  dbo.MachineData
            WHERE (SerialNr = ? <sql:param value="${SerialNr}"/>)
            ORDER BY SerialNr
        </sql:query>
How can i get this together?

Marc dekker