GeorgeS
Posts: 206
|
Posted: 03/30/2004, 4:05 PM |
|
Hi,
I'm passing params from one page to another.
My link looks like this:
page.asp?Param1=22&Param2=99
On the second page there is a grid based on SQL that pulls data from several tables.
If Param1 and Param2 are not empty I'd like to use their values in Where clause.
On the lower part of the Data Source Query Builder (where I created my SQL statement) there is a window for inserting parameters.
Are these parameters for WHERE clause or not?
I'm not sure how to use them in my case.
What should I do?
Any help would be appreciated.
_________________
GeorgeS |
|
|
peterr
Posts: 5971
|
Posted: 03/30/2004, 4:39 PM |
|
Those parameters are used automatically when you use a Table. If using SQL then the use of these parameters is optional and can be used in the WHERE part of the SQL statement. For example "WHERE item_desc LIKE %{s_desc}%".
For this to work you'd need to define each of the parameters in the Parameters section below the SQL statement.
Please also see http://forums.codecharge.com/posts.php?post_id=27344
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|