jquery 過濾 ajax 傳回HTML值
Code
$.get("/product/favproduct.asp",function(data){
var stext = $(data).find('div#listBuy').html();
$(".list").html(stext)
})
key:jquery ajax 傳回值 過濾
Javascript 正規表達式中的後向引用
Code
$(".nextPage a").live("click",function(){
var url= $(".Switch ul li[class='current'] a").attr("href");
var href = $(this).attr("href")
var pattern = /pagecurrent=(\d)/ig
if(pattern.test(href))
{
var intpagesize = RegExp.$1;//表示與模式中第一個括号比對的内容
url += "?pagecurrent="+intpagesize
}
InvokeAjax(url)
return false
});
key:javascript 正則 引用
Jquery find 和filter 的差別
Code
<div class="css">
<p class="rain">測試1</p>
</div>
<div class="rain">
<p>測試2</p>
</div>
測試
var $find = $("div").find(".rain");
alert( $find.html() ) ;
輸出：？
var $filter = $("div").filter(".rain");
alert( $filter.html() );
輸出：？
find()會在div元素内 尋找 class為rain 的元素。
而filter()則是篩選div的class為rain的元素。
一個是對它的子集操作，一個是對自身集合元素篩選。
另外find()其實還可以用選擇器表示:
var $select = $("div .rain");
原文連結：http://www.cssrain.cn/article.asp?id=1086
CSS 永遠置底
http://www.cssstickyfooter.com/cn/using-sticky-footer-code.html
Jquery 模仿使用者操作？
$("#Exhibit").click();//觸發ID為Exhibit的元素的單擊事件
//或
$("#Exhibit").trigger(“click”);
//當一個操作會觸發1個以上事件時先綁定的先執行
更新存儲過程使用VSS
FTP CMD 指令
Jquery fn.Load 方法 加載指定塊中的HTML
$("#divLoginfloat").load("/user/floatLogin.asp .floatingContent",function(){})
//把 user/floatLogin.asp中class =” floatingContent” 的容器裡的内容加載到id=” divLoginfloat”的容器裡+
T-SQL 增加字段
ALTER TABLE table_name ADD column_name data_type
alter table 表 add 字段名 類型 限制
http://topic.csdn.net/t/20050511/14/3998169.html
key :增加字段 SQL
T-SQL: Null <> 1 ?
SET @isAdmin = ISNULL(@isAdmin,0)
IF(@isAdmin <> 1) --Null <> 1永遠是ELSE
域名解析
www.mydomain.com
主機名： www
域名：mydomain.com
比較 SELECT INTO 和 INSERT INTO SELECT 兩種表複制語句
http://www.cnblogs.com/freshman0216/archive/2008/08/15/1268316.html
應用：
Code
--1 正确的方法
SELECT * INTO #LW FROM tbl_company_LW WHERE 1=0
IF @isAdmin <> 1
INSERT INTO #LW SELECT * FROM tbl_company_LW WHERE companyID = @companyid AND adminStatus = 0
ELSE
INSERT INTO #LW SELECT * FROM tbl_company_LW WHERE companyID = @companyid
--2 錯誤的提示#LW已存在
IF @isAdmin <> 1
SELECT * INTO #LW FROM tbl_company_LW WHERE companyID = @companyid AND adminStatus = 0
ELSE
SELECT * INTO #LW FROM tbl_company_LW WHERE companyID = @companyid
僅複制表結構
select * into B
from A
truncate table B
這樣就将整個表A的結構複制給了表B ,但不包含表A的類容
應用：
SELECT userid,webName,isNew INTO #LW FROM tbl_company_LW TRUNCATE TABLE #LW
http://topic.csdn.net/t/20061014/14/5082022.html
字元串轉JSON
http://www.cnitblog.com/yemoo/archive/2007/10/08/34526.html
KEY: 字元串 json
SQL的datetime類型資料轉換為字元串格式大全
http://www.cnblogs.com/ajunsoft/archive/2009/05/05/1449693.html
Code
SELECT CONVERT(varchar,getdate())
,CONVERT(varchar,getdate(),0) as '0'
,CONVERT(varchar,getdate(),1) as '1'
,CONVERT(varchar,getdate(),2) as '2'
,CONVERT(varchar,getdate(),3) as '3'
,CONVERT(varchar,getdate(),4) as '4'
,CONVERT(varchar,getdate(),5) as '5'
,CONVERT(varchar,getdate(),6) as '6'
,CONVERT(varchar,getdate(),7) as '7'
,CONVERT(varchar,getdate(),8) as '8'
,CONVERT(varchar,getdate(),9) as '9'
,CONVERT(varchar,getdate(),10) as '10'
,CONVERT(varchar,getdate(),11) as '11'
,CONVERT(varchar,getdate(),12) as '12'
,CONVERT(varchar,getdate(),13) as '13'
,CONVERT(varchar,getdate(),14) as '14'
,CONVERT(varchar,getdate(),100) as '100'
,CONVERT(varchar,getdate(),101) as '101'
,CONVERT(varchar,getdate(),102) as '102'
,CONVERT(varchar,getdate(),103) as '103'
,CONVERT(varchar,getdate(),104) as '104'
,CONVERT(varchar,getdate(),105) as '105'
,CONVERT(varchar,getdate(),106) as '106'
,CONVERT(varchar,getdate(),107) as '107'
,CONVERT(varchar,getdate(),108) as '108'
,CONVERT(varchar,getdate(),109) as '109'
,CONVERT(varchar,getdate(),110) as '110'
,CONVERT(varchar,getdate(),111) as '111'
,CONVERT(varchar,getdate(),112) as '112'
,CONVERT(varchar,getdate(),113) as '113'
,CONVERT(varchar,getdate(),114) as '114'
CASE (Transact-SQL)
http://msdn.microsoft.com/zh-cn/library/ms181765.aspx
Simple CASE expression:
CASE input_expression
WHEN when_expression THEN result_expression [ ...n ]
[ ELSE else_result_expression ]
END
Searched CASE expression:
CASE
WHEN Boolean_expression THEN result_expression [ ...n ]
[ ELSE else_result_expression ]
END
應用:
1
SET @strWhere = @strWhere +
CASE
WHEN 'TBL_PRODUCT' THEN ' and (T.loc_name LIKE ''%'+@keyword+'%'' OR T.en_name LIKE ''%'+@keyword+'%'' OR T.loc_keyword like ''%'+@keyword+'%'' or T.en_keyword like ''%'+@keyword+'%'') '
WHEN 'TBL_BUYINGOFFER' THEN ' and (T.loc_title LIKE ''%'+@keyword+'%'' OR T.en_title LIKE ''%'+@keyword+'%'' OR T.loc_keyword like ''%'+@keyword+'%'' or T.en_keyword like ''%'+@keyword+'%'') '
WHEN 'TBL_SELLINGOFFER' THEN ' and (T.loc_title LIKE ''%'+@keyword+'%'' OR T.en_title LIKE ''%'+@keyword+'%'' OR T.loc_keyword like ''%'+@keyword+'%'' or T.en_keyword like ''%'+@keyword+'%'') '
WHEN 'TBL_BID' THEN ' AND (T.title LIKE ''%'+@keyword+'%'' OR T.keyword LIKE ''%'+@keyword+'%'') '
ELSE ''
END
2
DECLARE @STR NVARCHAR(100)
DECLARE @INT NVARCHAR(100)
SET @INT = '1'
SET @STR =
CASE
WHEN @INT = '2' OR @INT= '3' THEN 'OK'
WHEN @INT = '1' THEN 'D'
ELSE 'NO'
END
PRINT @STR
SQL: 判斷字段中的中文
http://topic.csdn.net/t/20050722/10/4160858.html