objRS.filter problem

Results 1 to 2 of 2

Thread: objRS.filter problem

  1. #1
    Join Date
    Dec 1969

    Default objRS.filter problem

    What is the correct syntax for recordset filter option when field value to filter is char, number and also when it is date.<BR><BR>I&#039;ve done it as per the book but not getting it right. I also check the field value with response.write objRS("coName") - but it is showing blank. But the RS does have records fulfilling that criteria.<BR><BR>Also is it possible to use a variable as the filter criteria i.e. objRS.Filter="coID=varname" where variable varname contains a numeric value<BR><BR>Thanks in advance.

  2. #2
    Join Date
    Dec 1969

    Default RE: objRS.filter problem

    objRS.Filter = "coID = " & varname<BR><BR>Are you sure you want to use Filter? Wouldn&#039;t it just be better to filter your recordset as you retrieve the data from the database?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts