Clarity

Hi All,

When I test a value, it goes through when it shouldn't succeed.

I am trying to test if a value returned from the database is greater than a parameter value I set.

My variables show:

v_emails.rows[0].num = 6

v_TimeSlice = 20

In what world does 6 > 20?  Is the system somehow converting the value or not returning it?  What's going on where this test succeeds?  How do I get it to TEST the value properly?

<core:when test="${v_emails.rows[0].num > v_TimeSlice}">

One more detail:  I set the parameter like this:

  <gel:parameter default="20" var="v_TimeSlice"/>

On the Custom Script Parameters screen, I set it to 20

If the variables in a comparison are different datatypes, then I would expect that you would get unexpected behaviour.

Hi David,

How would I declare a Parameter as a "number".

I perform a count query from the database and return that value "v_emails.rows[0].num" which returns 6.

How do I get the data types to match?  I don't see a method to set the Parameter to "number"

Thanks,

Lowell

On the gel:parameter tag default is a string and v_emails.rows[0].num is an object.

V/r,

Gene

Hi Gene,

Does this mean that parameters are useless when it comes to comparing numbers?

And is there a way to convert data types or specify data types so they work?

Thanks,

Lowell

Try these to see if you get what you need.

<core:new var="int1" className="java.lang.Integer">
<core:arg type="java.lang.String" value="${v_TimeSlice}" />
</core:new>

<core:new var="int2" className="java.lang.Integer">
<core:arg type="java.lang.String" value="${v_emails.rows[0].num.toString()}" />
</core:new>

<!-- Might have to call the toString outside JSTL -->

<core:invoke on="${v_emails.rows[0].num" method="toString" var="v_emails_row"/>
<core:new var="int3" className="java.lang.Integer">
<core:arg type="java.lang.String" value="${v_emails_row}" />
</core:new>

V/r,

Gene

This one should call the toString by default but I gave up ever expecting jelly to do what java or C# do.

<core:new var="int2" className="java.lang.Integer">
<core:arg type="java.lang.String" value="${v_emails.rows[0].num}" />
</core:new>

V/r,

Gene

IMHO the problem is with the greater than symbol.

See

Using >= or <= in query of GEL part 2 

and Basic guide to getting started with GEL.docx

eg. in Basic guide to getting started with GEL.docx 

^ yep, might well be that.

Does not costs or hurt much to test.