|
Seems that this is a real
problem. I changed the code so that bind variables are used in filter tags –
so it’s possible to use other types as strings, e.g. double, too. But if you use bind
variables the wildcards must be part of the variable – otherwise you get
your ORA-01006 error. This change leads to the
syntax name like ? for the condition tag and to the ? in the user input. I
think we should extend the filterValue to the same features as search fields with
an new attribute algorithm and value
like the algorithm value for search fields. See http://jdbforms.sourceforge.net/UsersGuide/html/ch15s03.html for description! Who has the time to do
this task? Regards, Henner Von:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Im Auftrag von [EMAIL PROTECTED] I
am trying to use a filter tag in
combination with a LIKE statement (Oracle database). Where I am
having trouble is with wildcard searches. I
have looked at both the example and the documentation
and I am still confused... The
example shows only a LIKE which is used in a full
search ( n LIKE ?). I can get wildcard searches running
by having the user input the search criteria along with the appropriate %
character. I don't like this technique very much! After
having read the documentation both in the source code and in the guide, I
understand that I should be able to add the % characters within
the FilterCondition tag. Unfortunately, when
I do
this, I get a ORA-01006: bind variable does not exist. Here is my code: <db:filter>
<db:filterCondition label="Name starts with:">
name like '%?%'
<db:filterValue
type="text" label="nameLike"/>
</db:filterCondition> </db:filter> Has
anybody got this working? |
Title: How to use the filter tag!
- [dbforms] How to use the filter tag! Grunikiewicz . Philip
- Henner Kollmann
