I have a similar problem to what marc had, but I can't even get past step 1.
I have a process to search for and select History objects within a date range. Then print only those selected.
I thought I had it correct with:
1. PICK ONE OR MORE FROM History WHERE att=?'fromdate' AND att=?'to date'
2. PRINT DOCUMENT "xyz"
What happens is:
- a date from and date to window appears and allows me to enter the dates.
-Pressing execute gives me an internal error:
javax.servlet.ServletException
com.bas.webapp.actions.b.a(Unknown Source)
com.bas.webapp.actions.QueryAction.S(Unknown Source)
com.bas.webapp.actions.QueryAction.doExecute(Unknown Source)
com.cc.framework.adapter.struts.ActionUtil.execute(Unknown Source)
com.cc.framework.adapter.struts.FWAction.execute(Unknown Source)
com.cc.framework.adapter.struts.FWAction.execute(Unknown Source)
com.cc.framework.adapter.struts.RequestProcessorUtil.processAction(Unknown Source)
com.cc.framework.adapter.struts.FWRequestProcessor.processActionPerform(Unknown Source)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1056)
com.cc.framework.adapter.struts.FWRequestProcessor.processForwardConfig(Unknown Source)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:231)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.lang.NullPointerException
com.bas.webapp.actions.QueryAction.a(Unknown Source)
com.bas.webapp.actions.QueryAction.S(Unknown Source)
com.bas.webapp.actions.QueryAction.doExecute(Unknown Source)
com.cc.framework.adapter.struts.ActionUtil.execute(Unknown Source)
com.cc.framework.adapter.struts.FWAction.execute(Unknown Source)
com.cc.framework.adapter.struts.FWAction.execute(Unknown Source)
com.cc.framework.adapter.struts.RequestProcessorUtil.processAction(Unknown Source)
com.cc.framework.adapter.struts.FWRequestProcessor.processActionPerform(Unknown Source)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1056)
com.cc.framework.adapter.struts.FWRequestProcessor.processForwardConfig(Unknown Source)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:231)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
Can anyone make sense of that and tell me what I am doing wrong please?
Help on a Query error
FIXED!
Sorry, that rule should read
PICK ONE OR MORE FROM History WHERE History.LSLetter1>=?'From date' AND History.LSLetter1<=?'To date' ORDER BY History NO CONFIRMATION FOR ONE.
AHA, I think I see the problem - no attribute in the ORDER BY.
Wow, it works like a charm now. Sorry to have wasted anyone's time.
PICK ONE OR MORE FROM History WHERE History.LSLetter1>=?'From date' AND History.LSLetter1<=?'To date' ORDER BY History NO CONFIRMATION FOR ONE.
AHA, I think I see the problem - no attribute in the ORDER BY.
Wow, it works like a charm now. Sorry to have wasted anyone's time.