Monthly Archives: November 2008

Web程序中报错”存储空间不足,无法完成此操作”

Posted on November 27, 2008 by blogger616

如下图： 经过调试以后发现，这个错误是因为：Windows注册表中IE浏览器的属性User Agent的默认值在某种情况下被修改掉了。在模式窗口ShowModalDialog中使用Navigator对象时，就会报这个错。

Posted in IT技术文章 | Leave a comment

HTML中如何让局部产生滚动条，并且让滚动条自动滚动到最底部？

Posted on November 21, 2008 by blogger616

看着个示例，下面这个是如何产生局部滚动条，采用的是div来实现<td vAlign="top" width="100%" height="400">    <div id="div1" style="OVERFLOW-Y: scroll; WIDTH: 100%; HEIGHT: 100%">        <TABLE id="Table9" style="BORDER-COLLAPSE: collapse" borderColor="#c0c0ff" cellSpacing="1"            cellPadding="2" width="100%" border="1">            <TR>                <TD class="SmallPartHeader" align="center" colSpan="2">High Level Design History (<asp:label id="lblVersion1" runat="server"></asp:label>)</TD>            </TR>            <tr>                <td id="tdDesignHistory" vAlign="top" runat="server">&nbsp;</td>            </tr>        </TABLE>    … Continue reading →

Posted in IT技术文章 | Leave a comment

.NET 2.0 SiteMap使用的时候有一个错误

Posted on November 12, 2008 by blogger616

在代码中：SiteMap.Providers引发了一个ConfigurationErrorException,我检查了一下相关的XML配置没有发现异常，跟踪发现异常信息如下：BareMessage = "The connection name ‘OraAspNetConString’ was not found in the applications configuration or the connection string is empty."Message = "The connection name ‘OraAspNetConString’ was not found in the applications configuration or the connection string is empty. (c:\\WINDOWS\\Microsoft.NET\\Framework\\v2.0.50727\\Config\\machine.config line 145)" … Continue reading →

Posted in IT技术文章 | Leave a comment

SQL Server处理ntext字段时的2个问题

Posted on November 6, 2008 by blogger616

1、如何去掉重复字段？由于ntext类型的字段存储方式不通，SQL Server不能distinct，需要使用一个子查询来做。 CREATE PROCEDURE [dbo].[sp_Pts_GetRecordList]@ProblemID intASselect a.*,(select DesignContent from pts_lowlevelDesign where lowDesignId=a.recordId) as Contentfrom v_pts_records awhere problemid=@ProblemIDorder by datecreated 其中视图v_pts_records中已经将大文本字段过滤掉了。 2、多个ntext字段如何合并？因为ntext字段的存储不是ASCII码，不能在SQL语句中直接做合并，只能从程序中合并，参考如下代码，需要做3遍Case选择返回3个独立的ntext字段： CREATE PROCEDURE [dbo].[sp_Pts_GetRecordList]@ProblemID intASselect a.*,(case a.RecordTypeName     when ‘Low Level Design’  then (select LogicDesign from pts_lowlevelDesign where lowDesignId=a.recordId)    when … Continue reading →

Posted in 计算机与 Internet | Leave a comment