BC4J

Try this:

<jbo:SetWhereClauseParam index="0" value="${param.Test}" datasource="elem"/>

If that does not work, please attach the error message.

Fred

Nop, it doesn't work !! and there is no error message !!

So, in which way does it not work?

/Fred

It seems bc4j tags doesn't support EL??? I guess.

What do you get back in the result set? Does it seem to do a search with an empty string, or does it seem to do a search for a string containing the text "param.Test"?

How do you know there is a problem?

As I mentiond before it works If I use request.getParameter but it doesn't when using EL!!
using EL I get no data, but i get the result usring request object.

Ok DrAske,

Now we are getting somewhere, you hadn't mentioned before that you got no data, you just mentioned that it did not work, and that could for example mean that it returned all data instead of filtering on your parameter. Just trying to help you find out what is going wrong.

Just to confirm, do you get the right value in your test input field:
<input type="text" value="<c:out value="${param.Test}"/>"/>    <----- just for testing purpose

If you get the right value there, then there is a problem with the jbo tag that it does not evaluate the expression language, if you do not get the right value there, then there is a problem that the page is not evaluating the expression language.

Sorry for not being clear enought.
>> Just to confirm, do you get the right value in your test input field:
yes I get the right value.

Have a look in the DataTags.tld file. You will see a definition of the SetWhereClauseParam tag. Could you copy and paste that whole definition here? I haven't been able to find a copy of the DataTags.tld file myself yet.

The tag should start something like this (an example from my own projects):
  <tag>
    <name>image</name>
    <tagclass>org.apache.taglibs.image.ImageTag</tagclass>
    <bodycontent>JSP</bodycontent>

When you are at it, copy the top from that .tld file as well. E.g.
  <tlibversion>1.0</tlibversion>
  <jspversion>1.1</jspversion>

/Fred

you mean this?

<?xml version = "1.0" ?>
<!DOCTYPE taglib PUBLIC "-//Sun Microsystems, Inc.//DTD JSP Tag Library 1.1//EN"        "http://java.sun.com/j2ee/dtds/web-jsptaglibrary_1_1.dtd">
<taglib xmlns = "http://java.sun.com/j2ee/dtds/web-jsptaglibrary_1_1.dtd">
   <tlibversion>5.0</tlibversion>
   <jspversion>1.1</jspversion>
   <shortname>jbo</shortname>
   <uri>/webapp/DataTags.tld</uri>
   <info>The Business Components DataTag library</info>  
   <!-- name="META-INF/taglib.tld" location="@oracle.home@/BC4J/jlib/datatags.jar" pageScopes="ADFbcJSP" -->  

Yes, but also the definition of the SetWhereClauseParam tag:

<tag>
    <name>SetWhereClauseParam</name>
... more stuff here ....
</tag>

Sorry for being late!!!

 <tag>
      <name>SetWhereClauseParam</name>
      <tagclass>oracle.jbo.html.jsp.datatags.SetWhereClauseParamTag</tagclass>
      <bodycontent>Empty</bodycontent>
      <info>Set bind variable value on the where clause of a RowSet.</info>
      <!-- page="Business Components Data Access" -->
      <!-- icon="/oracle/jbo/dt/ui/wizards/palette/images/T_Row.gif" -->
      <!-- editor="oracle.jbo.dt.ui.wizards.palette.JspWizardInvoker" -->  
      <attribute>
         <name>index</name>
         <required>true</required>      
         <rtexprvalue>true</rtexprvalue>
      </attribute>
      <attribute>
         <name>value</name>
         <required>true</required>      
         <rtexprvalue>true</rtexprvalue>
      </attribute>
      <attribute>
         <name>datasource</name>
         <required>false</required>      
         <rtexprvalue>true</rtexprvalue>
      </attribute>
   </tag>

<rtexprvalue> is set to true, which means it is OK to use EL!!