nilai
|
| Posted: 10/07/2002, 10:52 AM |
|
I have a page consisting of 2 forms: a SEARCH on top and a GRID below. My intended output is ASP in CCS.
I have been trying very hard but still failed to accomplish the following:
When the user load the page, I want the grid to display nothing (the default is to load all data into the grid). I add this to the SQL tab --> field01=''. However, I can no longer use the SEARCH form at the top 
What to do so that the grid is empty the first time I load the page, and display searched result only when user use the SEARCH form? Thanks for reading (and answer?) !
|
|
|
 |
TonyE
|
| Posted: 10/07/2002, 8:11 PM |
|
In your grid form properties go to data source.
click on the table parameters of the where condition that was created with the wizard.
On the table paramter window enter a default value that doesn't match anything in your grid.
Your grid will not display anything until you perform a search.
TonyE
|
|
|
|
nilai
|
| Posted: 10/08/2002, 4:04 AM |
|
Thanks for the quick reply. I am sorry but can you please be more specify? I hope I am correct in the following steps:
In your grid form properties go to data source.
1. Goto GRID form.
2. CLick on Form Proporties
click on the table parameters of the where condition that was created with the wizard.
3. Click on SQL tab
4. Select "Use SQL String"
On the table paramter window enter a default value that doesn't match anything in your grid.
5. Click on INPUT tab
6. Enter a default value in myField
Your grid will not display anything until you perform a search.
7. Page contained error
Please help!!!
|
|
|
|
nilai
|
| Posted: 10/08/2002, 4:21 AM |
|
Actually the GRID didnt display anything in first run. However, my top SEARCH form no longer work. A search return no values at all.
|
|
|
|
Nicole
|
| Posted: 10/09/2002, 6:48 AM |
|
Nilai,
When using custom sql query the default values of the input parameters are used in Where clause if corresponding param values were not passed to the page. Probably you have entered such default values that returned recordset is empty.
The workaround is to build Where clause on the fly and append it to sql.
|
|
|
|
