XML Serialization

November 30, 2006 at 2:06 AMJoshua Harley

I know you don't see anything on your end, but the backend has had a major overhaul! I finally got away from using ArrayLists to return my data and instead wrote my own collections (based off of the abstract class System.Collections.CollectionBase) and added the [XmlAttribute], [XmlElement], [XmlRoot], and lastly [XmlArrayItem] to the classes to allow them to be serialized. It doesn't mean much to you viewers, but it does allow me to actually publish a specification that doesn't rely on the .net framework. It is quite late and I am tired, so I'll cut this short. Hopefully some of the other functionality will be available to you soon!

Posted in: Site Information

Tags:

Comment Splitting

November 27, 2006 at 4:18 PMJoshua Harley

Well, thanks to the keen eye of my brother a small, but important, slip up has been fixed. It was an artifact of using the SQL "SELECT ... WHERE ... LIKE ... %" clause, and I was just simply checking for the categories based on their index number. The problem with that was the SELECT statement was "WHERE Categories LIKE '%' + CAST(@categoryID AS nvarchar(10)) + '%'". All that did was check the category number for <anything>CategoryNumber<anything> - which worked just fine with single digit numbers. Jared noticied this with category #2, which matched everything from category 2, 12, all of the 20s, etc. To remedy this, I changed the layout to use pipes, so now they are stored like |1|2|3| instead of 1,2,3. Once again, thanks Jared!

Posted in: Site Information

Tags:

One more thing

November 25, 2006 at 6:14 AMJoshua Harley
Just a quick note! I have upgraded my main server, Tsunami, to 64-bit. More on that later! Also, it is a bunch of fun working with SQL (I haven't worked with it this much before). I have stored procedures doing all the calls into it so far, to help reduce the attack surface. To help visitors see the site quicker (my site isn't that frequently visited) I am only using the precompiled version of my website, so when the application loads it just starts spitting out the HTML and all that stuff. It's a really neat feature of Visual Studio 2005 and ASP.NET 2.0.

Posted in: Site Information

Tags:

Creating my own blog

November 25, 2006 at 6:00 AMJoshua Harley
Well, as I am sure you have noticed, I am attempting to create my own blog. I hope to have the basics done soon, but for now you can at least view the 10 latest entries as I add them back in. This blog will be coded using ASP.NET 2.0 (in C#) using both the master pages and having a web service backend. For storage I have moved to Microsoft SQL Server 2005. I wasn't too happy about how dasBlog was performing, so instead of searching for yet another one (that'd make three that I've tried to use) I decided that I have learned enough to get me started. I have used many online resources, from google to codeproject to a new site I can't remember right now. All of this code is written by me, and you won't find any online examples that match my code (like you do with some projects when people find codeproject and whatnot.) Ok, so far you have only two pages: default.aspx, which you're probably viewing right now, and category.aspx, which I just got working this morning. Yes, that means you can click on the categories listed beneath the entries and it will show you all related entries (once again, that I have entered so far.) Well, it is early in the morning and I am quite tired. Keep an eye out for progress!

Posted in: Site Information

Tags: