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