update consulting set answer = replace(answer,’400-678-2298′,’020-34273258′)

charindex 查找是否存在某个字符

SELECT *
FROM visitCustomer
WHERE (Adddate >= ‘2009-8-10 00:00:00’)
AND charindex(‘lvshou99.com‘, href) > 0
order by referrer desc

select id, title from example where updatedate > (select updatedate from example where id =&id) and status = 1 order by updatedate limit 0, 1

1，上一条：日期大于当前&id的，同时可能有很多条，就用 limit, 0 ,1 取出一条。

1,
??
<embed? src=”pic/focus2.swf” wmode=”opaque” flashvars=”pics=pic/1.jpg|pic/B.jpg|pic/D.jpg|pic/t.jpg|pic/E.jpg&amp;links=gsdt_sj01.html|cpzs_sj.html|cpzs_sj2.html|cpzs_sj3.html|cpzs_sj4.html&amp;borderwidth=880&amp;borderheight=260&amp;texts=工厂收购|B款|D款|T款|E款&amp;textheight=50″ menu=”false” bgcolor=”#CCCCCC” quality=”high” allowscriptaccess=”sameDomain” type=”application/x-shockwave-flash” pluginspage=”http://www.macromedia.com/go/getflashplayer” width=”880″ height=”252″></embed>

注：Firefox不支持object classid, 故要用embed，focus2.swf见Gmail

pics :指定显示的图片
links:每张图片对应的连接
texts:在图片下方显示的文字。
&amp;? 就是&
在links中若想url带参，用%26,而不是&,也不是&amp;
?? ?flash中会将“&”符号当分隔符处理，这样URL地址就变得不完整了，解决方法是将URL中的“&”改成“%26”即可。

<object ….. >

? <param …/>

</object>这种，在firefox中显示不出来，

可以用：

<object …..>

? <embed …/>

</object>

因为<embed src=””/>本身就是flash标签，所有想要同时支持ie和firefox,直接用<embed src=””/>

<embed name=”movie” src=”flash?参数” width=”” height=”” bgcolor=”” menu=”false” wmode=”opaque” />

 1，select:

                        ${words.city}        

2, js

1,     
     
   



2,package com.tianren.service;
import java.net.*;

import sun.security.krb5.internal.HostAddress;

public class Test{
 InetAddress myIPaddress = null;
 InetAddress myServer = null;
 String hostAddress = null;
 String hostName = null;
 String Address = null ;
 String Name = null ;
 public static void main(String args[]) {

  Test mytool;
  mytool = new Test();
  mytool.getAllServerIP();
//  System.out.println("Your host IP is: " + mytool.getMyIP());
//  System.out.println("The Server IP is :" + mytool.getServerIP());
  
  
  
 }

 // 取得LOCALHOST的IP地址
 public String getMyIP() {
  try {
   myIPaddress = InetAddress.getLocalHost();
   hostAddress = myIPaddress.getHostAddress();//仅仅获得IP地址
   hostName = myIPaddress.getHostName();//获得本地名称
  } catch (UnknownHostException e) {
  }
  return (hostName);
 }

 // 取得 www.abc.com 的IP地址
 public String getServerIP() {
  try {
   myServer = InetAddress.getByName("www.abc.com");
   Address = myServer.getHostAddress();//获得www.abc.com的ip地址
   Name = myServer.getHostName();//获得域名
  } catch (UnknownHostException e) {
  }
  return (Name);
 }
 //获取此域名下的所有IP
 public void getAllServerIP(){
  String name = "www.microsoft.com";
  try{
   
   InetAddress[] addresses= InetAddress.getAllByName(name);
   for(int i =0;i
								

function chek( chkAll )
??? {
??????? var obj = document.aspnetForm.getElementsByTagName(“input”);
?? ??? ??? ?
?? ??? ??? ?for (var i=0;i<obj.length;i++)
?? ??? ??? ?{
?? ??? ??? ?
?? ??? ??? ??? ?var e = obj[i];
?? ??? ??? ??? ?if (e.id.indexOf(“chkItem”)>=0 && e.type==”checkbox”)
?? ??? ??? ??? ??? ?e.checked = chkAll.checked;
?? ??? ??? ?}
?? ??? ??? ?
??? }

头部：
? <input type=”checkbox” id=”chkAll” onclick=”CheckAll( this );” />

子项：
<asp:CheckBox ID=”chkItem” runat=”server” />

风险投资证券
电视电影杂志

都有一个onclick事件，当结果返回true时才会执行
“>删除

< input type = "submit" ID="Button1" Text="提交" onsubmit ="return confirm('Ok to post?')" />

function PopupCalendar(InstanceName)
{
///Global Tag
this.instanceName=InstanceName;
///Properties
this.separator="-"
this.oBtnTodayTitle="Today"
this.oBtnCancelTitle="Cancel"
this.weekDaySting=new Array("S","M","T","W","T","F","S");
this.monthSting=new Array("January","February","March","April","May","June","July","August","September","October","November","December");
this.Width=200;
this.currDate=new Date();
this.today=new Date();
this.startYear=1970;
this.endYear=2010;
///Css
this.normalfontColor="#666666";
this.selectedfontColor="red";
this.divBorderCss="1px solid #BCD0DE";
this.titleTableBgColor="#98B8CD";
this.tableBorderColor="#CCCCCC"
///Method
this.Init=CalendarInit;
this.Fill=CalendarFill;
this.Refresh=CalendarRefresh;
this.Restore=CalendarRestore;
///HTMLObject
this.oTaget=null;
this.oPreviousCell=null;
this.sDIVID=InstanceName+"_Div";
this.sTABLEID=InstanceName+"_Table";
this.sMONTHID=InstanceName+"_Month";
this.sYEARID=InstanceName+"_Year";
this.sTODAYBTNID=InstanceName+"_TODAYBTN";
}
function CalendarInit() ///Create panel
{
var sMonth,sYear
sMonth=this.currDate.getMonth();
sYear=this.currDate.getYear();
htmlAll="
";
htmlAll+="
";
/// Month
htmloMonth="";
for(i=0;i<12;i++)
{ 
htmloMonth+=""+this.monthSting[i]+"";
}
htmloMonth+="";
/// Year
htmloYear="";
for(i=this.startYear;i<=this.endYear;i++)
{
htmloYear+=""+i+"";
}
htmloYear+="
";
/// Day
htmloDayTable="";
htmloDayTable+="";
for(i=0;i<=6;i++)
{
if(i==0)
htmloDayTable+="";
else
htmloDayTable+="";
for(j=0;j<7;j++)
{


if(i==0)
{
htmloDayTable+=""
}
else
{
htmloDayTable+=""
}
}
htmloDayTable+=""; 
}
htmloDayTable+="
";
htmloDayTable+=this.weekDaySting[j]+"
";
htmloDayTable+=" 
";
/// Today Button
htmloButton="
"
htmloButton+=""+this.oBtnTodayTitle+" "
htmloButton+=""+this.oBtnCancelTitle+" "
htmloButton+="
"
/// All
htmlAll=htmlAll+htmloMonth+htmloYear+htmloDayTable+htmloButton+"
";
document.write(htmlAll);
this.Fill(); 
}
function CalendarFill() ///
{
var sMonth,sYear,sWeekDay,sToday,oTable,currRow,MaxDay,iDaySn,sIndex,rowIndex,cellIndex,oSelectMonth,oSelectYear
sMonth=this.currDate.getMonth();
sYear=this.currDate.getYear();
sWeekDay=(new Date(sYear,sMonth,1)).getDay();
sToday=this.currDate.getDate();
iDaySn=1
oTable=document.all[this.sTABLEID];
currRow=oTable.rows[1];
MaxDay=CalendarGetMaxDay(sYear,sMonth);
oSelectMonth=document.all[this.sMONTHID]
oSelectMonth.selectedIndex=sMonth;
oSelectYear=document.all[this.sYEARID]
for(i=0;iMaxDay)break;
currRow = oTable.rows[rowIndex];
cellIndex = 0;
if(rowIndex==1)cellIndex = sWeekDay;
for(;cellIndex"+iDaySn+"";
this.oPreviousCell=currRow.cells[cellIndex];
}
else
{
currRow.cells[cellIndex].innerHTML=iDaySn; 
currRow.cells[cellIndex].style.color=this.normalfontColor;
}
CalendarCellSetCss(0,currRow.cells[cellIndex]);
iDaySn++;
if(iDaySn>MaxDay)break; 
}
}
}
function CalendarRestore() /// Clear Data
{ 
var i,j,oTable
oTable=document.all[this.sTABLEID]
for(i=1;i11)
{
nextYear=nowYear+1;
nextMonth=0;
}
else 
{
nextYear=nowYear; 
}
currDate=new Date(nowYear,nowMonth,1);
nextDate=new Date(nextYear,nextMonth,1);
theMaxDay=(nextDate-currDate)/(24*60*60*1000);
return theMaxDay;
}
function CalendargetPos(el,ePro) /// Get Absolute Position
{
var ePos=0;
while(el!=null)
{ 
ePos+=el["offset"+ePro];
el=el.offsetParent;
}
return ePos;
}
function CalendarDblNum(num)
{
if(num < 10) 
return "0"+num;
else
return num;
}
function CalendarCancel(oInstance) ///Cancel
{
var CalendarDiv=document.all[oInstance.sDIVID];
CalendarDiv.style.display="none"; 
}

调用方法：

<HTML>
<HEAD>
<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″>
<meta http-equiv=”Content-Language” content=”zh-cn”>
<TITLE></TITLE>
<script language=”javascript” src=”calendar.js” ></script>
</head>
<BODY >
<script >
var oCalendarEn=new PopupCalendar(“oCalendarEn”);??? //初始化控件时,请给出实例名称如:oCalendarEn
oCalendarEn.Init();
?
var oCalendarChs=new PopupCalendar(“oCalendarChs”);??? //初始化控件时,请给出实例名称:oCalendarChs
oCalendarChs.weekDaySting=new Array(“日”,”一”,”二”,”三”,”四”,”五”,”六”);
oCalendarChs.monthSting=new Array(“一月”,”二月”,”三月”,”四月”,”五月”,”六月”,”七月”,”八月”,”九月”,”十月”,”十一月”,”十二月”);
oCalendarChs.oBtnTodayTitle=”今天”;
oCalendarChs.oBtnCancelTitle=”取消”;
oCalendarChs.Init();
</script>
<br><br><br><br>
　　　<input readonly type=”text” name=”dd” id=”aa” onclick=”getDateString(this,oCalendarEn)” value=”English Version”>
<br><br><br><br>
　　　<input readonly type=”text” name=”dd” id=”aa” onclick=”getDateString(this,oCalendarChs)” value=”中文界面版”>??????????????????????????????????
</BODY>
</HTML>