?? sql.asp
字號:
if NAME1<>"" and SORT1<>"" and y<>"" and m<>"" and d<>"" and WRITER<>"" and CONCERN<>"" then
sql=sql&" where "
end if
i=0
if NAME1<>"" then
if i<>0 then sql=sql&" and "
sql=sql&" [name] like '%"&name1&"%'"
i=1+1
elseif SORT1<>"" then
if i<>0 then sql=sql&" and "
sql=sql&" [SORT]="&SORT1&" "
i=1+1
elseif y<>"" then
if i<>0 then sql=sql&" and "
sql=sql&" year(date) = "&y&""
i=1+1
elseif m<>"" then
if i<>0 then sql=sql&" and "
sql=sql&" month(date) = "&m&""
i=1+1
elseif d<>"" then
if i<>0 then sql=sql&" and "
sql=sql&" day(date) = "&d&""
i=1+1
elseif WRITER<>"" then
if i<>0 then sql=sql&" and "
sql=sql&" [WRITER] like '%"&WRITER&"%'"
i=1+1
elseif CONCERN<>"" then
if i<>0 then sql=sql&" and "
sql=sql&" [CONCERN] like '%"&CONCERN&"%'"
i=1+1
else
end if
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -