Need help in asp coding

Discussion in 'C#' started by malim, Nov 14, 2010.

  1. #1
    Hello folks..

    I need help in asp coding. I want to update size measurement chart for a website let me tell u in details.

    **************
    Please see this it has four fields for size
    montrosefashion.com/leatherjacketdetail.asp?ID=560&CatID=1

    Select size:
    1: Your Chest: 2: Your Waist:
    3: Your Hip: 4: Your Height:

    the same four fields i want here. leatherjackets99.com/product_detailByJacket.asp?ID=822&CatID=36

    Here i updated fields in access db when i test it on local host it gives error.

    Error:

    Technical Information (for support personnel)

    Error Type:
    ADODB.Recordset (0x800A0BCD)
    Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
    /LJN/product_detailByJacket.asp, line 346

    *******

    Here then i go to line 346 and delete loop ( rsSize.movefirst ) it works in localhost.

    I am giving code which is running on product_detailByJacket.asp file.

    *************************
    Codes:

    <%

    sql="select * from SizesDetails where productID="&Request.QueryString("ID")
    set list3 = Conn.execute(sql)
    %>
    <select name="Sizes" class="gray eleven" id="Sizes" style="width:129; height:15" onChange="MM_jumpMenu('parent',this,0)">
    <%

    if sizeID<>"" then

    sql ="select * from sizes where SizeID = "&sizeID
    set rssize111 = conn.execute (sql)

    %>
    <option value="<%=rssize111(0)%>"><%=rssize111(1)%></option>


    <%do while not list3.eof

    sql ="select * from sizes where SizeID = "&list3("SizeID") &" Order by sizename ASC"
    set rssize = conn.execute (sql)
    %>
    <%do while not rsSize.eof
    %>

    <option value="Product_DetailByJacket.asp?ID=<%=ID%>&CatID=<%=CatID%>&sizeID=<%=rsSize(0)%>"><%=rsSize(1)%></option>

    <%
    rsSize.movenext
    loop
    rsSize.movefirst
    list3.movenext
    loop
    %>
    </select>

    <%else%>

    <%

    sql="select * from SizesDetails where productID="&Request.QueryString("ID")&" order by SizeID ASC"
    set rssize111 = conn.execute (sql)
    yy=rssize111(1)
    sql="select * from Sizes where SizeID="&yy
    set rssize1111 = conn.execute (sql)
    %>

    <option value="<%=rssize1111(0)%>"><%=rssize1111(1)%></option>
    <%do while not list3.eof

    sql ="select * from sizes where SizeID = "&list3("SizeID") &" Order by sizename ASC"
    set rssize = conn.execute (sql)
    %>
    <%do while not rsSize.eof
    %>

    <option value="Product_DetailByJacket.asp?ID=<%=ID%>&CatID=<%=CatID%>&sizeID=<%=rsSize(0)%>"><%=rsSize(1)%></option>

    <%
    rsSize.movenext
    loop
    rsSize.movefirst
    list3.movenext
    loop
    %>
    </select>
    <%end if%>

    <%
    if sizeID="" then

    sql="select * from SizesDetails where productID="&Request.QueryString("ID")&" order by SizeID ASC"

    else
    sql="select * from SizesDetails where productID="&Request.QueryString("ID")&" and sizeID="&sizeID
    end if
    set listDetails = Conn.execute(sql)
    %> </td>
    <td><select name="Colors0" class="gray eleven" id="Colors0" style="width: 95">
    <option selected>Default</option>
    <option>Tan</option>
    <option>Khaki</option>
    <option>Black</option>
    <option>Blue</option>
    <option>Olive</option>
    <option>Dark Brown</option>
    <option>Red</option>
    <option>Silver</option>
    </select> </td>
    </tr>
    <tr>
    <td>Skin:</td>
    <td>Leather Type:</td>
    </tr>
    <tr>
    <td>
    <select name="Leather0" class="gray eleven" id="Leather0" style="width: 128; height:18">
    <option>Default</option>
    </select></td>
    <td><select name="LType0" class="gray eleven" id="LType0" style="width: 100; height:16">
    <option selected>Default</option>
    <option>Nappa</option>
    <option>Semi Aniline</option>
    <option>Full Aniline</option>
    <option>Washed</option>
    <option>Water Proof Nappa</option>
    <option>Oily Nappa</option>
    <option>Oil Skipper</option>
    <option>Glazed</option>
    <option>Nubuk</option>
    <option>Snuffed</option>
    <option>Skipper</option>
    <option>Milled Grain</option>
    </select></td>
    </tr>

    *************

    The fields i created in access db are named:

    1: sizeChest
    2: sizeHip
    3: sizeWaist
    4: sizeHeight

    please help me in coding ..Here i want to remove other 3 fields Color, skin and leather type.
     
    malim, Nov 14, 2010 IP