Last post Sep 29, 2007 04:51 AM by firstname.lastname@example.org
Sep 26, 2007 02:20 PM|RobdeHaan|LINK
I recently finished my Club Starter Kit (with the original one) and have one problem left. When i'm adding a new article with a lot of text it doesn't work. With 4 lines or so everything works fine, but when i try to add like 20 lines it just doesn't do
Ps. You can check my site at www.cloeckenmoedigh.nl
Sep 26, 2007 03:04 PMemail@example.com|LINK
What is the maximum size for an article in the database? what is the column field type and size?
Sep 27, 2007 10:02 AM|RobdeHaan|LINK
For starters, i'm a complete noob when it comes to ASP, but the Club Starter Kit was so easy, that even I could do it. I used Microsoft Visual Web Developer 2005 Express to make it. When I browse to the database (club.mdf) and then open tables - events -
description I see Length=800, but i'm unable to change it. Is this the value i should change and if so, how do i do this?
Sep 27, 2007 07:57 PM|MaineOne|LINK
you can use "sql server management studio express" to modify the table. if you do not have it download it at
Once you get to the table you can change the Data Type and Max Length.
I changed it to varchar with a max of 8000
Sep 29, 2007 04:30 AM|RobdeHaan|LINK
I tried this, but i guess i don't inderstand. Can i simply open the club.mdf file in SQL Server Management Studio Express?
When i open this program and open the club.mdf file, it says:
There is no editor available for c:\.....\club.mdf. Make sure the application for the file type (.mdf) is installed.
Sep 29, 2007 04:51 AMfirstname.lastname@example.org|LINK
You should be able to open your SQL Express database from within your Visual Studio.Expand the
App_Data folder in your solution explorer window (on the right the one that lists all the files in your website), then right click on your database and click
open. This should display something similar to the below screen shot:
Then you can find your table and click Open Table Definition. You should then be able to change the size of your column. Can you confirm that you have SQL Express installed.If not you can get it from here