Yes I know :-)Handling like this is not possible in the current jsp definition (1.2). You can not access data of one tag inside another. With upcoming new jsp 2.0 this should be possible without any changes - have a look at new specification at java.sun.com or try tomcat 5.
Maybe you could test if dbforms is running under tomcat 5 and give us a report?
Ofcourse I'll do that, but we can do something like that in jsp page:
1. We call our DataSource object (for example from session variable - I don't know how to do that easier).
javax.sql.DataSource ds=(javax.sql.DataSource)session.getValue("data_source");
Connection db=ds.getConnection();
Statement st = db.createStatement();
2. We work on kdo table, so we can take actual row variable by:
String nip = (String) currentRow_kdo.get("nip");
3. We can use this variable in our query
ResultSet rs = st.executeQuery("select kdo_nip("+nip+") as nip_slash");
nip_slash=(String)rs.getString("nip_slash");and then we can use nip_slash in out form - easiest by <%=nip_slash%>
So I ask if it's possible to put that code in something like tag.... for example it could look like:
<db:labelConn sql="select kdo_nip("+(String) currentRow_kdo.get("nip")+") as nip_slash">
is this possible in dbforms?
------------------------------------------------------- This SF.net email is sponsored by: VM Ware With VMware you can run multiple operating systems on a single machine. WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the same time. Free trial click here: http://www.vmware.com/wl/offer/345/0 _______________________________________________ DbForms Mailing List
http://www.wap-force.net/dbforms
