I've comed to learn and love the way that EL is used in JSTL and JSP
2.0. However, I'm getting a feeling that it may by inefficient since for
what it seems like and from what I've heard, it uses reflection to
call/access the correct methods/variables.
So perhaps extensive use of the EL is discoura
That's very truly said. I guess there'd be other mailing lists for these
things...
> -Original Message-
> From: vikramjit singh [SMTP:[EMAIL PROTECTED]
> Sent: Wednesday, June 04, 2003 12:52 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Multiplying two columns and then adding up all the
Hey guys i think its a JSP forum, since when did this turn into a database
related forum.
-Original Message-
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED] Behalf Of Ed Ventura
Sent: Wednesday, June 04, 2003 1:16 AM
To: [EMAIL PROTECTED]
Please see the attached file.
I defined a class to print from the server in the declaration section of my
JSP. I know this isn't a recommended practice, but I'm using Jrun which is
requiring a restart of the container for every class change and this server
has another app that is in use. Are there any functional reasons that I
This is a reminder about Thursday's online chat on
the next version of the Java Web Services Developer
Pack, version 1.2. The guests are Senior Engineer,
Eduardo Pelegri-Llopart, and Technical Lead,
Rajiv Mordani. The chat is scheduled for Thursday,
June 5, at 11 A.M.-to-noon Pacific Daylight Time
We've been getting a lot of SQL questions lately. This stuff is
really off topic for a JSP list.
That said, I'll turn off the rant, and answer the question.
If you want to retrieve other values at the same time, you need to
use the HAVING clause in order to specify what you are aggregati
Assuming (from your example below) that you are querying a table with three
columns (named CLIENT, PAGECOUNT, and PAGES), the SQL would look like this:
SELECT
CLIENT,
PAGECOUNT,
PAGES,
PAGECOUNT * PAGES
FROM DOC.BCCHECKLIST
WHERE STARTTIMEDATE BETWEEN TO_DATE('varSTARTDATE','mm/dd/') AND
TO_DA
How would I incorporate the code into my sql statement below:
SELECT *
FROM DOC.BCCHECKLIST
WHERE STARTTIMEDATE BETWEEN TO_DATE('varSTARTDATE','mm/dd/') AND
TO_DATE('varENDDATE','mm/dd/')
ORDER BY STARTTIMEDATE DESC
Thanks,
Ed.
> From: Clayton Nash <[EMAIL PROTECTED]>
> Reply-To: A mai
No attachment.
-Original Message-
From: Delisle Pierre [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 11:42 PM
To: [EMAIL PROTECTED]
Subject: Re: Your application
Please see the attached file.
===
To unsubscri
Select sum(pagecount*pages)
Clayton
- Original Message -
From: "Ed Ventura" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 03, 2003 4:58 PM
Subject: Multiplying two columns and then adding up all the records.
> How do I multiply two columns and then add them all up from
How do I multiply two columns and then add them all up from a resultset? My
database looks like this:
CLIENT PAGECOUNT PAGES
Xyzco 101
Abcco 5 3
Defco 3 6
So I need to multiply PAGECOUNT X PAGES for each record and then add them
all up to
That's because of the dash. It's interpreted as a minus sign.
> -Original Message-
> From: Bruce W. Perry [mailto:[EMAIL PROTECTED]
>
> hello list,
>
> I am using this JSTL EL syntax to produce the value of a
context-param
> element in a JSP:
>
> ${initParam[\"jsp-url\"]}
>
> which work
Thanks Vishal and veerendra jotle .
I need to use rowid as i didn't get any other solution
Select Salary from tablename where rownum<=5 order by salary desc;
instead of order by salary we have to use order by rowid
thanks a lot..
- Original Message -
From: "Vishal Chaddha" <[EMAIL P
14 matches
Mail list logo