r1xliquid
Posts: 41
|
| Posted: 11/29/2006, 11:21 AM |
|
I am working with a simple grid to display results from a view in sql. I have created a rather complex where clause in codecharge for this view.
my question is how can i add or remove items from the whereParameters in the _events.asp page? I know i can replace the whole WHERE clause with a new one by simply saying datasource.where = " where x = 1" but that will erase the original where clause.
annyone encounter this situation? i think you can use the whereParameters property of the datasource, but i dont know the syntax.
anyone else encounter a problem like this?
|
 |
 |
Edd
Posts: 547
|
| Posted: 11/29/2006, 1:04 PM |
|
Because the where clause needs to be treated as a whole, you don't have much alternatives except intercepting the paramters and changing them before you perform the select. See Help for examples.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
|
