It appears you are treating foo as a string. The + sign is concatenating 1
with 1 which gives you a result of a String containing the characters 1 and
1.
Mark
-Original Message-
From: Pedro Diaz [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 10:19 AM
To: [EMAIL PROTECTED]
Su
erformance...
Wim
> -----Original Message-
> From: Mark Shead [mailto:[EMAIL PROTECTED]]
> Sent: woensdag 19 september 2001 17:46
> To: [EMAIL PROTECTED]
> Subject: RE: DBTags and Poolman
>
>
> My understanding of connection pooling (and I welcome any
> correctio
My understanding of connection pooling (and I welcome any corrections if I'm
wrong) is:
If you are using a JDBC 2.0 driver and you give JNDI a handle to a
connection to the database and have the DBTags get their connection info
from JNDI, then JDBC will automatically pool the connections.
--Ma
I'm running into an odd problem that I think has something to do with the
way scope works within the DBtags. I need to create a variable to total the
cost for a list of items. If I create a variable called total outside of
the DBtags, it doesn't seem to be in scope within the loop that is
gener
I finally got the tags working with the jndi. For anyone trying to do the
same thing it needs to be file://.
Mark
-Original Message-
From: Mark Shead [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 28, 2001 3:52 PM
To: [EMAIL PROTECTED]
Subject: DBTags using jndiName
I'm pro
You might be better of just using SQL's date functions instead of trying to
get your JSP to do this task. Here is an example from PostgreSql. It is
probably similiar for other databases:
~
postgres=# select current_date;
date
2001-07-30
(1 row)
postgres=# select current_date -
I'm probably missing something very simple here, but I can't seem to find
any information on the correct form of a jndiName for the DBTag connection.
I have bound a datasource to a name using JNDI and I have a test program
that uses this connection to get information out of a database, but I can't
I don't know the answers to all your questions, but if you look at the
DBtags they have a way to request a set of rows and loop over them until
they are all printed.
For example:
select r.*,
case when (select 1
from req_approvals ra
where