主题:表单相关
初学者xiaoyi
[专家分:30] 发布于 2007-11-24 13:35:00
<form action="gouwu.asp?id=<%=rs("bookid")%>&action=add" method="post" name="form1">
<%response.write trim(rs("bookname"))%>
<input name="bookid" type="checkbox" value="<%=rs("bookid")%>"> '这个是循环输出的
</form>
现在我要把打钩的<%response.write trim(rs("bookname"))%>的<%=rs("bookid")%>
全部加到 action="gouwu.asp?id=<%=rs("bookid")%>&action=add" 中的<%=rs("bookid")%>处要怎么加!
谢谢!
回复列表 (共10个回复)
沙发
wangsdong [专家分:21390] 发布于 2007-11-24 14:19:00
不需要这样,直接提交就可以解决了
板凳
初学者xiaoyi [专家分:30] 发布于 2007-11-24 14:41:00
能说的详细点吗?
<form action="gouwu.asp" method="post" name="form1">
如果是这样不行啊!
3 楼
wangsdong [专家分:21390] 发布于 2007-11-24 15:01:00
<form action="gouwu.asp" method="post" name="form1">
<input type="checkbox" name="f1" value="1">1<br>
<input type="checkbox" name="f1" value="2">2<br>
<input type="checkbox" name="f1" value="3">3<br>
<input type="checkbox" name="f1" value="4">4<br>
<input type="submit" value="提交">
</form>
gouwu.asp中的代码
<%
f=request("f1")
response.write "获取到的值是:"&f
%>
运行看看结果
4 楼
初学者xiaoyi [专家分:30] 发布于 2007-11-24 15:59:00
测试可以传递过来的直的!
但是这样的话 <form action="gouwu.asp" method="post" name="form1">
转到哪个页面就是空白拉!
'------------gouwu.asp 页面代码
select case action
case "del"
conn.execute "delete from shop_action where actionid="&request.QueryString("actionid")
if request.QueryString("ll")=22 then
response.redirect "myuser.asp?action=shoucang"
else
response.redirect "gouwu.asp?action=show"
end if
response.End
case "add"
'//商品,判断是否存在
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select * from shop_books where bookid="&bookid,conn,1,1
if request.Cookies("vshop")("reglx")=2 then
danjia=rs_s("vipjia")
else
danjia=rs_s("huiyuanjia")
end if
kucun=rs_s("kucun")
bookname=rs_s("bookname")
shjiaid=rs_s("shjiaid")
rs_s.close
set rs_s=nothing
if kucun<=0 then
response.write "<script language=javascript>alert('你选购的商品“"&bookname&"”暂时缺货不能放到购物车里,请选购其它商品!');window.close();</script>"
response.end
end if
set rs=server.CreateObject("adodb.recordset")
rs.open "select bookid,username,bookcount,zonger from shop_action where username='"&username&"' and bookid="&bookid&" and zhuangtai=7",conn,1,3
if rs.recordcount=1 then
if kucun<(rs("bookcount")+1) then
response.write "<script language=javascript>alert('你选购的商品“"&bookname&"”暂时缺货不能放到购物车里,请选购其它商品!');window.close();</script>"
response.end
end if
rs("zonger")=(rs("bookcount")+1)*danjia
rs("bookcount")=rs("bookcount")+1
rs.update
rs.close
set rs=nothing
response.Redirect "gouwu.asp?action=show"
else
'//添加购物
rs.close
set rs=server.CreateObject("adodb.recordset")
rs.open "select bookid,username,shjiaid,zhuangtai,zonger,bookcount,niming from shop_action",conn,1,3
rs.addnew
rs("bookid")=bookid
rs("username")=username
rs("zhuangtai")=7
rs("bookcount")=1
rs("shjiaid")=shjiaid
rs("zonger")=danjia
if request.Cookies("vshop")("username")="" then
rs("niming")=1
end if
rs.update
rs.close
set rs=nothing
response.Redirect "gouwu.asp?action=show"
5 楼
tianyu123 [专家分:2570] 发布于 2007-11-24 17:35:00
<form action="gouwu.asp[color=FF0000]?action=add[/color]" method="post" name="form1">
6 楼
初学者xiaoyi [专家分:30] 发布于 2007-11-26 09:14:00
Microsoft JET Database Engine 错误 '80040e14'
语法错误 (操作符丢失) 在查询表达式 'bookid=5 ,1中。
/gouwu.asp,行 54
rs_s.open "select * from shop_books where bookid="&bookid,conn,1,1 '---554行---
如果改成这样
rs_s.open "select * from shop_books where bookid="&request.form("bookid"),conn,1,1
在查询表达式 bookid=5 ,1时候出错! 要怎么样写才能同时查寻多个记录并输出拉!
谢谢楼上帮助!
7 楼
tianyu123 [专家分:2570] 发布于 2007-11-26 10:39:00
bookid=request.form("bookid")
rs_s.open "select * from shop_books where bookid [color=FF0000]in("& bookid &")",[/color]conn,1,1
8 楼
初学者xiaoyi [专家分:30] 发布于 2007-11-26 11:17:00
这样是不会出错拉!但是要怎么都输出拉!
还有如果只有一个商品没有库存,下面要怎么改拉! 望求教!谢谢!
<%if kucun<=0 then
response.write "<script language=javascript>alert('你选购的商品“"&bookname&"”暂时缺货不能放到购物车里,请选购其它商品!');window.close();</script>"
response.end
end if%>
9 楼
tianyu123 [专家分:2570] 发布于 2007-11-26 12:05:00
bookid=request.form("bookid")
bookid=split(bookid,",")
for i=0 to ubound(bookid)
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * from shop_books where bookid="&bookid(i),conn,1,1
if kucun<=0 then
response.write "<script language=javascript>alert('你选购的商品“"&bookname&"”暂时缺货不能放到购物车里,请选购其它商品!');window.close();</script>"
response.end
else
'输出
end if
next
10 楼
初学者xiaoyi [专家分:30] 发布于 2007-11-26 14:00:00
谢谢楼上拉的!问题解决!
我来回复