hiraldesai
Posts: 38
|
| Posted: 04/04/2007, 6:17 PM |
|
Hi,
I am using aggregate functions and group by with "Table" as data source with 3-4 "WHERE" URL parameters. There is a need to use "HAVING" for one of the columns and according to the following topic I switched to "SQL" data source.
http://forums.yessoftware.com/posts.php?post_id=44287
This works fine but all the integer parameters are assigned a default value of 0 in the SQL view. And this value is mandatory for integer parameters. This means that when a given parameter is not supplied in the URL, it takes 0 as it's value and the query returns incorrect results. Ideally, when using "Table" datasource, if a parameter is not supplied, the expression is not evaluated.
I am sure there is a fix to this, I have tried looking for it in CodeCharge help without any success.
Any help would be greatly appreciated.
Regards,
Hiral
_________________
-------
Hiral |
 |
 |
|
