check all records

Results 1 to 2 of 2

Thread: check all records

  1. #1
    Join Date
    Dec 1969

    Default check all records

    If i want to see if a value exists in a particular column how can i search the whole column (every record)?<BR>I want to use the following IF statement.<BR><BR>IF request.servervariables("remote_addr") &#060;&#062; ""<BR><BR>-Dizzy

  2. #2
    Join Date
    Dec 1969

    Default RE: check all records

    I dont&#039;t quite understand what it is that you want.<BR>You talk about columns and records, but you also talk about request.servervariables.<BR><BR>If you are talking about a recordset (columns and records), use this:<BR><BR>blnCheckIt = False<BR><BR>Do While Not RS.EOF<BR>If RS("...") &#060;&#062; "" Then<BR>&#039; Found it<BR>blnCheckIt = True<BR>Exit Do<BR>End If<BR>RS.MoveNext<BR>Loop<BR><BR>If blnCheckIt = True Then<BR>....<BR><BR>If you want to loop through the servervariables, use:<BR>For Each Item In request.servervariables<BR><BR>

Posting Permissions

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