Search Engine Queries

2004-06-04 Thread Nic Werner 
I know this might not be a pure JSTL thing, but if anyone could offer 
some pointers, I'd appreciate it:

I've got a search page thing going on in JSP (JSTL), and I want to be 
able to search on any of the fields that are entered, basically an AND 
filter. So as to not create dynamic SQL queries, I use the below SQL code:

query part here...
and nvl(d.cable,' ') like nvl(?,'%')  and
nvl( d.pair , ' ') like nvl(?,'%')  and
nvl( to_char(d.prefix) , ' ') like nvl(?,'%')  and
nvl( upper(d.lname) , ' ') like upper(nvl(?,'%')) and
nvl( upper(d.fname) , ' ') like upper(nvl(?,'%')) and
nvl( to_char(d.DN) , ' ') like nvl(?,'%')   and
nvl( to_char(d.TN) , ' ') like nvl(?,'%')and
nvl( upper(d.DEPT_CD) , ' ') like  nvl(?,'%')
JSTL PARAMS
sql:param value=${param.cable}/
sql:param value=%${param.pair}%/
sql:param value=${param.prefix}/
sql:param value=%${param.lname}%/
sql:param value=%${param.fname}%/
sql:param value=%${param.dn}%/
sql:param value=%${param.tn1}%${param.tn2}%${param.tn3}%${param.tn4}%/ 
sql:param value=${param.dept_cd}/

This works well, except all the 'like' statements really bog down the 
Oracle system. Can anyone suggest a way to dynamically create the above 
query portion, only putting in the statements that actually have data?

I don't know much Java, but this seems like an applicable language 
to create the text, but PL/SQL seems viable also. JSTL might be 
inappropriate for this. Any thoughts? Am I reinventing the wheel?

Thanks,
- Nic.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Using HTML tags inside scoped variable

2004-06-04 Thread [EMAIL PROTECTED] 
Hello,
Is it possible to keep a string with HTML tags inside a scoped variable.
I am trying to do something like:
c:set var=ErrorMessage scope=page
Message text... bc:out value=${Customer}//b
/c:set
Unfortunately when I try to insert the ErrorMessage into the page body 
using:
c:out value=${ErrorMessage}/

I get something like:

Message text... bCustomer/b

Is it possible to make c:out not to escape HTML tags,
or maybe the whole approach is incorrect and there is other way to solve it?
Thanks for help,
regards,
Lukasz
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: Using HTML tags inside scoped variable

2004-06-04 Thread Pierre Delisle 
Lukasz,

Simply use:

  c:out value=${ErrorMessage} escapeXml=false/

-- Pierre

[EMAIL PROTECTED] wrote:

 Hello,
 
 Is it possible to keep a string with HTML tags inside a scoped variable.
 I am trying to do something like:
 c:set var=ErrorMessage scope=page
 Message text... bc:out value=${Customer}//b
 /c:set
 
 Unfortunately when I try to insert the ErrorMessage into the page body
 using:
 c:out value=${ErrorMessage}/
 
 I get something like:
 
 
 Message text... bCustomer/b
 
 
 Is it possible to make c:out not to escape HTML tags,
 or maybe the whole approach is incorrect and there is other way to solve
 it?
 
 Thanks for help,
 regards,
 Lukasz
 
 
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 
 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

jstl1.0 -- jstl1.1

2004-06-04 Thread Tridev Kodamasingh 

Hi,

I am facing a problem when I am migrating from jstl 1.0 to jstl 1.1.

The problem is as follows.

 I am using jstl xml library to read from a XML sub-node.
The xml  is read trough using  org.w3c.dom.* classes. When a
particular subnode which is of type org.w3c.dom.Node, is encountered 
while parsing through the XML, that is stored in the request
scope(ie. request.setAttribute(subnode, Node)). And in JSP, 
 value of the node is accessed through 
x:out select=$subnode/@name/.
This works fine, with JSTL 1.0. I am able to retrieve,
values of the sub node properly, in the JSP.

But, with JSTL 1.1,  when it is accessed via x:out
select=$subnode/@name/ all I am getting is whole document.
I am not able to find out, how come from a  subnode,  I am
getting whole of the document.

Please suggest me, how to fix this.
Thanks a lot for your time.
Tridev




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: Search Engine Queries

2004-06-04 Thread Andrew Nelson 
If you don't know java it could be a bit painful but there is a really
cool example in a jdbc book I just read.  Database Programming with JDBC
and Java   published by O'Reilly.  In chapter 10 near the end there is a
section on searches.

I think I've seen the same thing on the web somewhere as an example
chapter.

Anyhow I think it is really cool.  You could probably extend it one
more step and make a tag of it.  I might even be willing to help with
this task.

//Andy 

 [EMAIL PROTECTED] 6/3/2004 9:29:50 AM 
I know this might not be a pure JSTL thing, but if anyone could offer 
some pointers, I'd appreciate it:


I've got a search page thing going on in JSP (JSTL), and I want to be 
able to search on any of the fields that are entered, basically an AND

filter. So as to not create dynamic SQL queries, I use the below SQL
code:

query part here...
and nvl(d.cable,' ') like nvl(?,'%')  and
nvl( d.pair , ' ') like nvl(?,'%')  and
nvl( to_char(d.prefix) , ' ') like nvl(?,'%')  and
nvl( upper(d.lname) , ' ') like upper(nvl(?,'%')) and
nvl( upper(d.fname) , ' ') like upper(nvl(?,'%')) and
nvl( to_char(d.DN) , ' ') like nvl(?,'%')   and
nvl( to_char(d.TN) , ' ') like nvl(?,'%')and
nvl( upper(d.DEPT_CD) , ' ') like  nvl(?,'%')
JSTL PARAMS
sql:param value=${param.cable}/
sql:param value=%${param.pair}%/
sql:param value=${param.prefix}/
sql:param value=%${param.lname}%/
sql:param value=%${param.fname}%/
sql:param value=%${param.dn}%/
sql:param
value=%${param.tn1}%${param.tn2}%${param.tn3}%${param.tn4}%/ 
sql:param value=${param.dept_cd}/


This works well, except all the 'like' statements really bog down the 
Oracle system. Can anyone suggest a way to dynamically create the above

query portion, only putting in the statements that actually have data?

 I don't know much Java, but this seems like an applicable language

to create the text, but PL/SQL seems viable also. JSTL might be 
inappropriate for this. Any thoughts? Am I reinventing the wheel?

Thanks,

- Nic.

-
To unsubscribe, e-mail: [EMAIL PROTECTED] 
For additional commands, e-mail: [EMAIL PROTECTED] 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Where is the Input tag library?

2004-06-04 Thread Martin Cooper 


 -Original Message-
 From: Derek Mahar [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 01, 2004 8:22 AM
 To: Tag Libraries Users List
 Subject: Where is the Input tag library?


 Where may I find the Input tag library binary distribution?  The Input
 tag library is absent from the following Taglibs mirrors:

 http://apache.sunsite.ualberta.ca/jakarta/taglibs/input/
 http://apache.mirror.mcgill.ca/jakarta/taglibs/input/binaries/

Good question. It's actually missing from the main Apache site, which is why
it's missing from the mirrors. It's not the only one that's missing,
either - at least io and i18n, and quite possibly others, are also missing.
I have no idea where they went (assuming they were really there at some
point).

Anyone have any ideas? (Copying -dev so all the committers see this.)

--
Martin Cooper


 Derek




 NOTICE: This email contains privileged and confidential
 information and is intended only for the individual to whom it is
 addressed. If you are not the named addressee, you should not
 disseminate, distribute or copy this e-mail. Please notify the
 sender immediately by e-mail if you have received this
 transmission by mistake and delete this communication from your
 system. E-mail transmission cannot be guaranteed to be secured or
 error-free as information could be intercepted, corrupted, lost,
 destroyed, arrive late or incomplete, or contain viruses.

 AVIS: Le prisent courriel contient des renseignements de nature
 priviligiie et confidentielle et nest destini qu'` la personne `
 qui il est adressi. Si vous njtes pas le destinataire privu,
 vous jtes par les prisentes avisis que toute diffusion,
 distribution ou reproduction de cette communication est
 strictement interdite.  Si vous avez regu ce courriel par erreur,
 veuillez en aviser immidiatement lexpiditeur et le supprimer de
 votre systhme. Notez que la transmission de courriel ne peut en
 aucun cas jtre considiri comme inviolable ou exempt derreur
 puisque les informations quil contient pourraient jtre
 interceptis, corrompues, perdues, ditruites, arrivies en retard
 ou incomplhtes ou contenir un virus.

 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]





-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Where is the Input tag library?

2004-06-04 Thread Felipe Leme 
Martin,

I think - but am not sure - that some taglibs never had an official
release.

Felipe

PS: by speaking of releases, do you know what's going on with the
nightly builds (last one was on May 29th, even though Gump is not
complaining they are broken)


On Fri, 2004-06-04 at 19:23, Martin Cooper wrote:
 I have no idea where they went (assuming they were really there at some
 point).



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]