alexhttp://sdt.sumida.com.cn:8080/cs/blogs/alex/atom.aspxCommunity Server2006-03-07T17:44:00ZLinux下用IMP导入Oracle 数据(脚本示例）http://sdt.sumida.com.cn:8080/cs/blogs/alex/archive/2007/10/10/linux-imp-oracle.aspx2007-10-10T02:20:00Z2007-10-10T02:20:00Z<p>具体脚本如下,"#"后面的为注释：</p>
<p>export ORACLE_SID=tporacle #Oracle SID<br />export ORACLE_HOME=/oracle/ora10g #Oracle 主目录<br /> <br />BASE=/sdt/dump/qms #基本目录<br />msgfile=$BASE/impsch_qms.msg #信息文件<br />implog=$BASE/impsch_qms.log #导入过程中日志<br />datfile=\($BASE/qms20070923_1.dmp,$BASE/qms20070923_2.dmp,$BASE/qms20070923_3.dmp\) #要导入数据文件,如果有分卷的文件，用逗号隔开<br /> <br />echo "\nSchema import started at `date '+%Y/%b/%d %H:%M:%S'`" > $msgfile<br /> <br />$ORACLE_HOME/bin/imp "系统用户名/密码" file=$datfile fromuser=\(源用户，如果有多个用逗隔开\) touser=\(目标用户，如果有多个用逗隔开\) <br />log=$implog rows=y indexes=y ignore=y constraints=y commit=y<br /> <br />echo "\nSchema import completed at `date '+%Y/%b/%d %H:%M:%S'`" >> $msgfile<br />exit</p>
<p> </p><img src="http://sdt.sumida.com.cn:8080/cs/aggbug.aspx?PostID=6125" width="1" height="1">alexhttp://sdt.sumida.com.cn:8080/cs/members/alex.aspx简/繁/UTF码转换资源文件编辑工具http://sdt.sumida.com.cn:8080/cs/blogs/alex/archive/2007/05/11/utf.aspx2007-05-11T04:52:00Z2007-05-11T04:52:00Z<p><img src="http://10.107.0.10:8080/cs/emoticons/emotion-11.gif" alt="Cool" />未完成功能：对于2005 Winform的resx文件，似乎写入后无法从程序中调用新增的项<br></p><img src="http://sdt.sumida.com.cn:8080/cs/aggbug.aspx?PostID=3702" width="1" height="1">alexhttp://sdt.sumida.com.cn:8080/cs/members/alex.aspxtnsnames.ora 解析类(C#)http://sdt.sumida.com.cn:8080/cs/blogs/alex/archive/2007/05/10/tnsnames-ora-c.aspx2007-05-10T09:13:00Z2007-05-10T09:13:00Z<P>用法： TnsParser parser = new TnsParser();<BR> parser.Parse();<BR> TnsEntryCollectionType entries = parser.TnsFileEntries;<BR> for (int i = 0; i < entries.Count; i++)<BR> {<BR> MessageBox.Show(entries[ i ].Server);<BR> MessageBox.Show(entries[ i ].ServiceName);<BR> MessageBox.Show(entries[ i ].HostName);<BR> MessageBox.Show(entries[ i ].PortNumber);<BR> }</P><img src="http://sdt.sumida.com.cn:8080/cs/aggbug.aspx?PostID=3687" width="1" height="1">alexhttp://sdt.sumida.com.cn:8080/cs/members/alex.aspxORACLE 中的比率计算函数http://sdt.sumida.com.cn:8080/cs/blogs/alex/archive/2007/02/14/oracle.aspx2007-02-14T10:14:00Z2007-02-14T10:14:00Z<p>RATIO_TO_REPORT是一个分析函数. 用来计算一个值在一系列值之间所占的比重.</p><p>语法：RATIO_TO_REPORT(列名或表达式) OVER()</p><p>下面的例子计算每一个采购员的工资在所有采购员中占的比率:<br><br>SELECT last_name, salary, RATIO_TO_REPORT(salary) OVER () AS rr<br> FROM employees<br> WHERE job_id = '采购员';<br> <br>结果:<br>LAST_NAME SALARY RR<br>------------------------- ---------- ----------<br>Khoo 3100 .223021583<br>Baida 2900 .208633094<br>Tobias 2800 .201438849<br>Himuro 2600 .18705036<br>Colmenares 2500 .179856115</p><img src="http://sdt.sumida.com.cn:8080/cs/aggbug.aspx?PostID=2317" width="1" height="1">alexhttp://sdt.sumida.com.cn:8080/cs/members/alex.aspxResend Email For Account Request In ITMChttp://sdt.sumida.com.cn:8080/cs/blogs/alex/archive/2007/02/09/resend-email-for-account-request-in-itmc.aspx2007-02-09T10:18:00Z2007-02-09T10:18:00Z<p>1.Create a Standard Personal View that include "Account Key" in Account Request </p><p>2. Use the following URL to resend Email with an account key: http://10.107.0.10/userservices/itmc_service.aspx?Cmd=AFTERNEW&List=ACCREQ&ak=<i><b>type the account key here</b></i></p><img src="http://sdt.sumida.com.cn:8080/cs/aggbug.aspx?PostID=2240" width="1" height="1">alexhttp://sdt.sumida.com.cn:8080/cs/members/alex.aspxSimpleDatabase 用Oracle 游标返回数据的问题http://sdt.sumida.com.cn:8080/cs/blogs/alex/archive/2006/10/21/441.aspx2006-10-21T10:42:00Z2006-10-21T10:42:00Z<P>今日在用SimpleDatabase访问Oracle游标返回数据时，总是提示"不正确的参数类型或数量",访问没有游标返回的Procedure就一切正常，上网查了一下，发现如下资料：</P>
<P>realized all that needed to be done was to add an output parameter of type OracleType.Cursor. But since the IDataParamater.DbType didn't have that type, and I didn't want to change much code, I changed the code in the 'else parameter.Type is null' portion of Wilson.ORMapper.Internals.Connection.GetParameter(...) to this:</P><B><FONT color=#008000 size=2></FONT></B>
<P><B><FONT color=#008000 size=2>if</FONT></B><FONT size=2> (</FONT><FONT color=#000080 size=2>dbParameter</FONT><FONT size=2> </FONT><B><FONT color=#008000 size=2>is</FONT></B><FONT size=2> </FONT><FONT color=#000080 size=2>System</FONT><FONT color=#808000 size=2>.</FONT><FONT color=#000080 size=2>Data</FONT><FONT color=#808000 size=2>.</FONT><FONT color=#000080 size=2>OracleClient</FONT><FONT color=#808000 size=2>.</FONT><FONT color=#000080 size=2>OracleParameter</FONT><FONT size=2> </FONT><FONT color=#808000 size=2>&&</FONT><FONT size=2> </FONT><FONT color=#000080 size=2>dbParameter</FONT><FONT color=#808000 size=2>.</FONT><FONT color=#000080 size=2>Direction</FONT><FONT size=2> </FONT><FONT color=#808000 size=2>==</FONT><FONT size=2> </FONT><FONT color=#000080 size=2>ParameterDirection</FONT><FONT color=#808000 size=2>.</FONT><FONT color=#000080 size=2>Output</FONT><FONT size=2>)<BR>{<BR> ((</FONT><FONT color=#000080 size=2>System</FONT><FONT color=#808000 size=2>.</FONT><FONT color=#000080 size=2>Data</FONT><FONT color=#808000 size=2>.</FONT><FONT color=#000080 size=2>OracleClient</FONT><FONT color=#808000 size=2>.</FONT><FONT color=#000080 size=2>OracleParameter</FONT><FONT size=2>)</FONT><FONT color=#000080 size=2>dbParameter</FONT><FONT size=2>)</FONT><FONT color=#808000 size=2>.</FONT><FONT color=#000080 size=2>OracleType</FONT><FONT size=2> </FONT><FONT color=#808000 size=2>=</FONT><FONT size=2> </FONT><FONT color=#000080 size=2>System</FONT><FONT color=#808000 size=2>.</FONT><FONT color=#000080 size=2>Data</FONT><FONT color=#808000 size=2>.</FONT><FONT color=#000080 size=2>OracleClient</FONT><FONT color=#808000 size=2>.</FONT><FONT color=#000080 size=2>OracleType</FONT><FONT color=#808000 size=2>.</FONT><FONT color=#000080 size=2>Cursor</FONT><FONT size=2>;<BR>}<BR></FONT><B><FONT color=#008000 size=2>else<BR></FONT></B><FONT size=2>{<BR></FONT><FONT color=#000080 size=2> dbParameter</FONT><FONT color=#808000 size=2>.</FONT><FONT color=#000080 size=2>DbType</FONT><FONT size=2> </FONT><FONT color=#808000 size=2>=</FONT><FONT size=2> </FONT><FONT color=#000080 size=2>DbType</FONT><FONT color=#808000 size=2>.</FONT><FONT color=#000080 size=2>String</FONT><FONT size=2>;<BR>}</FONT></P>
<P><FONT size=2>用上述的代码测试后，结果正常，但如果真的有output非游标参数，上述的代码就会有问题了。</FONT></P>
<P><FONT size=2>不知道是不是SimpleDatabase的问题，欢迎大侠们提下意见。</FONT></P><img src="http://sdt.sumida.com.cn:8080/cs/aggbug.aspx?PostID=441" width="1" height="1">alexhttp://sdt.sumida.com.cn:8080/cs/members/alex.aspx[转贴]LINQ 初探 http://sdt.sumida.com.cn:8080/cs/blogs/alex/archive/2006/08/01/355.aspx2006-08-01T04:41:00Z2006-08-01T04:41:00Z<H2><A id=viewpost1_TitleUrl href="http://www.cnblogs.com/Ring1981/archive/2006/06/09/421795.html">LINQ 初探</A> </H2>
<DIV class=postbody>
<P>LINQ是什么？<BR>它是Language Integrated Query。<BR>当我们要对数据库表进行查询的时候，我们一定会编写"select * from sometable where ID = .."的语句。好，那我们现在根据LINQ的语法，完全可以将我们熟悉的SQL中像"select","from","where"等语句在.NET Framework环境中顺利使用并且大大提高开发的效率。</P>
<P>下面我就牛刀小试，做个demo看看。</P>
<P>1. 先下载LinQ框架 <BR> 现在最新版本是2006年5月发布"Orcas CTP", 下载地址(<A title=" 这里 " href="http://www.microsoft.com/downloads/details.aspx?familyid=1e902c21-340c-4d13-9f04-70eb5e3dceea&displaylang=en">这里 </A>)</P>
<P>2. 下载安装待完毕。</P>
<P>3. 新建一个"LINQ Console Application"项目。</P>
<P>4. 输入代码如下： </P>
<DIV><SPAN> 1</SPAN><IMG src="http://ring1981.cnblogs.com/Images/OutliningIndicators/None.gif" align=top><SPAN><BR></SPAN><SPAN> 2</SPAN><SPAN><IMG src="http://ring1981.cnblogs.com/Images/OutliningIndicators/None.gif" align=top></SPAN><SPAN>using</SPAN><SPAN> System;<BR></SPAN><SPAN> 3</SPAN><SPAN><IMG src="http://ring1981.cnblogs.com/Images/OutliningIndicators/None.gif" align=top></SPAN><SPAN>using</SPAN><SPAN> System.Collections.Generic;<BR></SPAN><SPAN> 4</SPAN><SPAN><IMG src="http://ring1981.cnblogs.com/Images/OutliningIndicators/None.gif" align=top></SPAN><SPAN>using</SPAN><SPAN> System.Text;<BR></SPAN><SPAN> 5</SPAN><SPAN><IMG src="http://ring1981.cnblogs.com/Images/OutliningIndicators/None.gif" align=top></SPAN><SPAN>using</SPAN><SPAN> System.Query;<BR></SPAN><SPAN> 6</SPAN><SPAN><IMG src="http://ring1981.cnblogs.com/Images/OutliningIndicators/None.gif" align=top></SPAN><SPAN>using</SPAN><SPAN> System.Xml.XLinq;<BR></SPAN><SPAN> 7</SPAN><SPAN><IMG src="http://ring1981.cnblogs.com/Images/OutliningIndicators/None.gif" align=top></SPAN><SPAN>using</SPAN><SPAN> System.Data.DLinq;<BR></SPAN><SPAN> 8</SPAN><SPAN><IMG src="http://ring1981.cnblogs.com/Images/OutliningIndicators/None.gif" align=top><BR></SPAN><SPAN> 9</SPAN><SPAN><IMG src="http://ring1981.cnblogs.com/Images/OutliningIndicators/None.gif" align=top></SPAN><SPAN>namespace</SPAN><SPAN> LINQConsoleApplication1<BR></SPAN><SPAN>10</SPAN><SPAN></SPAN><SPAN id=Codehighlighter1_172_671_Closed_Text></SPAN><SPAN id=Codehighlighter1_172_671_Open_Text><SPAN>{<BR></SPAN><SPAN>11</SPAN><SPAN> </SPAN><SPAN>class</SPAN><SPAN> Program<BR></SPAN><SPAN>12</SPAN><SPAN> </SPAN><SPAN id=Codehighlighter1_196_669_Closed_Text></SPAN><SPAN id=Codehighlighter1_196_669_Open_Text><SPAN>{<BR></SPAN><SPAN>13</SPAN><SPAN> </SPAN><SPAN>static</SPAN><SPAN> </SPAN><SPAN>void</SPAN><SPAN> Main(</SPAN><SPAN>string</SPAN><SPAN>[] args)<BR></SPAN><SPAN>14</SPAN><SPAN> </SPAN><SPAN id=Codehighlighter1_246_663_Closed_Text></SPAN><SPAN id=Codehighlighter1_246_663_Open_Text><SPAN>{<BR></SPAN><SPAN>15</SPAN><SPAN> </SPAN><SPAN>string</SPAN><SPAN>[] aBunchOfWords </SPAN><SPAN>=</SPAN><SPAN> </SPAN><SPAN id=Codehighlighter1_285_333_Closed_Text></SPAN><SPAN id=Codehighlighter1_285_333_Open_Text><SPAN>{</SPAN><SPAN>"</SPAN><SPAN>One</SPAN><SPAN>"</SPAN><SPAN>,</SPAN><SPAN>"</SPAN><SPAN>Two</SPAN><SPAN>"</SPAN><SPAN>, </SPAN><SPAN>"</SPAN><SPAN>Hello</SPAN><SPAN>"</SPAN><SPAN>, </SPAN><SPAN>"</SPAN><SPAN>World</SPAN><SPAN>"</SPAN><SPAN>, <BR></SPAN><SPAN>16</SPAN><SPAN><BR></SPAN><SPAN>17</SPAN><SPAN></SPAN><SPAN>"</SPAN><SPAN>Four</SPAN><SPAN>"</SPAN><SPAN>, </SPAN><SPAN>"</SPAN><SPAN>Five</SPAN><SPAN>"</SPAN><SPAN>}</SPAN></SPAN><SPAN>;<BR></SPAN><SPAN>18</SPAN><SPAN> var result </SPAN><SPAN>=</SPAN><SPAN> <BR></SPAN><SPAN>19</SPAN><SPAN> from s </SPAN><SPAN>in</SPAN><SPAN> aBunchOfWords </SPAN><SPAN>//</SPAN><SPAN> query the string array </SPAN><SPAN><BR></SPAN><SPAN>20</SPAN><SPAN></SPAN><SPAN> where s.Length </SPAN><SPAN>==</SPAN><SPAN> </SPAN><SPAN>5</SPAN><SPAN> </SPAN><SPAN>//</SPAN><SPAN> for all words with length = 5</SPAN><SPAN><BR></SPAN><SPAN>21</SPAN><SPAN></SPAN><SPAN> select s; </SPAN><SPAN>//</SPAN><SPAN> and return the string</SPAN><SPAN><BR></SPAN><SPAN>22</SPAN><SPAN></SPAN><SPAN> </SPAN><SPAN>foreach</SPAN><SPAN> (var s </SPAN><SPAN>in</SPAN><SPAN> result) </SPAN><SPAN id=Codehighlighter1_593_653_Closed_Text></SPAN><SPAN id=Codehighlighter1_593_653_Open_Text><SPAN>{<BR></SPAN><SPAN>23</SPAN><SPAN> Console.WriteLine(s); </SPAN><SPAN>//</SPAN><SPAN>print</SPAN><SPAN><BR></SPAN><SPAN>24</SPAN><SPAN></SPAN><SPAN> }</SPAN></SPAN><SPAN><BR></SPAN><SPAN>25</SPAN><SPAN> }</SPAN></SPAN><SPAN><BR></SPAN><SPAN>26</SPAN><SPAN> }</SPAN></SPAN><SPAN><BR></SPAN><SPAN>27</SPAN><SPAN>}</SPAN></SPAN><SPAN><BR></SPAN><SPAN>28</SPAN><SPAN><IMG src="http://ring1981.cnblogs.com/Images/OutliningIndicators/None.gif" align=top><BR></SPAN><SPAN>29</SPAN><SPAN><IMG src="http://ring1981.cnblogs.com/Images/OutliningIndicators/None.gif" align=top></SPAN></DIV>
<P><BR>运行结果如下：<BR>Hello<BR>World<BR>print any key to continue ...</P>
<P>这是我学习LINQ的第一个小程序，深感LINQ对编程语言带来的改变。将此例子给大家共同学习！</P></DIV><img src="http://sdt.sumida.com.cn:8080/cs/aggbug.aspx?PostID=355" width="1" height="1">alexhttp://sdt.sumida.com.cn:8080/cs/members/alex.aspx文件的contenttype类型http://sdt.sumida.com.cn:8080/cs/blogs/alex/archive/2006/05/17/225.aspx2006-05-16T16:48:00Z2006-05-16T16:48:00Z<P>文件的contenttype类型 <BR> .* = application/octet-stream<BR> .001 = application/x-001<BR> .301 = application/x-301<BR> .323 = text/h323<BR> .906 = application/x-906<BR> .907 = drawing/907<BR> .a11 = application/x-a11<BR> .acp = audio/x-mei-aac<BR> .ai = application/postscript<BR> .aif = audio/aiff<BR> .aifc = audio/aiff<BR> .aiff = audio/aiff<BR> .anv = application/x-anv<BR> .asa = text/asa<BR> .asf = video/x-ms-asf<BR> .asp = text/asp<BR> .asx = video/x-ms-asf<BR> .au = audio/basic<BR> .avi = video/avi<BR> .awf = application/vnd.adobe.workflow<BR> .biz = text/xml<BR> .bmp = application/x-bmp<BR> .bot = application/x-bot<BR> .c4t = application/x-c4t<BR> .c90 = application/x-c90<BR> .cal = application/x-cals<BR> .cat = application/vnd.ms-pki.seccat<BR> .cdf = application/x-netcdf<BR> .cdr = application/x-cdr<BR> .cel = application/x-cel<BR> .cer = application/x-x509-ca-cert<BR> .cg4 = application/x-g4<BR> .cgm = application/x-cgm<BR> .cit = application/x-cit<BR> .class = java/*<BR> .cml = text/xml<BR> .cmp = application/x-cmp<BR> .cmx = application/x-cmx<BR> .cot = application/x-cot<BR> .crl = application/pkix-crl<BR> .crt = application/x-x509-ca-cert<BR> .csi = application/x-csi<BR> .css = text/css<BR> .cut = application/x-cut<BR> .dbf = application/x-dbf<BR> .dbm = application/x-dbm<BR> .dbx = application/x-dbx<BR> .dcd = text/xml<BR> .dcx = application/x-dcx<BR> .der = application/x-x509-ca-cert<BR> .dgn = application/x-dgn<BR> .dib = application/x-dib<BR> .dll = application/x-msdownload<BR> .doc = application/msword<BR> .dot = application/msword<BR> .drw = application/x-drw<BR> .dtd = text/xml<BR> .dwf = Model/vnd.dwf<BR> .dwf = application/x-dwf<BR> .dwg = application/x-dwg<BR> .dxb = application/x-dxb<BR> .dxf = application/x-dxf<BR> .edn = application/vnd.adobe.edn<BR> .emf = application/x-emf<BR> .eml = message/rfc822<BR> .ent = text/xml<BR> .epi = application/x-epi<BR> .eps = application/x-ps<BR> .eps = application/postscript<BR> .etd = application/x-ebx<BR> .exe = application/x-msdownload<BR> .fax = image/fax<BR> .fdf = application/vnd.fdf<BR> .fif = application/fractals<BR> .fo = text/xml<BR> .frm = application/x-frm<BR> .g4 = application/x-g4<BR> .gbr = application/x-gbr<BR> .gcd = application/x-gcd<BR> .gif = image/gif<BR> .gl2 = application/x-gl2<BR> .gp4 = application/x-gp4<BR> .hgl = application/x-hgl<BR> .hmr = application/x-hmr<BR> .hpg = application/x-hpgl<BR> .hpl = application/x-hpl<BR> .hqx = application/mac-binhex40<BR> .hrf = application/x-hrf<BR> .hta = application/hta<BR> .htc = text/x-component<BR> .htm = text/html<BR> .html = text/html<BR> .htt = text/webviewhtml<BR> .htx = text/html<BR> .icb = application/x-icb<BR> .ico = image/x-icon<BR> .ico = application/x-ico<BR> .iff = application/x-iff<BR> .ig4 = application/x-g4<BR> .igs = application/x-igs<BR> .iii = application/x-iphone<BR> .img = application/x-img<BR> .ins = application/x-internet-signup<BR> .isp = application/x-internet-signup<BR> .IVF = video/x-ivf<BR> .java = java/*<BR> .jfif = image/jpeg<BR> .jpe = image/jpeg<BR> .jpe = application/x-jpe<BR> .jpeg = image/jpeg<BR> .jpg = image/jpeg<BR> .jpg = application/x-jpg<BR> .js = application/x-javascript<BR> .jsp = text/html<BR> .la1 = audio/x-liquid-file<BR> .lar = application/x-laplayer-reg<BR> .latex = application/x-latex<BR> .lavs = audio/x-liquid-secure<BR> .lbm = application/x-lbm<BR> .lmsff = audio/x-la-lms<BR> .ls = application/x-javascript<BR> .ltr = application/x-ltr<BR> .m1v = video/x-mpeg<BR> .m2v = video/x-mpeg<BR> .m3u = audio/mpegurl<BR> .m4e = video/mpeg4<BR> .mac = application/x-mac<BR> .man = application/x-troff-man<BR> .math = text/xml<BR> .mdb = application/msaccess<BR> .mdb = application/x-mdb<BR> .mfp = application/x-shockwave-flash<BR> .mht = message/rfc822<BR> .mhtml = message/rfc822<BR> .mi = application/x-mi<BR> .mid = audio/mid<BR> .midi = audio/mid<BR> .mil = application/x-mil<BR> .mml = text/xml<BR> .mnd = audio/x-musicnet-download<BR> .mns = audio/x-musicnet-stream<BR> .mocha = application/x-javascript<BR> .movie = video/x-sgi-movie<BR> .mp1 = audio/mp1<BR> .mp2 = audio/mp2<BR> .mp2v = video/mpeg<BR> .mp3 = audio/mp3<BR> .mp4 = video/mpeg4<BR> .mpa = video/x-mpg<BR> .mpd = application/vnd.ms-project<BR> .mpe = video/x-mpeg<BR> .mpeg = video/mpg<BR> .mpg = video/mpg<BR> .mpga = audio/rn-mpeg<BR> .mpp = application/vnd.ms-project<BR> .mps = video/x-mpeg<BR> .mpt = application/vnd.ms-project<BR> .mpv = video/mpg<BR> .mpv2 = video/mpeg<BR> .mpw = application/vnd.ms-project<BR> .mpx = application/vnd.ms-project<BR> .mtx = text/xml<BR> .mxp = application/x-mmxp<BR> .net = image/pnetvue<BR> .nrf = application/x-nrf<BR> .nws = message/rfc822<BR> .odc = text/x-ms-odc<BR> .out = application/x-out<BR> .p10 = application/pkcs10<BR> .p12 = application/x-pkcs12<BR> .p7b = application/x-pkcs7-certificates<BR> .p7c = application/pkcs7-mime<BR> .p7m = application/pkcs7-mime<BR> .p7r = application/x-pkcs7-certreqresp<BR> .p7s = application/pkcs7-signature<BR> .pc5 = application/x-pc5<BR> .pci = application/x-pci<BR> .pcl = application/x-pcl<BR> .pcx = application/x-pcx<BR> .pdf = application/pdf<BR> .pdf = application/pdf<BR> .pdx = application/vnd.adobe.pdx<BR> .pfx = application/x-pkcs12<BR> .pgl = application/x-pgl<BR> .pic = application/x-pic<BR> .pko = application/vnd.ms-pki.pko<BR> .pl = application/x-perl<BR> .plg = text/html<BR> .pls = audio/scpls<BR> .plt = application/x-plt<BR> .png = image/png<BR> .png = application/x-png<BR> .pot = application/vnd.ms-powerpoint<BR> .ppa = application/vnd.ms-powerpoint<BR> .ppm = application/x-ppm<BR> .pps = application/vnd.ms-powerpoint<BR> .ppt = application/vnd.ms-powerpoint<BR> .ppt = application/x-ppt<BR> .pr = application/x-pr<BR> .prf = application/pics-rules<BR> .prn = application/x-prn<BR> .prt = application/x-prt<BR> .ps = application/x-ps<BR> .ps = application/postscript<BR> .ptn = application/x-ptn<BR> .pwz = application/vnd.ms-powerpoint<BR> .r3t = text/vnd.rn-realtext3d<BR> .ra = audio/vnd.rn-realaudio<BR> .ram = audio/x-pn-realaudio<BR> .ras = application/x-ras<BR> .rat = application/rat-file<BR> .rdf = text/xml<BR> .rec = application/vnd.rn-recording<BR> .red = application/x-red<BR> .rgb = application/x-rgb<BR> .rjs = application/vnd.rn-realsystem-rjs<BR> .rjt = application/vnd.rn-realsystem-rjt<BR> .rlc = application/x-rlc<BR> .rle = application/x-rle<BR> .rm = application/vnd.rn-realmedia<BR> .rmf = application/vnd.adobe.rmf<BR> .rmi = audio/mid<BR> .rmj = application/vnd.rn-realsystem-rmj<BR> .rmm = audio/x-pn-realaudio<BR> .rmp = application/vnd.rn-rn_music_package<BR> .rms = application/vnd.rn-realmedia-secure<BR> .rmvb = application/vnd.rn-realmedia-vbr<BR> .rmx = application/vnd.rn-realsystem-rmx<BR> .rnx = application/vnd.rn-realplayer<BR> .rp = image/vnd.rn-realpix<BR> .rpm = audio/x-pn-realaudio-plugin<BR> .rsml = application/vnd.rn-rsml<BR> .rt = text/vnd.rn-realtext<BR> .rtf = application/msword<BR> .rtf = application/x-rtf<BR> .rv = video/vnd.rn-realvideo<BR> .sam = application/x-sam<BR> .sat = application/x-sat<BR> .sdp = application/sdp<BR> .sdw = application/x-sdw<BR> .sit = application/x-stuffit<BR> .slb = application/x-slb<BR> .sld = application/x-sld<BR> .slk = drawing/x-slk<BR> .smi = application/smil<BR> .smil = application/smil<BR> .smk = application/x-smk<BR> .snd = audio/basic<BR> .sol = text/plain<BR> .sor = text/plain<BR> .spc = application/x-pkcs7-certificates<BR> .spl = application/futuresplash<BR> .spp = text/xml<BR> .ssm = application/streamingmedia<BR> .sst = application/vnd.ms-pki.certstore<BR> .stl = application/vnd.ms-pki.stl<BR> .stm = text/html<BR> .sty = application/x-sty<BR> .svg = text/xml<BR> .swf = application/x-shockwave-flash<BR> .tdf = application/x-tdf<BR> .tg4 = application/x-tg4<BR> .tga = application/x-tga<BR> .tif = image/tiff<BR> .tif = application/x-tif<BR> .tiff = image/tiff<BR> .tld = text/xml<BR> .top = drawing/x-top<BR> .torrent = application/x-bittorrent<BR> .tsd = text/xml<BR> .txt = text/plain<BR> .uin = application/x-icq<BR> .uls = text/iuls<BR> .vcf = text/x-vcard<BR> .vda = application/x-vda<BR> .vdx = application/vnd.visio<BR> .vml = text/xml<BR> .vpg = application/x-vpeg005<BR> .vsd = application/vnd.visio<BR> .vsd = application/x-vsd<BR> .vss = application/vnd.visio<BR> .vst = application/vnd.visio<BR> .vst = application/x-vst<BR> .vsw = application/vnd.visio<BR> .vsx = application/vnd.visio<BR> .vtx = application/vnd.visio<BR> .vxml = text/xml<BR> .wav = audio/wav<BR> .wax = audio/x-ms-wax<BR> .wb1 = application/x-wb1<BR> .wb2 = application/x-wb2<BR> .wb3 = application/x-wb3<BR> .wbmp = image/vnd.wap.wbmp<BR> .wiz = application/msword<BR> .wk3 = application/x-wk3<BR> .wk4 = application/x-wk4<BR> .wkq = application/x-wkq<BR> .wks = application/x-wks<BR> .wm = video/x-ms-wm<BR> .wma = audio/x-ms-wma<BR> .wmd = application/x-ms-wmd<BR> .wmf = application/x-wmf<BR> .wml = text/vnd.wap.wml<BR> .wmv = video/x-ms-wmv<BR> .wmx = video/x-ms-wmx<BR> .wmz = application/x-ms-wmz<BR> .wp6 = application/x-wp6<BR> .wpd = application/x-wpd<BR> .wpg = application/x-wpg<BR> .wpl = application/vnd.ms-wpl<BR> .wq1 = application/x-wq1<BR> .wr1 = application/x-wr1<BR> .wri = application/x-wri<BR> .wrk = application/x-wrk<BR> .ws = application/x-ws<BR> .ws2 = application/x-ws<BR> .wsc = text/scriptlet<BR> .wsdl = text/xml<BR> .wvx = video/x-ms-wvx<BR> .xdp = application/vnd.adobe.xdp<BR> .xdr = text/xml<BR> .xfd = application/vnd.adobe.xfd<BR> .xfdf = application/vnd.adobe.xfdf<BR> .xhtml = text/html<BR> .xls = application/vnd.ms-excel<BR> .xls = application/x-xls<BR> .xlw = application/x-xlw<BR> .xml = text/xml<BR> .xpl = audio/scpls<BR> .xq = text/xml<BR> .xql = text/xml<BR> .xquery = text/xml<BR> .xsd = text/xml<BR> .xsl = text/xml<BR> .xslt = text/xml<BR> .xwd = application/x-xwd<BR> .x_b = application/x-x_b<BR> .x_t = application/x-x_t </P><img src="http://sdt.sumida.com.cn:8080/cs/aggbug.aspx?PostID=225" width="1" height="1">alexhttp://sdt.sumida.com.cn:8080/cs/members/alex.aspxVisual Studio 2005 Web Deployment Projects http://sdt.sumida.com.cn:8080/cs/blogs/alex/archive/2006/05/10/208.aspx2006-05-10T12:24:00Z2006-05-10T12:24:00Z<A href="http://msdn.microsoft.com/asp.net/reference/infrastructure/wdp/default.aspx">http://msdn.microsoft.com/asp.net/reference/infrastructure/wdp/default.aspx</A><img src="http://sdt.sumida.com.cn:8080/cs/aggbug.aspx?PostID=208" width="1" height="1">alexhttp://sdt.sumida.com.cn:8080/cs/members/alex.aspxSimple Database Samplehttp://sdt.sumida.com.cn:8080/cs/blogs/alex/archive/2006/04/26/172.aspx2006-04-26T08:06:00Z2006-04-26T08:06:00Z<P>演示了用Db和DbTable绑定,添加，更新，删除数据。</P>
<P>演示地址：<A href="http://10.107.1.245/testsimdb/testdb.aspx">http://10.107.1.245/testsimdb/testdb.aspx</A></P>
<P>附件的文件:</P>
<P>--test_simpledatabase</P>
<P>-------website :主要文件,把此文件夹设成一个虚拟目录</P>
<P>-------db.sql :测试所用到的表和数据，在数据库里运行创建</P><img src="http://sdt.sumida.com.cn:8080/cs/aggbug.aspx?PostID=172" width="1" height="1">alexhttp://sdt.sumida.com.cn:8080/cs/members/alex.aspx一个单引号引发的乱码http://sdt.sumida.com.cn:8080/cs/blogs/alex/archive/2006/04/20/116.aspx2006-04-20T02:56:00Z2006-04-20T02:56:00Z最近现场用户反映PI3的一个奇怪问题，在导出EXCEL时，导大量数据会乱码，但只有一条记录时却不会出现。经过反复测试，发现临界点在三条和四条记录之间，多于三条时就会出现乱码。再深入测试后，发现如果把生成的代码"<META HTTP-EQUIV='content-type' CONTENT='text/html; charset=UTF-8'>" 中单引号改为双引号，乱码现象就会消失。因此建议各位在生成EXCE内容时，注意这里sr.WriteLine("<META HTTP-EQUIV='content-type' CONTENT='text/html; charset=UTF-8'>"); 改为sr.WriteLine("<META HTTP-EQUIV=\"content-type\" CONTENT=\"text/html; charset=UTF-8\">");<img src="http://sdt.sumida.com.cn:8080/cs/aggbug.aspx?PostID=116" width="1" height="1">alexhttp://sdt.sumida.com.cn:8080/cs/members/alex.aspx[转]同一电脑上同时安装并运行.net 1.1 和 .net 2.0 两个版本(仅安装2.0运行环境时必看)http://sdt.sumida.com.cn:8080/cs/blogs/alex/archive/2006/04/17/111.aspx2006-04-17T14:13:00Z2006-04-17T14:13:00Z<P><BR>各位在同一电脑上同时安装并运行.net 1.1 和 .net 2.0 两个版本的朋友要小心啊！</P>
<P>您的项目是不是时不时会出现 Server Application Unavailable 错误呢？或者一直连续都出这个错误!</P>
<P>今天我朋友将其从1.1升级至2.0的项目发布至公司安装有windows 2003的服务器上，结果2.0的项目始终无法成功运行。甚至还造成服务器上正在为全公司服务的基于.net Framework 1.1的web程序出错。他感觉很奇怪，在自己电脑上明明运行的很好啊，怎么一到服务器上就不行了？<BR>他发布2.0 web程序的过程如下：</P>
<P>1、在服务器上创建一个目录，然后将发布后的所有Web程序的文件复制到这个新建的目录。<BR>2、在服务器的IIS上新建一个虚拟目录，然后 将其配置成可以执行脚本的应用程序，（过程与创建.net Framework 1.1版本的程序相同。） 然后，将此虚拟目录的.net Framework 配置成2.0。 <BR>大功告成后，开始访问刚配置的程序，却得到如下错误：</P>
<P><BR>Server Application Unavailable <BR>The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request. </P>
<P>Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.</P>
<P>之后向我求助，经过仔细阅读了IIS帮助文档，才发现，原来这个错误是由 IIS6 应用程序隔离机制造成的。IIS默认的应用程序隔离机制被称为：“工作进程隔离模式”，在此模式中，应用程序被分为多个组，每个组就是一个“应用程序池” ，每个应用程序池之间是相互隔离的。 隔离的好处当然就是安全啦，稳定啦，等等。IIS中的每个应用程序池由一个“工作进程”分别进行管理，也就是"W3wp.exe" 。如果有多个应用程序池中的程序运行，我们就能看到多个w3wp.exe。 我们平时新建的虚拟目录都默认被指向IIS6的“DefaultAppPool" 中， 所以在默认情况下，不管你有多少个asp.net程序在运行，在“Windows任务管理器”中你只能看到一个w3wp.exe进程。</P>
<P>出现上述错误的原因是： .net Framework 2.0的程序与.net Framework1.1(或1.0)的程序被放入同一个应用程序池（默认情况下放入DefaultAppPool池），也就是由同一个工作进程: w3wp.exe 进行管理，而单个工作进程是无法同时管理不同的程序（或者不同版本的程序）的。如果先访问.net framework 1.1的页面，则工作进程先加载并管理了 1.1版本的程序集，此时访问.net framework 2.0的web程序页面，Server Application Unavailable 错误就出来了。 反之，如果在默认应用程序池的w3wp.exe尚未启动前先访问了 2.0的web程序（此时应用程序集已经加载了.net framework2.0的Web程序集），再访问1.1或1.0的Web程序页面时，同样会出现“服务器应用程序不可用” 这样的中文提示。（您可以结束掉以前的w3wp.exe进行测试。）</P>
<P>我朋友之所以在自己的开发机器上没出现此错误是因为他在开发基于.net framework 2.0的项目时，一直都只访问这个2.0的web程序，跟本未曾访问过其他web程序。而朋友的服务器上已经存在1.0 的项目，并且一直有人使用。这个错误在今天之前从未碰到过，其实大部分人在开发一个项目时，都只访问正在开发的项目。很有可能就忽略了这个问题，而到了发布的时候却出现错误，搞得手忙脚乱。</P>
<P>解决办法： 在IIS中新建一个应用程序池，然后选中你的 基于.net framework2.0的虚拟目录，点“属性”－》在“应用程序池” 中选择刚才新建的的应用程序池，点击“确定”。</P>
<P>如果你的电脑主要是为了学习，开发，测试web程序，完全可以建一个类似于名为"dotnet2.0"的应用程序池，以后所有新建的2.0的虚拟目录都指向此应用程序池。</P>
<P>[2006-03-16 更新] : 如果通地vs 2005ＩＤＥ 直接创建在IIS 上创建Web Site时，vs 2005会自动添加 ASP.NET 2.0 应用程序池，并且将新创建的Web Size 虚拟目录指向新建的应用程序池。<BR></P><img src="http://sdt.sumida.com.cn:8080/cs/aggbug.aspx?PostID=111" width="1" height="1">alexhttp://sdt.sumida.com.cn:8080/cs/members/alex.aspx为javascript加上trim方法http://sdt.sumida.com.cn:8080/cs/blogs/alex/archive/2006/03/28/68.aspx2006-03-28T03:36:00Z2006-03-28T03:36:00Z<P><script language="javascript"></P>
<P>String.prototype.trim= function() <BR>{ <BR> return this.replace(/(^\s*)|(\s*$)/g, ""); <BR>} </P>
<P>var strCode = " daaaddk";</P>
<P>alert(strCode.trim());</P>
<P></script></P><img src="http://sdt.sumida.com.cn:8080/cs/aggbug.aspx?PostID=68" width="1" height="1">alexhttp://sdt.sumida.com.cn:8080/cs/members/alex.aspxUnix下用sed命令把含有制表符的文本文件转为XML格式http://sdt.sumida.com.cn:8080/cs/blogs/alex/archive/2006/03/14/53.aspx2006-03-14T04:03:00Z2006-03-14T04:03:00Z<P>---命令</P>
<P>sed -e :a -e '/^\n*$/{$d;N;ba' -e '}' -e '1s/^/<?xml version=\"1.0\"?><table><row><cell>/' -e s/" "/"<\/cell><cell>"/g -e s/.$/"<\/cell><\/row><row><cell>"/g -e '$s/$/<\/table>/' -e s/"<row><cell><\/table>"/"<\/table>"/g file_from > file_to</P>
<P><BR>---說明<BR>-e :a -e '/^\n*$/{$d;N;ba' -e '}' :去掉文件尾的空行</P>
<P>-e '1s/^/<?xml version=\"1.0\"?><table><row><cell>/' :在文件头加Xml开始标记</P>
<P>-e s/" "/"<\/cell><cell>"/g :把制表符替换成XML列标记,这里的" "是制表符，直接键入的</P>
<P>-e s/.$/"<\/cell><\/row><row><cell>"/g :把换行符替换成XML行标记</P>
<P>-e '$s/$/<\/table>/' :在文件尾添加XML结束标记</P>
<P>-e s/"<row><cell><\/table>"/"<\/table>"/g :把最后一行的标记修正</P>
<P>file_from :源文件</P>
<P>file_to:目标文件</P>
<P> </P><img src="http://sdt.sumida.com.cn:8080/cs/aggbug.aspx?PostID=53" width="1" height="1">alexhttp://sdt.sumida.com.cn:8080/cs/members/alex.aspx[原创]FormatString function in javascript(like c#)http://sdt.sumida.com.cn:8080/cs/blogs/alex/archive/2006/03/07/10.aspx2006-03-07T09:44:00Z2006-03-07T09:44:00Z<P>function FormatString(sSource)<BR>{<BR> for(var i=1; i<FormatString.arguments.length; i++) <BR> {<BR> var vValue = FormatString.arguments[ i ];<BR> sSource = mReplace(sSource,"{" + (i-1) + "}",vValue);<BR> }<BR> return sSource;<BR>}</P>
<P>function mReplace(mainStr,findStr,replaceStr)<BR>{<BR> var iStart=0;<BR> var iEnd=0;<BR> var sRet="";<BR> while (iStart<mainStr.length) {<BR> iEnd=mainStr.indexOf(findStr,iStart);<BR> if (iEnd<0) {<BR> iEnd=mainStr.length;<BR> sRet=sRet+mainStr.substring(iStart,iEnd);<BR> }<BR> else {<BR> sRet=sRet+mainStr.substring(iStart,iEnd)+replaceStr;<BR> }<BR> iStart=iEnd+findStr.length;<BR> <BR> }<BR> return sRet;<BR>}</P><img src="http://sdt.sumida.com.cn:8080/cs/aggbug.aspx?PostID=10" width="1" height="1">alexhttp://sdt.sumida.com.cn:8080/cs/members/alex.aspx