1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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.
    SEMrush
    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
    SEMrush