Results 1 to 2 of 2

Thread: Loop

  1. #1
    Join Date
    Dec 1969

    Default Loop

    &#060;%<BR>do while not rs1.eof<BR> if mid(rs1("filename"),8,4) = ".prt" then<BR> if mid(rs1("directory"),18,7) = left(rs1("filename"),7) then<BR> response.write rs1("directory") & " - " & rs1("filename") & "<BR>"<BR> end if<BR> end if<BR>rs1.movenext<BR>loop<BR>%&#062;<BR><BR>the code above returns<BR> /usr5/released.Z/5002772_b_15.Z - 5002772.prt.15<BR>/usr5/released.Z/5002772_d_16.Z - 5002772.prt.16<BR>.........<BR><BR>I want it to reutrn only the latest version, in this case 16. Is it possible to have only the highest number(max) returned?<BR><BR>Thanks,<BR>Lane

  2. #2
    Join Date
    Dec 1969

    Default *NO* loop

    Just change your SQL query to only *GET* the highest value!<BR><BR>Since you don&#039;t show the SQL, can&#039;t give more explicit direction.<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