Complex Recordset operation

Results 1 to 3 of 3

Thread: Complex Recordset operation

  1. #1
    realdream Guest

    Default Complex Recordset operation

    Hi, I have got a recordset and need to know if there is a case in this rs where the field "ID" = input, but the field "ID2" is not =input AND not = 0. Because this case needs an specific action. Is there any way to find out about that without loosing my original rs (which is needed for every ohter case than the one above).

  2. #2
    Join Date
    Dec 1969

    Default how about..

    if not rs.eof then <BR>rs.movefirst<BR>do while not rs.eof <BR>if rs("id") = request("id") and (rs("id2") &#060;&#062; request("id") and rs("id2") &#060;&#062; 0 )then <BR>.<BR>.<BR>.<BR>end if<BR>rs.movenext<BR>loop<BR>end if

  3. #3
    realdream Guest

    Default RE: how about..

    I think it is working, thank you a lot!

Posting Permissions

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