WandaL
05-31-2003, 12:28 AM
I have an ASP page that searches a database. Although the entire database is searched, I use a filter on certain fields. The below filter (I could only use a little bit for the post to work)is for a field [LEDef_ActiveInd] that has either the number 1 or 2 or the text of true or false and it works and returns all "LEDef_ActiveInd" that carries the value of true.
\\..strQS = ..strL & "...LEDef_ActiveInd+true nd all+" & \\Trim\\(strR)\\
What I would like to do is also filter a field [LEDef_Cd] which has text data such as "10-Name" or "40-Name", etc. I need a filter/code that would return the results of all the "10-Names".
Please help me.
Thanks...
\\..strQS = ..strL & "...LEDef_ActiveInd+true nd all+" & \\Trim\\(strR)\\
What I would like to do is also filter a field [LEDef_Cd] which has text data such as "10-Name" or "40-Name", etc. I need a filter/code that would return the results of all the "10-Names".
Please help me.
Thanks...