ASP beginner! help!

Discussion in 'HTML & Website Design' started by asap_asp, Feb 2, 2010.

  1. #1
    Hi im a total beginner at asp and was helping develop an IP information system.

    i made a page where i can add, delete and view a list of ip addresses.

    the list of ip addresses are stored in an access database

    now i want to view a list of unassigned ip addresses. i understand the logic and when i thought it out i guess i need something that will look into my database and output the ip that does not exist in the database.

    for example i have a database with the values: 3, 5, 8, 9
    and i want to output the missing numbers up to 12 the output should record: 1, 2, 4, 6, 7, 10, 11, 12

    i have been researching for the past few days and starting to stress.


    i tried to use this piece of code but doesnt work



    <%
    for i = 20 to 126
    rsServerIP.movefirst
    do while not rsServerip.EOF
    while not i = rsserver
    response.write (i)
    wend

    rsServerIP.Movenext
    loop
    %>


    any help would be greatly appreciated.

    thanks in advance
     
    asap_asp, Feb 2, 2010 IP
  2. nadiralishah_webexpert

    nadiralishah_webexpert Guest

    Messages:
    229
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    u missed to close for loop using next.
     
    nadiralishah_webexpert, Feb 5, 2010 IP