No problem, glad it's working.
Quoting Michael Duffy <[EMAIL PROTECTED]>:
>
> I know - I deserve a dope slap for this one. ;)
>
> But you're absolutely right - I've been trying to slow
> down and be a little more careful with my query. I
> must have done something wrong with a parameter in a
I know - I deserve a dope slap for this one. ;)
But you're absolutely right - I've been trying to slow
down and be a little more careful with my query. I
must have done something wrong with a parameter in a
previous incarnation, because now I'm getting a good
result back.
I apologize for takin
Well of course the data access stuff shouldn't be embedded in a JSP ;-). But it
should still work. Actually, it sounds like you might have a mismatch between
the types you're using for your input parameters and the column types your
querying against. Can you build your query up param by param to se
I made a bonehead error on that one, Kris. My
original query had parameters in it. When it failed,
I stripped it down to "SELECT * FROM DEFECT" - but in
my haste I forgot to remove the tags
underneath. Once I saw that, the simple query worked
just fine.
Once that was working, I put back my lo
So you're saying something simple like:
SELECT * FROM DEFECT
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
> colum
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
Are you using:
instead of:
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 tag nested underneath my
> tag, with the type="date" attribut
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 tag nested underneath my
tag, with the type="date" attribute set.
"JSTL In Action" tells me that the value for
has to be a scoped variable of type
j
