So you're saying something simple like:
<sql:query var="results">
SELECT * FROM DEFECT
</sql:query>
is blowing up?
Quoting Michael Duffy <[EMAIL PROTECTED]>:
>
> Good check, Kris, but I did have the EL notation.
>
> I stripped my query down (it got big with joins) to a
> "SELECT * FROM DEFECT". I still get an "invalid
> column exception". The query runs fine in Oracle's
> SQL*Plus.
>
> I wrote a simple JSP a while back that lets me type an
> ad-hoc query into an HTML text area and displays the
> results in a table. It's been helpful for testing
> connections and data source set-ups. I can type
> "SELECT * FROM DEFECT" into that JSP and get a table
> result back.
>
> What does all this tell me? I must need more coffee,
> because I'm still not seeing what I've missed.
>
> Gotta be a bonehead problem.
>
>
>
> --- Kris Schneider <[EMAIL PROTECTED]> wrote:
> > Are you using:
> >
> > <sql:dateParam value="sinceReportDate" type="date"/>
> >
> > instead of:
> >
> > <sql:dateParam value="${sinceReportDate}"
> > type="date"/>
> >
> > Quoting Michael Duffy <[EMAIL PROTECTED]>:
> >
> > >
> > > I've got a question that will turn out to be
> > simple,
> > > but I'm not seeing it.
> > >
> > > I'm writing an SQL query that has a date
> > parameter, so
> > > I'm using the <sql:dateParam> tag nested
> > underneath my
> > > <sql:query> tag, with the type="date" attribute
> > set.
> > >
> > > "JSTL In Action" tells me that the value for
> > > <sql:dateParam> has to be a scoped variable of
> > type
> > > java.util.Date, so I've got a <jsp:useBean> tag
> > that
> > > declares one.
> > >
> > > The problem comes when I try to set the value of
> > the
> > > Date Bean. I get a string value from an HTML form
> > > input text, so I want to use <fmt:parseDate> to
> > turn
> > > it into a Date. I wrap the <fmt:parseDate> in a
> > > <c:if> tag that makes sure I only parse when the
> > > parameter for the text box is not empty.
> > >
> > > But when I run the JSP I get an exception back in
> > the
> > > browser:
> > >
> > > javax.servlet.jsp.JspException: An error occurred
> > > while evaluating custom action attribute "value"
> > with
> > > value "sinceReportDate": Attempt to convert String
> > > "sinceReportDate" to type "java.util.Date", but
> > there
> > > is no PropertyEditor for that type (null)
> > >
> > > I'm not seeing my error. Can anybody on the list
> > spot
> > > it? Thanks - MOD
> >
> > --
> > Kris Schneider <mailto:[EMAIL PROTECTED]>
> > D.O.Tech <http://www.dotech.com/>
--
Kris Schneider <mailto:[EMAIL PROTECTED]>
D.O.Tech <http://www.dotech.com/>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
