神马品牌网3d烤漆材质参数:ASP判断问题,急!
来源：百度文库 编辑：神马品牌网 时间：2024/04/28 12:42:42
如果输入的值和数据库中有相同的
就提示已经申请
如果没有和数据库中有相同的
就写入数据库
就是这地方有点不明白怎么写
请帮我看看以下代码的问题出在什么地方.谢谢
<!--#include file="conn.asp"-->
<% dim str ,logofrom,logolink
logofrom=request ("logofrom")
logolink=request ("logolink")
set rs=Server.Createobject("ADODB.Recordset")
str="select * from Friendship"
rs.open str,conndb,1,3
If logofrom="http://" then
Response.Write("<script language=javascript>alert('请输入您的LOGO地址！');history.back()</script>")
end if
if logolink="http://" then
Response.Write("<script language=javascript>alert('请输入您的网站地址！');history.back()</script>")
end if
if logofrom=rs("Friendship_img") then
Response.Write("<script language=javascript>alert('您已经申请过了,不用再次申请!');window.close()</script>")
else
rs.addnew
rs("Friendship_img")=logolink
rs("Friendship_link")=logolink
rs.update
response.write "<script language='javascript'>"
response.write "alert('你已经成功加入，请等候站长的审核!');window.close()"
response.end
end if
set rs=nothing
set condb=nothing
%>
<!--#include file="conn.asp"-->
<% dim str ,logofrom,logolink
logofrom=request ("logofrom")
logolink=request ("logolink")
If logofrom="http://" then
Response.Write("<script language=javascript>alert('请输入您的LOGO地址！');history.back()</script>")
end if
if logolink="http://" then
Response.Write("<script language=javascript>alert('请输入您的网站地址！');history.back()</script>")
end if
set rs=Server.Createobject("ADODB.Recordset")
str="select * from Friendship where Friendship_img='"& logofrom&"'"
rs.open str,conndb,1,3
if not(rs.eof or rs.bof) then
Response.Write("<script language=javascript>alert('您已经申请过了,不用再次申请!');window.close()</script>")
else
rs.addnew
rs("Friendship_img")=logolink
rs("Friendship_link")=logolink
rs.update
response.write "<script language='javascript'>"
response.write "alert('你已经成功加入，请等候站长的审核!');window.close()"
response.end
end if
set rs=nothing
set condb=nothing
%>
if logofrom=rs("Friendship_img") then
Response.Write("<script language=javascript>alert('您已经申请过了,不用再次申请!');window.close()</script>")
我认为这句有问题?
改:
<!--#include file="conn.asp"-->
<%
dim str ,logofrom,logolink
logofrom=request ("logofrom")
logolink=request ("logolink")
If logofrom="http://" then
Response.Write("<script language=javascript>alert('请输入您的LOGO地址！');history.back()</script>")
end if
if logolink="http://" then
Response.Write("<script language=javascript>alert('请输入您的网站地址！');history.back()</script>")
end if
'要就像楼上说的,
set rs=Server.Createobject("ADODB.Recordset")
str="select * from Friendship where Friendship_img='"&logofrom&"'"
rs.open str,conndb,1,3
if rs.EOF then '如果没有就添加
rs.addnew
...
rs.update
else
Response.Write("<script language=javascript>alert('您已经申请过了,不用再次申请!');window.close()</script>")
end if
%>
没太看明白你的意思 是不是这样
str="select * from Friendship where Friendship_img ='"&logofrom &"'" '查找数据库中有没有
if rs.eof then '如果没有就添加
rs.addnew
...
end if
if logofrom=rs("Friendship_img") then
Response.Write("<script language=javascript>alert('您已经申请过了,不用再次申请!');window.close()</script>")
else
你在这里要加循环查询,你在这里判断的是键值一个Friendship_img是否等于logofrom
do until rs.eof
if logofrom=rs("Friendship_img") then
Response.Write("<script language=javascript>alert('您已经申请过了,不用再次申请!');window.close()</script>")
else
rs.addnew
rs("Friendship_img")=logolink
rs("Friendship_link")=logolink
rs.update
response.write "<script language='javascript'>"
response.write "alert('你已经成功加入，请等候站长的审核!');window.close()"
response.end
end if
loop