|
How to use this form.
1. Choose your specification.
2. Please note your requirement in 'other technical requirement' if
you have any.
3. Please save after filling up blanks
4. Please repeat No.1, 2 & 3 if you need to add items
5. Please send your inquiry after clicking department which you want
to send to. |
<%
Set rs = server.createobject("adodb.recordset")
sessionid = session.sessionid
strSql = "select count(sid) from tbBasket where sessionid = '" & sessionid &"' and category = 'flooring'"
rs.open strSql,Application("dbSangjin"), 1
nCount = rs(0)
rs.Close
if nCount > 0 then
strSql = "SELECT sid,material,bearing,bsize,bpitch,grating,surface,endbar,esize FROM "
strSql = strSql & "tbBasket where sessionid = '" & sessionid & "' and category = 'flooring'"
rs.open strSql,Application("dbSangjin"), 1
num = "1"
For i = 1 to nCount
if rs.EOF then
exit for
end if
sid = Trim(rs("sid"))
material = Trim(rs("material"))
bearing = Trim(rs("bearing"))
bsize = Trim(rs("bsize"))
bpitch = Trim(rs("bpitch"))
grating = Trim(rs("grating"))
surface = Trim(rs("surface"))
endbar = Trim(rs("endbar"))
esize = Trim(rs("esize"))
material = material& "/" &bearing& "/" &bsize& "/" &bpitch& "/" &endbar& "/" &esize& "/" &surface& "/" &grating
%>
| <%=num%> |
<%=material%> |
[delete] |
<%
num = num + 1
rs.movenext
next
rs.Close
end if
%>
<%if nCount > 0 then%>
<%end if%>
|
|