̳ϿһλҪڲѯĺҲŲѯĹܣfoosunʱ˷ӣҲ޸Ĺʾַhttp://www.qcy.cn/fs/Html/home/caiyuan/2006-7/8/122716.htmlΪfoosunϵʾ

ղ޸£ڿkesionа汾ʹˣŶ



Search.asp,Լ118С196С275С354оһ

 Case 5
     SqlStr=SqlStr & " And KeyWords Like '%" & KeyWord & "%'"
    Case else
     SqlStr=SqlStr & " And (Title Like '%" & KeyWord & "%' Or  Author Like '%" & KeyWord & "%')"
 

Ƕеĺɫ޸Ϊ

 Case 5
     SqlStr=SqlStr & " And KeyWords Like '%" & KeyWord & "%'"
    Case else
     SqlStr=SqlStr & " And (Title Like '%" & KeyWord & "%' Or  Author Like '%" & KeyWord & "%' Or  AddDate Like '%" & KeyWord & "%')"
 

118С196С275С354Уȫ޸Ҳֻ޸Ĳ֣Ҫ˵һ£118޸ĺΪڲѯܣ196ΪͼƬ275Ϊ354ΪflashѰ汾flashû飬ûԲ

423

Dim ArticleSqlStr:ArticleSqlStr="Select C.ChannelID,A.ID,A.Tid,A.Title,A.AddDate,A.Author,A.ArticleContent,A.Fname,A.InfoPurview,A.ReadPoint From KS_Article A,KS_Class C Where A.Tid=C.ID and A.Verific=1  And A.DelTF=0  And (A.Title Like '%" & KeyWord & "%' Or A.SubTitle Like '%" & KeyWord & "%' or A.Author Like '%" & KeyWord & "%')"
   Dim PhotoSqlStr:PhotoSqlStr="Select C.ChannelID,A.ID,A.Tid,A.Title,A.AddDate,A.Author,A.PictureContent,A.Fname,A.InfoPurview,A.ReadPoint From KS_Photo A, KS_Class C Where A.Tid=C.ID and A.Verific=1  And A.DelTF=0  And (A.Title Like '%" & KeyWord & "%' Or A.Author Like '%" & KeyWord & "%')"
   Dim DownSqlStr:DownSqlStr="Select C.ChannelID,A.ID,A.Tid,A.Title,A.AddDate,A.Author,A.DownContent,A.Fname,A.InfoPurview,A.ReadPoint From KS_DownLoad A,KS_Class C Where A.Tid=C.ID and A.Verific=1  And A.DelTF=0  And (A.Title Like '%" & KeyWord & "%' Or A.Author Like '%" & KeyWord & "%')"
   Dim FlashSqlStr:FlashSqlStr="Select C.ChannelID,A.ID,A.Tid,A.Title,A.AddDate,A.Author,A.FlashContent,A.Fname,A.InfoPurview,A.ReadPoint From KS_Flash A,KS_Class C Where A.Tid=C.ID and A.Verific=1  And A.DelTF=0  And (A.Title Like '%" & KeyWord & "%' Or A.Author Like '%" & KeyWord & "%')"

Ӻɫ֣

Dim ArticleSqlStr:ArticleSqlStr="Select C.ChannelID,A.ID,A.Tid,A.Title,A.AddDate,A.Author,A.ArticleContent,A.Fname,A.InfoPurview,A.ReadPoint From KS_Article A,KS_Class C Where A.Tid=C.ID and A.Verific=1  And A.DelTF=0  And (A.Title Like '%" & KeyWord & "%' Or A.SubTitle Like '%" & KeyWord & "%' or A.Author Like '%" & KeyWord & "%' or A.AddDate Like '%" & KeyWord & "%')"
   Dim PhotoSqlStr:PhotoSqlStr="Select C.ChannelID,A.ID,A.Tid,A.Title,A.AddDate,A.Author,A.PictureContent,A.Fname,A.InfoPurview,A.ReadPoint From KS_Photo A, KS_Class C Where A.Tid=C.ID and A.Verific=1  And A.DelTF=0  And (A.Title Like '%" & KeyWord & "%' Or A.Author Like '%" & KeyWord & "%' or A.AddDate Like '%" & KeyWord & "%')"
   Dim DownSqlStr:DownSqlStr="Select C.ChannelID,A.ID,A.Tid,A.Title,A.AddDate,A.Author,A.DownContent,A.Fname,A.InfoPurview,A.ReadPoint From KS_DownLoad A,KS_Class C Where A.Tid=C.ID and A.Verific=1  And A.DelTF=0  And (A.Title Like '%" & KeyWord & "%' Or A.Author Like '%" & KeyWord & "%' or A.AddDate Like '%" & KeyWord & "%')"
   Dim FlashSqlStr:FlashSqlStr="Select C.ChannelID,A.ID,A.Tid,A.Title,A.AddDate,A.Author,A.FlashContent,A.Fname,A.InfoPurview,A.ReadPoint From KS_Flash A,KS_Class C Where A.Tid=C.ID and A.Verific=1  And A.DelTF=0  And (A.Title Like '%" & KeyWord & "%' Or A.Author Like '%" & KeyWord & "%' or A.AddDate Like '%" & KeyWord & "%')"

ҪṩPowered by ,QQ:841951һˣѹcalĿ¼棻һ΢޸ڿ֧kesionˣcalĿ¼һiflateng.htmļҵõʱ͵ļͿˡҪעʹվҲȫô㲻޸ģֻͨѯšͼƬšءȵƵʱôͱע⣺

231Уɫ

html+="<td "+(c?" bgcolor='"+c+"' ":"")+"><div class='CalCell' "+sDIV+giCellHeight+"px;width:"+giCellWidth+"px;"+("background:"+(c1?c1:"")+(cbg?" url("+cbg+")":""))+"' title=\""+ti+"\" onmouseover='fMouseOver(this);return true;' onmouseout='fMouseOut(this)' onclick='fSetDate("+cd[0]+","+cd[1]+","+dayNo+",true)'><A href='../search.Asp?ChannelID=0&KeyWord="+cd[0]+"-"+cd[1]+"-"+dayNo+"'"+"class='CellAnchor'  target='_blank'  style='color:"+dc+(bo?";font-weight:bold":"")+td+"' onfocus='if(this.blur)this.blur();'>"+eval(gsDays)+"</A>"+htm+"</div></td>";

  ChannelID=0   ʾѯʱʹȫ

         ChannelID=1   ʾʹ

         ChannelID=2   ʾʹͼƬ

         ChannelID=3     ʾʹ

         ChannelID=4      ʾʹflash

дѾ޸ĺõSearch.aspļרΪṩǺǣ



                                                                             monfs
                                                                         1:08 2006-7-20
