X-application does not return numeric values>1000000

X-Application Version: 3.1.2, 3.1.1
Tamino Version : 3.1.1
Platform : NT, Win2k, Solaris, …
WebContainer : Tomcat 3.3
JDK Version : 1.3.1

Hi everyone,

I am working on an app with X-application where I want to find all cars that cost more than Rupees 1000000 or 1 million. And i get no result… it simply gives a blank page.
The code i have written is:


Select an Upper Price Range:


4 Lacs
7 Lacs
12 Lacs
50 Lacs


can anyone suggest the datatype?i tried it with int , double,longint and nothing works. Am i missing something?
Let me know,
Thanks,
Sumier

Hello Sumier,

to create a query which is based an integer or flaot comparison, you should define a further parameter within your query(…) expressions.

In your case, use



Have look at


  • the X-Application documentation, section “Defining a Query Field for a Numeric Field” of the chapter “Defining and Processing Queries”.
  • the simple example 'query’


I think that should solve your problem independed of the type you defined within the schema. the type Integer causes that the value is not quoted (with ').

Hint: Avoid spaces within the query(…)
expression.

Bye,
Christian.