NewbieRob
Posts: 20
|
| Posted: 09/13/2005, 4:08 PM |
|
Using ASP VBScript I have BeforeBuildSelect code which builds a Where clause for SQL based on what's in the s_keyword field of the search box for the grid. I parse s_keyword and insert OR between words. It appears that it is building the string correctly but when I use the syntax indicated in the help system to modify the SQL Where in CCS it just puts my string in front of "AND [Search Description] like '%search words here%'" instead of replacing the Where clause completely with my string, which of course produces a syntax error.
The code I am using to replace Where is:
q_WaterQuery.DataSource.Where = q_WaterQuery.DataSource.Where & sWhr
How can I replace Where with my string instead of just placing my string in front of what CCS creates for Where from s_keyword? I feel like I've almost got it but am missing one small step to finishing it up. This is a very important project so any tips will be a tremendous help.
|
 |
 |
Edd
Posts: 547
|
| Posted: 09/18/2005, 7:29 AM |
|
See
http://forums.codecharge.com/posts.php?post_id=59072
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
|
