大家发些ASP常用代码段，跟帖跟分

veiny 2008-10-23 07:45:13

加精

我先来一点，

Function GetSafeStr(str)

	GetSafeStr=Replace(Replace(Replace(Replace(Replace(str,"'","‘"),"""","“"),"&",""),"<","<"),">",">")

End Function

...全文

5918 195 打赏收藏转发到动态举报

写回复

用AI写文章

195 条回复

切换为时间正序

请发表友善的回复…

发表回复

kityjuan 2012-10-11

打赏
举报

td {
border-width: 1px;
onMouseOut: expression(onmouseout=cTo('#ff00ff'));
onMouseOver: expression(onMouseOver=cBack('white'));
}

MyLinda 2012-06-06

打赏
举报

[Quote=引用 196 楼的回复:]

有没有人能帮我看下这段代码错在哪啊？
Sql = "Select * From [people_on_duty] Where branch="&danwei&" and datem="&date&""
查记录的时候，如果只一个条件是能查到的，如果两个条件则查不到。
我的数据库中存在同时符合两个条件的记录
[/Quote]
ASP里面时间要加#

zwei_78 2012-06-01

打赏
举报

有没有人能帮我看下这段代码错在哪啊？
Sql = "Select * From [people_on_duty] Where branch="&danwei&" and datem="&date&""
查记录的时候，如果只一个条件是能查到的，如果两个条件则查不到。
我的数据库中存在同时符合两个条件的记录

Aqwe23 2012-05-14

打赏
举报

基本的登录页面
<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" >
<mx:Script>
<![CDATA[
import mx.collections.ArrayCollection;
import mx.rpc.events.ResultEvent;
import mx.controls.Alert;
[Bindable]
//private var result1:ArrayCollection;
private var login_result:String;
[Bindable]
private var sendChoice:String;
private function goLogin():void{
if(username.text=="" || userpwd.text=="")
Alert.show("没有填写用户名或密码");
else{
sendChoice="login";
login.send();
}
}
private function goRegis():void{
if(username.text=="" || userpwd.text=="")
Alert.show("没有填写用户名或密码");
else{
sendChoice="regis";
login.send();
}
}

private function resultHandler(event:ResultEvent):void{
// login_result=event.result.html.body.users.a.toString();
login_result =event.result.users.a.toString() ;
if(login_result=="ok"){
Alert.show("欢迎，登录成功");
}
if(login_result=="nohave"){
Alert.show("没有找到这个用户名请先注册！");
}
if(login_result=="pwderror"){
Alert.show("密码错误！请从新登陆！");
}
if(login_result=="nameishave"){
Alert.show("用户名已经存在，请选择别的用户名注册");
}
if(login_result=="regisok"){
Alert.show("注册成功，请从新登陆");
}
if(login_result=="error"){
Alert.show("错误");
}
}
]]>
</mx:Script>
<mx:HTTPService id="login" method="POST" showBusyCursor="true" url="http://localhost/flex/Flexlogin.php"
result="resultHandler(event)">
<mx:request xmlns="">
<mx:username>
{username.text}
</mx:username>
<mx:userpwd>
{userpwd.text}
</mx:userpwd>
<mx:sendchoice>
{sendChoice}
</mx:sendchoice>
</mx:request>
</mx:HTTPService>
<mx:Panel width="310" height="265" layout="absolute" title="登录" fontSize="12" fontWeight="normal" horizontalCenter="13" verticalCenter="-239">
<mx:TextInput id="username" fontSize="12" restrict="0-9,a-z" maxChars="8" x="0" y="0"/>
<mx:TextInput id="userpwd" fontSize="12" displayAsPassword="true" maxChars="8" restrict="0-9,a-z" x="0" y="30"/>
<mx:Button label="登录" id="btn1" click="goLogin()" fontWeight="normal" fontSize="12" x="0" y="60"/>
<mx:Label text="用户名：" fontSize="12" x="0" y="90"/>
<mx:Label text="密码：" fontSize="12" x="0" y="116"/>
<mx:Button label="注册" fontSize="12" fontWeight="normal" id="btn2" click="goRegis()" x="0" y="142"/>
<mx:Label text="测试用用户名 user 密码 1234" fontSize="12" width="243" x="0" y="172"/>
</mx:Panel>

</mx:Application>

xylllamm 2012-02-14

打赏
举报

abcdc1111 2012-02-06

打赏
举报

<DIV id="scrollobj" style="white-space:nowrap;overflow:hidden;width:865px; line-height:43px;"><%Do While Not rs.Eof
Set Rs12 = Server.CreateObject("ADODB.RecordSet")
Sql12 = "SELECT * FROM jiangpin where id ="&rs("jid")&""
Rs12.Open Sql12,Conn,1,1
do while not Rs12.eof %><span style="color:#FF0000">恭喜
<%
Set Rs123 = Server.CreateObject("ADODB.RecordSet")
Sql123 = "SELECT * FROM hyk where hyk_uid ='"&rs("uname")&"'"
Rs123.Open Sql123,Conn,1,1
do while not Rs123.eof
response.Write Rs123("hyk_dj")
Rs123.movenext
loop
Rs123.close
set Rs123=nothing
%>
会员：[<%=rs("uname")%>] 中得§<%if Rs12("jp_dengji")=1 then
response.Write"特等奖"
elseif Rs12("jp_dengji")=2 then
response.Write"一等奖"
elseif Rs12("jp_dengji")=3 then
response.Write"二等奖"
elseif Rs12("jp_dengji")=4 then
response.Write"三等奖"
elseif Rs12("jp_dengji")=5 then
response.Write"四等奖"
elseif Rs12("jp_dengji")=6 then
response.Write"五等奖"
elseif Rs12("jp_dengji")=7 then
response.Write"六等奖"
end if%>§【<%=Rs12("jp_name")%>】； </span><% Rs12.movenext
loop
rs.movenext
loop%></DIV>
<script language="javascript" type="text/javascript">
function scroll(obj) {
var tmp = (obj.scrollLeft)++;
if (obj.scrollLeft==tmp) obj.innerHTML += obj.innerHTML;
if (obj.scrollLeft>=obj.firstChild.offsetWidth) obj.scrollLeft=0;
}
setInterval("scroll(document.getElementById('scrollobj'))",1);
</script>