theVoid
|
| Posted: 04/25/2003, 5:01 PM |
|
W2K/CCS 2.6.11/ASP
I'm using the tutorial PDF and on this section:
3.6 Filter Grid Records - Add Search Parameter
I try to add to the SQL statement by following the example but alas,
pressing the "+" button brings up the dialog box but once I click OK the additional parameter is not added to the Data Source Query... so when I cannot finsh the example with the Grouping/Where instructions.
Any clue what's happening?
Thanks,
Scott
|
|
|
 |
theVoid
|
| Posted: 04/25/2003, 5:19 PM |
|
Ok, although nothing shows up in the Data Source dialog box I see this when I check the SQL:
SELECT task_id, task_name, task_start_date, task_finish_date
FROM tasks
WHERE task_name LIKE '%{s_keyword}%' OR task_desc LIKE '%{s_keyword}%' OR tasks.project_id = {s_project} AND tasks.project_id = {s_project} AND tasks.project_id = {s_project} AND tasks.project_id = {tasks.project_id} AND tasks.project_id = {tasks.project_id} AND tasks.project_id = {s_project} AND tasks.project_id = {s_project} AND tasks.project_id = {s_project)
--------------
As you can tell I tried adding this several times.
Also, When I run the Visual Query builder I only see 1 table of the many which are n the Intranet sample DB.
Somethings up!
Thanks,
Scott
|
|
|
|
|
