Friday, September 28, 2007

There just doesn't seem to be any love for the Visual Studio 2005 Web Sit Project.  I know I have none.  I' am  sure its fine for an internally developed web sites, but who cares about those.  For an ISV we need dll's.  It's simpler and your customer can't make unauthorized edits to your code.  So if like me your looking for a simple way to update some of your older asp.net projects Peter Bromberg just posted a nifty trick to get your visual studio 2003 class library project to convert to a visual studio 2005 web application project.  I recommend you take a look and save your self a migraine.

posted by Aaron Fischer on Friday, September 28, 2007 6:07:40 AM (Pacific Standard Time, UTC-08:00)   #    Comments [0]
 Wednesday, September 26, 2007

How not to access an asp.net Repeater control's data 

 

It would appear that between some .net updates Microsoft likes to change how Asp.net names controls.

>
For i As Integer = 0 To ilsn - 1       
 Dim controlname As String = "repGrid:_ctl" & i + 1 & ":txtOrder"
 Dim controlnameVal As Int32 = Request(controlname)
 StoreVal( ControlNameVal)
Next

This approach is safer

>
For Each di In repGrid.Items       
 Dim controlnameVal As Int32 = ConvertToINT( di.FindControl("txtOrder"))
 StoreVal( ControlNameVal)
Next

 

When your using an asp.net Repeater control you need to call find control on the given row in order for it to properly resolve the name.

Also of interest is this little nugget found on The Scripts forum:

.net Changing $ to _ ?

http://www.thescripts.com/forum/thread703070.html

ms went down a rat hole with names and ids. they started with ":" as

separator, but found this was illegal in an id or name, so replaced it

"$". then they realized "$" was illegal in an id when they wanted xhtml

compliance, so they changed it to "_" in an id.

posted by Aaron Fischer on Wednesday, September 26, 2007 2:05:47 PM (Pacific Standard Time, UTC-08:00)   #    Comments [0]

I finally got tired of visiting the Calyx Support Message board today.  So a took a couple minutes to craft a little Regex to parses out all the RSS feeds ( there is not master feed). http://messageboard.calyxsupport.com/RssFeed+[\d]?[\d]-0-0-1\.aspx+

Then created an OPML file

>

<opml version="1.0">
	<head>
		<title></title>
	</head>
	<body>
		<outline title="Calyx Message Board" text="Calyx Message Board">
			<outline text="Calyx Software Message Board / Calyx Point / Cardex" title="Calyx Software Message Board / Calyx Point / Cardex" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed34-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / Calyx Point / Citrix / Terminal Server" title="Calyx Software Message Board / Calyx Point / Citrix / Terminal Server" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed7-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / Calyx Point / Communications / E-Mail" title="Calyx Software Message Board / Calyx Point / Communications / E-Mail" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed13-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / Calyx Point / Custom Forms" title="Calyx Software Message Board / Calyx Point / Custom Forms" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed9-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / Calyx Point / Fannie Mae" title="Calyx Software Message Board / Calyx Point / Fannie Mae" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed16-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / Calyx Point / File Management" title="Calyx Software Message Board / Calyx Point / File Management" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed10-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / Calyx Point / Forms / Regulations" title="Calyx Software Message Board / Calyx Point / Forms / Regulations" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed11-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / Calyx Point / Installation / Network Setup" title="Calyx Software Message Board / Calyx Point / Installation / Network Setup" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed5-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / Calyx Point / Lenders in Point" title="Calyx Software Message Board / Calyx Point / Lenders in Point" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed15-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / Calyx Point / Miscellaneous" title="Calyx Software Message Board / Calyx Point / Miscellaneous" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed18-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / Calyx Point / Printing" title="Calyx Software Message Board / Calyx Point / Printing" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed8-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / Calyx Point / Reports" title="Calyx Software Message Board / Calyx Point / Reports" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed12-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / General Discussion / General Chat" title="Calyx Software Message Board / General Discussion / General Chat" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed22-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / General Discussion / Industry Chat" title="Calyx Software Message Board / General Discussion / Industry Chat" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed23-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / General Discussion / Message Board" title="Calyx Software Message Board / General Discussion / Message Board" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed30-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / Point Data Server (PDS) / Point Data Server (PDS)" title="Calyx Software Message Board / Point Data Server (PDS) / Point Data Server (PDS)" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed19-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / WebCaster / Suggestions &amp; Requests" title="Calyx Software Message Board / WebCaster / Suggestions &amp; Requests" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed32-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
			<outline text="Calyx Software Message Board / WebCaster / WebCaster" title="Calyx Software Message Board / WebCaster / WebCaster" type="rss" xmlUrl="http://messageboard.calyxsupport.com/RssFeed20-0-0-1.aspx" htmlUrl="http://messageboard.calyxsupport.com/"/>
		</outline>
	</body>
</opml>

copy the above to notepad and save as a .xml file.  You can then import it into your rss reader of choice.

posted by Aaron Fischer on Wednesday, September 26, 2007 1:11:28 PM (Pacific Standard Time, UTC-08:00)   #    Comments [0]
 Wednesday, September 19, 2007

MDX Studio is worth a look If your using Multidimensional Expressions(MDX) in your SQL database.

Just for some background here is links to MSDN's MDX Reference.

Multidimensional Expressions (MDX) Reference

Key Concepts in MDX (MDX)

posted by Aaron Fischer on Wednesday, September 19, 2007 6:44:06 AM (Pacific Standard Time, UTC-08:00)   #    Comments [0]
 Wednesday, September 12, 2007

BlownMortgage offered up a depressing story about life during the peak of the mortgage boom, presented by TheTruthAboutMortgage.com

It turned out the borrower was actually employed as a loan processor, undoubtedly making less than $240,000 a year (sure some may have been making that during the boom, but that was not the case here).

In any event, you would think the loan would be dead, considering the borrower lied about their income and employment on a legal document.

Well, not the case in the mortgage industry. Instead of the file being declined, it was uplined to the VP of Underwiting who massaged the loan, probing and searching for some way to make sense of a lie. After all, the loan was worth $1.5 million, so clearly the company had no intention of throwing it away. And if it could be cleaned up a bit and sold to the investor, no one would be the wiser.

After some research, it came to the VP’s attention that the borrower was a licensed real estate agent, and just like that the 1003 was miraculously changed to state that the applicant was a loan processor and a real estate agent, earning the originally stated $20,000 a month.

It would seem money was growing on trees.

posted by Aaron Fischer on Wednesday, September 12, 2007 7:10:29 PM (Pacific Standard Time, UTC-08:00)   #    Comments [0]
 Thursday, September 06, 2007

Max row size in SQL 2000 8060 bytes.
Max row size in SQL 2005 more then 8060 bytes if the table contains Var* or XML columns.  This is due to SQL 2005 Row-Overflow, this will affect performance of the database. ( the Varchar... will be moved to a separate page and a 24-byte pointer will be inserted into the original page.)

SQL database page size is 8KB or 8,000 bytes.
SQL data types    2000, 2005, 2008

char (N) = 1 * N bytes
varchar (N) = 1 * N + 2 bytes
nvarchar (N) = 2 * N + 2 bytes
DateTime = 8 bytes
Float = 8 bytes
ntext/text is being replaced with nvarchar(MAX)/varchar(MAX).  MAX = 2^31 - 1 bytes.
ntext/text is stored in separate page

 

Microsoft SQL Server 7.0 Storage Engine

Inside Microsoft® SQL Server™ 2005: The Storage Engine

Maximum Capacity Specifications for SQL Server 2005

SQL 2005 Fragmentation Information

posted by Aaron Fischer on Thursday, September 06, 2007 10:26:24 AM (Pacific Standard Time, UTC-08:00)   #    Comments [0]

Doug Stewart has posted an extensive list of CRL 2.0 bug (hot)fixes.  Its worth a look if your Dot Net 2.0 app is having issues.  Thanks for putting together such a comprehensive list Doug. 

I have seen this issue on a QA server The managed heap becomes corrupted when you run a program that is built by using the Microsoft .NET Framework 2.0 good to see its not my code and that there is a fix for it.

Some of the Hot fix support articles do leave a little something to be desired though I would like to see Microsoft spend the time to detail the cause for each issue so I can better evaluate my need for a given fix.

posted by Aaron Fischer on Thursday, September 06, 2007 6:27:40 AM (Pacific Standard Time, UTC-08:00)   #    Comments [0]