Sunday, April 27, 2008
Tuesday, April 22, 2008
Monday, April 21, 2008
Wednesday, April 16, 2008
Ten Common Database Design Mistakes
1. Poor design/planning
2. Ignoring normalization
3. Poor naming standards
4. Lack of documentation
5. One table to hold all domain values
6. Using identity/guid columns as your only key
7. Not using SQL facilities to protect data integrity
8. Not using stored procedures to access data
9. Trying to build generic objects
10. Lack of testing
Source
2. Ignoring normalization
3. Poor naming standards
4. Lack of documentation
5. One table to hold all domain values
6. Using identity/guid columns as your only key
7. Not using SQL facilities to protect data integrity
8. Not using stored procedures to access data
9. Trying to build generic objects
10. Lack of testing
Source
Labels: Database
Thursday, April 10, 2008
Friday, April 4, 2008
dasBlog - Password Challenge was null in ViewState
Was having trouble logging into my dasBlog and after a bit of searching around and finding this at the DasBlog forum and this, realized the problem might be with my web.config file.
And sure enough, found this in the web.config:
Made the necessary changes in my web.config and the blog is working fine again.
And sure enough, found this in the web.config:
NOTE: If you want to run MULTIPLE dasBlogs on the SAME Domain Name include the path in each blog's Web.Config like path="/dasblog1" and path="/yoursite" as appropriate.
Made the necessary changes in my web.config and the blog is working fine again.
Labels: dasBlog, web.config
Wednesday, April 2, 2008
dasBlog and DiscountASP - "Sections must only appear once per config file."
Was trying to install dasBlog (a blogging tool) on this site. I copied all the contents of the 'dasblogce' folder as mentioned in the readme, but ran into a "Sections must only appear once per config file." error in my web.config.
The solution was simple enough, went to my hosting control panel (DiscountASP), to the Web Application tool menu and set up the recently copied folder a web application folder.
The solution was simple enough, went to my hosting control panel (DiscountASP), to the Web Application tool menu and set up the recently copied folder a web application folder.
Labels: ASP.net, dasBlog, DiscountASP, web.config
Tuesday, April 1, 2008
Create a table in an Access DB programatically (using ASP)
From:
CREATE TABLE IN ACCESS - ASP
Not sure what kind of columns BranchName and BranchCode need to be. I'll
assume Text(255) and Integer, respectively.
sTablename = Request.Querystring("name")
sSQL = "CREATE TABLE [" & sTablename & "] (BranchCode Int PRIMARY KEY,
BranchName Text(255));"
objADO.Execute sSQL
CREATE TABLE IN ACCESS - ASP
Not sure what kind of columns BranchName and BranchCode need to be. I'll
assume Text(255) and Integer, respectively.
sTablename = Request.Querystring("name")
sSQL = "CREATE TABLE [" & sTablename & "] (BranchCode Int PRIMARY KEY,
BranchName Text(255));"
objADO.Execute sSQL
