Filter Records on 4 Fields

[mswilson16]

Hi All,

I am using ASP and reading a SQL database. I have a dynamic table that lists all the records found from rsClientInfo, what I need to do is, when all the clients have been found be able to put a filter on the results.

e.g. be able to put in *wil* in a field as criteria to filter the records to only show clients that have wil in there name.

thanks

mswilson

 

[DotNetGnat]

you can do something like this:

RS.Filter = "name Like '%wil%' OR..."

-DNG

 

[mswilson16]

thanks dotnetgnat how would apply this filter? do I use javascript/asp? Can I put the code on a command button?

 

[DotNetGnat]

can you show us your code so far??

-DNG

 

[mswilson16]

I dont really have anything, I have just created a dynamic table by going Insert, Application Object, Dynamic Table... then create a ODBC connection connClient, then a recordset rsClient where deleted = false... other than that, dont have anything else.