<![CDATA[无爱的天空 - ASP开发]]> http://www.51oyf.com/ zh-cn PBlog2 v2.4 无爱的天空 http://www.51oyf.com/images/logos.gif http://www.51oyf.com/ 无爱的天空 http://www.51oyf.com/article/Asp/201.html <![CDATA[SqlServer中or和and的优先级分析]]> 9337719@qq.com(netfox) Sat,17 Sep 2016 00:50:21 +0800 http://www.51oyf.com/default.asp?id=201
select * from LOAN_BACK_LIBRARY where LIBRARY_ID=1 or LIB_ID=1 and STATUS=3

我想要的结果的条件是：1. LIBRARY_ID=1 或者 LIB_ID=1

                                       2.STATUS=3

但是结果并非如此，出现了STATUS！=3的结果，但是却匹配了 LIBRARY_ID=1 or LIB_ID=1

为什么呢

原来这个SQL的执行是这样的：

select * from LOAN_BACK_LIBRARY where LIBRARY_ID=1 or LIB_ID=1 and STATUS=3

修改为：

select * from LOAN_BACK_LIBRARY where STATUS=3 and LIBRARY_ID=1 or LIB_ID=1 依然不正确

呵呵，发现问题了：

where 后面如果有and,or的条件，则or自动会把左右的查询条件分开，即先执行and，再执行or。原因就是：and的执行优先级最高！

关系型运算符优先级高到低为：not and or

问题的解决办法是：

用()来改变执行顺序！！！！

上面我所需要的SQL语句是这样的

select * from LOAN_BACK_LIBRARY where STATUS=3 and （LIBRARY_ID=1 or LIB_ID=1 ]]> http://www.51oyf.com/article/Asp/194.html <![CDATA[asp取得新插入记录的ID]]> 9337719@qq.com(netfox) Sat,13 Aug 2016 23:55:49 +0800 http://www.51oyf.com/default.asp?id=194     Set rs = server.CreateObject（"adodb.recordset"）
    sql = "select * from table
    rs.addnew
    rs（"title"） = "title"
    rs（"content"） = "content"
    rs.update
    newid = rs（"id"）
    rs.Close
    Set rs = Nothing
    %>
    SQLSERVER用上面的方法不行，必须在Update后多加一句，rs.movelast.
    <%
    Set rs = server.CreateObject（"adodb.recordset"）
    sql = "select * from table
    rs.addnew
    rs（"title"） = "title"
    rs（"content"） = "content"
    rs.update
    rs.movelast
    newid = rs（"id"）
    rs.Close
    Set rs = Nothing
    %>]]> http://www.51oyf.com/article/Asp/188.html <![CDATA[把weekday星期函数的数字变为中文]]> 9337719@qq.com(NetFox) Mon,08 Sep 2014 10:16:01 +0800 http://www.51oyf.com/default.asp?id=188
复制内容到剪贴板程序代码 程序代码


function formatweekday(strdate)
select case strdate
case 1:formatweekday = "日"
case 2:formatweekday = "一"
case 3:formatweekday = "二"
case 4:formatweekday = "三"
case 5:formatweekday = "四"
case 6:formatweekday = "五"
case 7:formatweekday = "六"
end select
end function

]]> http://www.51oyf.com/article/Asp/179.html <![CDATA[SQL中 and or优先级问题]]> 9337719@qq.com(NetFox) Tue,21 May 2013 00:03:49 +0800 http://www.51oyf.com/default.asp?id=179
select * from LOAN_BACK_LIBRARY where LIBRARY_ID=1 or LIB_ID=1 and STATUS=3

我想要的结果的条件是：1. LIBRARY_ID=1 或者 LIB_ID=1

                                       2.STATUS=3

但是结果并非如此，出现了STATUS！=3的结果，但是却匹配了 LIBRARY_ID=1 or LIB_ID=1

为什么呢

原来这个SQL的执行是这样的：

select * from LOAN_BACK_LIBRARY where LIBRARY_ID=1 or LIB_ID=1 and STATUS=3

修改为：

select * from LOAN_BACK_LIBRARY where STATUS=3 and LIBRARY_ID=1 or LIB_ID=1 依然不正确

呵呵，发现问题了：

where 后面如果有and,or的条件，则or自动会把左右的查询条件分开，即先执行and，再执行or。原因就是：and的执行优先级最高！

关系型运算符优先级高到低为：not and or

问题的解决办法是：

用()来改变执行顺序！！！！

上面我所需要的SQL语句是这样的

select * from LOAN_BACK_LIBRARY where STATUS=3 and （LIBRARY_ID=1 or LIB_ID=1 ）

这样就是完美的答案了！！ ]]> http://www.51oyf.com/article/Asp/117.html <![CDATA[在ACCESS中查询今天或者明天过生日的人]]> 9337719@qq.com(NetFox) Sat,21 Aug 2010 19:27:23 +0800 http://www.51oyf.com/default.asp?id=117 SQL="select * from member where Month(birthday)=Month(date()) and Day(birthday)=Day(date())"

查询明天或N天以后
strsql = "select * from  table  where  day(birthday) - day(date()) = N and  month(birthday)=month(date())"

N:表示日期之差,若为1,则是查询明天过生日的人,依次类推...

]]> http://www.51oyf.com/article/Asp/109.html <![CDATA[被忽略的DIM]]> 9337719@qq.com(NetFox) Sun,21 Feb 2010 19:18:11 +0800 http://www.51oyf.com/default.asp?id=109
ASP中，可以不申明变量就直接使用。

所以ASP中的DIM似乎变了没用的东东。

然而，试试用DIM和不用DIM，你会发现DIM是有用的：


<%

dim starttime,x,i,endtime,timefor    ’把这行注释掉分别试试。

starttime=timer()

Response.Write(starttime)

Response.Write("<BR>")

x=0

for i=1 to 1000000

x=x+i

next

Response.Write(x)

Response.Write("<BR>")

endtime=timer()

Response.Write(endtime)

Response.Write("<BR>")

timefor= FormatNumber((endtime-starttime),4)

Response.Write("用时" & timefor & "秒")

%>

有DIM和执行时间是0。5秒，而没有DIM的执行时间在1秒以上。整整慢了一倍。。。。
以后该用option explicit ‘强制申明变量了
]]> http://www.51oyf.com/article/Asp/96.html <![CDATA[汉字转声母]]> 9337719@qq.com(NetFox) Sat,11 Jul 2009 21:09:46 +0800 http://www.51oyf.com/default.asp?id=96
复制内容到剪贴板程序代码 程序代码


<%
function getpychar(char)
tmp=65536+asc(char)
if(tmp>=45217 and tmp<=45252) then
getpychar= "A"
elseif(tmp>=45253 and tmp<=45760) then
getpychar= "B"
elseif(tmp>=45761 and tmp<=46317) then
getpychar= "C"
elseif(tmp>=46318 and tmp<=46825) then
getpychar= "D"
elseif(tmp>=46826 and tmp<=47009) then  
getpychar= "E"
elseif(tmp>=47010 and tmp<=47296) then  
getpychar= "F"
elseif(tmp>=47297 and tmp<=47613) then  
getpychar= "G"
elseif(tmp>=47614 and tmp<=48118) then
getpychar= "H"
elseif(tmp>=48119 and tmp<=49061) then
getpychar= "J"
elseif(tmp>=49062 and tmp<=49323) then  
getpychar= "K"
elseif(tmp>=49324 and tmp<=49895) then  
getpychar= "L"
elseif(tmp>=49896 and tmp<=50370) then  
getpychar= "M"
elseif(tmp>=50371 and tmp<=50613) then  
getpychar= "N"
elseif(tmp>=50614 and tmp<=50621) then  
getpychar= "O"
elseif(tmp>=50622 and tmp<=50905) then
getpychar= "P"
elseif(tmp>=50906 and tmp<=51386) then  
getpychar= "Q"
elseif(tmp>=51387 and tmp<=51445) then  
getpychar= "R"
elseif(tmp>=51446 and tmp<=52217) then  
getpychar= "S"
elseif(tmp>=52218 and tmp<=52697) then  
getpychar= "T"
elseif(tmp>=52698 and tmp<=52979) then  
getpychar= "W"
elseif(tmp>=52980 and tmp<=53688) then  
getpychar= "X"
elseif(tmp>=53689 and tmp<=54480) then  
getpychar= "Y"
elseif(tmp>=54481 and tmp<=62289) then
getpychar= "Z"
else '如果不是中文，则不处理
getpychar=char
end if
end function

function getpy(str)
for i=1 to len(str)
getpy=getpy & getpychar(mid(str,i,1))
next
end function
response.write getpy("维尔康复日期万恶哦请我呢人气哦颇为而当年去玩儿")
%>


]]> http://www.51oyf.com/article/Asp/94.html <![CDATA[ASP获取客户端真实IP地址]]> 9337719@qq.com(NetFox) Sat,23 May 2009 08:38:36 +0800 http://www.51oyf.com/default.asp?id=94
Request对象里有个ServerVariables的数据集合，也是本文要用到的，叫服务器环境变量，它能够自动获得客户端的很多信息，由于这个集合的变量比较多，本文只列少许常用的：
ALL_HTTP      客户端发送的所有 HTTP 标题文件。
CONTENT_LENGTH      客户端发出内容的长度。
CONTENT_TYPE      内容的数据类型。如：“text/html”。同附加信息 的查询一起使用，如 HTTP 查询 GET、POST 和 PUT。
LOCAL_ADDR      返回接受请求的服务器地址。如果在绑定多个IP 地址的多宿主机器上查找请求所使用的地址 时，这条变量非常重要。
LOGON_USER      用户登录 Windows NT 的账号。
QUERY_STRING      查询 HTTP 请求中问号（?）后的信息。
REMOTE_ADDR      发出请求的远程主机 (client) 的 IP 地址。
REMOTE_HOST      发出请求的主机 (client) 名称。如果服务器无此 信息，它将设置为空的　MOTE_ADDR 变量。
REQUEST_METHOD      该方法用于提出请求。相当于用于 HTTP 的 GET、HEAD、POST等 等。
SERVER_NAME      出现在自引用 URL 中的服务器主机名、DNS 化名 或 IP 地址。
SERVER_PORT      发送请求的端口号。

实现
复制内容到剪贴板程序代码 程序代码


Function GetClientIp()
    Dim strIPAddr
    If Request.ServerVariables("HTTP_X_FORWARDED_FOR") = "" or InStr(Request.ServerVariables("HTTP_X_FORWARDED_FOR"), "unknown") > 0 Then
        strIPAddr = Request.ServerVariables("REMOTE_ADDR")
    ElseIf InStr(Request.ServerVariables("HTTP_X_FORWARDED_FOR"), ",") > 0 Then
        strIPAddr = Mid(Request.ServerVariables("HTTP_X_FORWARDED_FOR"), 1, InStr(Request.ServerVariables("HTTP_X_FORWARDED_FOR"), ",")-1)
    ElseIf InStr(Request.ServerVariables("HTTP_X_FORWARDED_FOR"), ";") > 0 Then
        strIPAddr = Mid(Request.ServerVariables("HTTP_X_FORWARDED_FOR"), 1, InStr(Request.ServerVariables("HTTP_X_FORWARDED_FOR"), ";")-1)
    Else
        strIPAddr = Request.ServerVariables("HTTP_X_FORWARDED_FOR")
    End If

    GetClientIp = Trim(Mid(strIPAddr, 1, 30))
End Function

]]> http://www.51oyf.com/article/Asp/51.html <![CDATA[表单数据大于100k的处理]]> 9337719@qq.com(NetFox) Fri,13 Jul 2007 12:40:08 +0800 http://www.51oyf.com/default.asp?id=51 Content = ""
For i = 1 To Request.Form("content").Count
  Content = Content & Request.Form("content")(i)
Next
%>
]]> http://www.51oyf.com/article/Asp/41.html <![CDATA[ASP中文转拼音函数]]> 9337719@qq.com(NetFox) Thu,08 Mar 2007 00:22:39 +0800 http://www.51oyf.com/default.asp?id=41

复制内容到剪贴板程序代码 程序代码

<%
Set d = CreateObject("Scripting.Dictionary")
d.add "a",-20319
d.add "ai",-20317
d.add "an",-20304
d.add "ang",-20295
d.add "ao",-20292
d.add "ba",-20283
d.add "bai",-20265
d.add "ban",-20257
d.add "bang",-20242
d.add "bao",-20230
d.add "bei",-20051
d.add "ben",-20036
d.add "beng",-20032
d.add "bi",-20026
d.add "bian",-20002
d.add "biao",-19990
d.add "bie",-19986
d.add "bin",-19982
d.add "bing",-19976
d.add "bo",-19805
d.add "bu",-19784
d.add "ca",-19775
d.add "cai",-19774
d.add "can",-19763
d.add "cang",-19756
d.add "cao",-19751
d.add "ce",-19746
d.add "ceng",-19741
d.add "cha",-19739
d.add "chai",-19728
d.add "chan",-19725
d.add "chang",-19715
d.add "chao",-19540
d.add "che",-19531
d.add "chen",-19525
d.add "cheng",-19515
d.add "chi",-19500
d.add "chong",-19484
d.add "chou",-19479
d.add "chu",-19467
d.add "chuai",-19289
d.add "chuan",-19288
d.add "chuang",-19281
d.add "chui",-19275
d.add "chun",-19270
d.add "chuo",-19263
d.add "ci",-19261
d.add "cong",-19249
d.add "cou",-19243
d.add "cu",-19242
d.add "cuan",-19238
d.add "cui",-19235
d.add "cun",-19227
d.add "cuo",-19224
d.add "da",-19218
d.add "dai",-19212
d.add "dan",-19038
d.add "dang",-19023
d.add "dao",-19018
d.add "de",-19006
d.add "deng",-19003
d.add "di",-18996
d.add "dian",-18977
d.add "diao",-18961
d.add "die",-18952
d.add "ding",-18783
d.add "diu",-18774
d.add "dong",-18773
d.add "dou",-18763
d.add "du",-18756
d.add "duan",-18741
d.add "dui",-18735
d.add "dun",-18731
d.add "duo",-18722
d.add "e",-18710
d.add "en",-18697
d.add "er",-18696
d.add "fa",-18526
d.add "fan",-18518
d.add "fang",-18501
d.add "fei",-18490
d.add "fen",-18478
d.add "feng",-18463
d.add "fo",-18448
d.add "fou",-18447
d.add "fu",-18446
d.add "ga",-18239
d.add "gai",-18237
d.add "gan",-18231
d.add "gang",-18220
d.add "gao",-18211
d.add "ge",-18201
d.add "gei",-18184
d.add "gen",-18183
d.add "geng",-18181
d.add "gong",-18012
d.add "gou",-17997
d.add "gu",-17988
d.add "gua",-17970
d.add "guai",-17964
d.add "guan",-17961
d.add "guang",-17950
d.add "gui",-17947
d.add "gun",-17931
d.add "guo",-17928
d.add "ha",-17922
d.add "hai",-17759
d.add "han",-17752
d.add "hang",-17733
d.add "hao",-17730
d.add "he",-17721
d.add "hei",-17703
d.add "hen",-17701
d.add "heng",-17697
d.add "hong",-17692
d.add "hou",-17683
d.add "hu",-17676
d.add "hua",-17496
d.add "huai",-17487
d.add "huan",-17482
d.add "huang",-17468
d.add "hui",-17454
d.add "hun",-17433
d.add "huo",-17427
d.add "ji",-17417
d.add "jia",-17202
d.add "jian",-17185
d.add "jiang",-16983
d.add "jiao",-16970
d.add "jie",-16942
d.add "jin",-16915
d.add "jing",-16733
d.add "jiong",-16708
d.add "jiu",-16706
d.add "ju",-16689
d.add "juan",-16664
d.add "jue",-16657
d.add "jun",-16647
d.add "ka",-16474
d.add "kai",-16470
d.add "kan",-16465
d.add "kang",-16459
d.add "kao",-16452
d.add "ke",-16448
d.add "ken",-16433
d.add "keng",-16429
d.add "kong",-16427
d.add "kou",-16423
d.add "ku",-16419
d.add "kua",-16412
d.add "kuai",-16407
d.add "kuan",-16403
d.add "kuang",-16401
d.add "kui",-16393
d.add "kun",-16220
d.add "kuo",-16216
d.add "la",-16212
d.add "lai",-16205
d.add "lan",-16202
d.add "lang",-16187
d.add "lao",-16180
d.add "le",-16171
d.add "lei",-16169
d.add "leng",-16158
d.add "li",-16155
d.add "lia",-15959
d.add "lian",-15958
d.add "liang",-15944
d.add "liao",-15933
d.add "lie",-15920
d.add "lin",-15915
d.add "ling",-15903
d.add "liu",-15889
d.add "long",-15878
d.add "lou",-15707
d.add "lu",-15701
d.add "lv",-15681
d.add "luan",-15667
d.add "lue",-15661
d.add "lun",-15659
d.add "luo",-15652
d.add "ma",-15640
d.add "mai",-15631
d.add "man",-15625
d.add "mang",-15454
d.add "mao",-15448
d.add "me",-15436
d.add "mei",-15435
d.add "men",-15419
d.add "meng",-15416
d.add "mi",-15408
d.add "mian",-15394
d.add "miao",-15385
d.add "mie",-15377
d.add "min",-15375
d.add "ming",-15369
d.add "miu",-15363
d.add "mo",-15362
d.add "mou",-15183
d.add "mu",-15180
d.add "na",-15165
d.add "nai",-15158
d.add "nan",-15153
d.add "nang",-15150
d.add "nao",-15149
d.add "ne",-15144
d.add "nei",-15143
d.add "nen",-15141
d.add "neng",-15140
d.add "ni",-15139
d.add "nian",-15128
d.add "niang",-15121
d.add "niao",-15119
d.add "nie",-15117
d.add "nin",-15110
d.add "ning",-15109
d.add "niu",-14941
d.add "nong",-14937
d.add "nu",-14933
d.add "nv",-14930
d.add "nuan",-14929
d.add "nue",-14928
d.add "nuo",-14926
d.add "o",-14922
d.add "ou",-14921
d.add "pa",-14914
d.add "pai",-14908
d.add "pan",-14902
d.add "pang",-14894
d.add "pao",-14889
d.add "pei",-14882
d.add "pen",-14873
d.add "peng",-14871
d.add "pi",-14857
d.add "pian",-14678
d.add "piao",-14674
d.add "pie",-14670
d.add "pin",-14668
d.add "ping",-14663
d.add "po",-14654
d.add "pu",-14645
d.add "qi",-14630
d.add "qia",-14594
d.add "qian",-14429
d.add "qiang",-14407
d.add "qiao",-14399
d.add "qie",-14384
d.add "qin",-14379
d.add "qing",-14368
d.add "qiong",-14355
d.add "qiu",-14353
d.add "qu",-14345
d.add "quan",-14170
d.add "que",-14159
d.add "qun",-14151
d.add "ran",-14149
d.add "rang",-14145
d.add "rao",-14140
d.add "re",-14137
d.add "ren",-14135
d.add "reng",-14125
d.add "ri",-14123
d.add "rong",-14122
d.add "rou",-14112
d.add "ru",-14109
d.add "ruan",-14099
d.add "rui",-14097
d.add "run",-14094
d.add "ruo",-14092
d.add "sa",-14090
d.add "sai",-14087
d.add "san",-14083
d.add "sang",-13917
d.add "sao",-13914
d.add "se",-13910
d.add "sen",-13907
d.add "seng",-13906
d.add "sha",-13905
d.add "shai",-13896
d.add "shan",-13894
d.add "shang",-13878
d.add "shao",-13870
d.add "she",-13859
d.add "shen",-13847
d.add "sheng",-13831
d.add "shi",-13658
d.add "shou",-13611
d.add "shu",-13601
d.add "shua",-13406
d.add "shuai",-13404
d.add "shuan",-13400
d.add "shuang",-13398
d.add "shui",-13395
d.add "shun",-13391
d.add "shuo",-13387
d.add "si",-13383
d.add "song",-13367
d.add "sou",-13359
d.add "su",-13356
d.add "suan",-13343
d.add "sui",-13340
d.add "sun",-13329
d.add "suo",-13326
d.add "ta",-13318
d.add "tai",-13147
d.add "tan",-13138
d.add "tang",-13120
d.add "tao",-13107
d.add "te",-13096
d.add "teng",-13095
d.add "ti",-13091
d.add "tian",-13076
d.add "tiao",-13068
d.add "tie",-13063
d.add "ting",-13060
d.add "tong",-12888
d.add "tou",-12875
d.add "tu",-12871
d.add "tuan",-12860
d.add "tui",-12858
d.add "tun",-12852
d.add "tuo",-12849
d.add "wa",-12838
d.add "wai",-12831
d.add "wan",-12829
d.add "wang",-12812
d.add "wei",-12802
d.add "wen",-12607
d.add "weng",-12597
d.add "wo",-12594
d.add "wu",-12585
d.add "xi",-12556
d.add "xia",-12359
d.add "xian",-12346
d.add "xiang",-12320
d.add "xiao",-12300
d.add "xie",-12120
d.add "xin",-12099
d.add "xing",-12089
d.add "xiong",-12074
d.add "xiu",-12067
d.add "xu",-12058
d.add "xuan",-12039
d.add "xue",-11867
d.add "xun",-11861
d.add "ya",-11847
d.add "yan",-11831
d.add "yang",-11798
d.add "yao",-11781
d.add "ye",-11604
d.add "yi",-11589
d.add "yin",-11536
d.add "ying",-11358
d.add "yo",-11340
d.add "yong",-11339
d.add "you",-11324
d.add "yu",-11303
d.add "yuan",-11097
d.add "yue",-11077
d.add "yun",-11067
d.add "za",-11055
d.add "zai",-11052
d.add "zan",-11045
d.add "zang",-11041
d.add "zao",-11038
d.add "ze",-11024
d.add "zei",-11020
d.add "zen",-11019
d.add "zeng",-11018
d.add "zha",-11014
d.add "zhai",-10838
d.add "zhan",-10832
d.add "zhang",-10815
d.add "zhao",-10800
d.add "zhe",-10790
d.add "zhen",-10780
d.add "zheng",-10764
d.add "zhi",-10587
d.add "zhong",-10544
d.add "zhou",-10533
d.add "zhu",-10519
d.add "zhua",-10331
d.add "zhuai",-10329
d.add "zhuan",-10328
d.add "zhuang",-10322
d.add "zhui",-10315
d.add "zhun",-10309
d.add "zhuo",-10307
d.add "zi",-10296
d.add "zong",-10281
d.add "zou",-10274
d.add "zu",-10270
d.add "zuan",-10262
d.add "zui",-10260
d.add "zun",-10256
d.add "zuo",-10254

function g(num)
if num>0 and num<160 then
g=chr(num)
else
if num<-20319 or num>-10247 then
g=""
else
a=d.Items
b=d.keys
for i=d.count-1 to 0 step -1
if a(i)<=num then exit for
next
g=b(i)
end if
end if
end function
function c(str)
c=""
for i=1 to len(str)
c=c&g(asc(mid(str,i,1)))
next
end function
'response.write c(request("hz"))
%>

<%'=c(rs("title"))%>
]]>