Hi, I'm new to this forum,

I'm testing club website on my pc, I can create photo albums as administrator but when I try to write news or events and save it the website doesn't save it...why?

Thanks

I use C#

do you get any kind of error?

 No any kind of error, I've been redirected to news or event new pages but news and events aren't saved.

thanks

news:

Short news or events are saved, longest one aren't...

please help me  

By default the description column is set to varchar(800), if you go into the Events table and set it to varchar(max) it should fix the issue. 

MaineOne:

By default the description column is set to varchar(800), if you go into the Events table and set it to varchar(max) it should fix the issue. 

I dont think this is the prob of field size, as he said no error is coming and if field size prob occurs, it throws exception...

I'sorry for my ignorance maybe I'm doing something wrong, it's long time that I don't use vwd...I've found the description table in club.mdf database but I can't change the lenght and properties of tables, If I'm not wrong I remember that I could change this properties in vwd then I've tried to open the website's database with sqlserver management studio express but I can't change properties even this way. I've noted that when I've tried to start sqlsmse the server name was computer name/sql server but it wouldn't start, the reason was that recently I've changed my computers name once I've pasted my new computer name in the name server window it starts. Is it possible that I can't edit tables properties for this reason or I'm completely on the wrong way? Is it possible that my problem resides in sql that hasn't updated my new computer name?

Thank you in advance.  

No it will not throw an error, but it is because you are truncating a field. changing the varchar will fix the problem.

Why it does not throw an error is that the redirect is still triggering. Therefore you do not have a chance to see the error.

MaineOne:

No it will not throw an error, but it is because you are truncating a field. changing the varchar will fix the problem.

Why it does not throw an error is that the redirect is still triggering. Therefore you do not have a chance to see the error.

Thank you MaineOne, as you can read in my reply I'm not able to change varchar setting, can you please explain me how do this, I'll be grateful to you.

My last news is that if I copy and paste the text of news or events in the description box it isn't saved, if I write it myself it is saved!!!???Why...

Why this website isn't available in italian language?

I do believe if you are using VWD express you cannot change the settigs, but if you are using SQL management you should be able to.  I'll check it out later today and give you a step by step.

As far as the copy and paste, again I will look into it more, but I believe it could be that you are copying from a app with formatting, what you are pasting into is a multiline textbox.  Most people use http://freetextbox.com/ or other html editor.  That will allow you to save formatted text.  

 On database issue, I was incorrect you should be able to change it useing VWD express.  Goto the Database Explorer and right click on the table then select Open Table Definition.

If that does not work for you let me know if it even opens the definition view.

MaineOne:

 On database issue, I was incorrect you should be able to change it useing VWD express.  Goto the Database Explorer and right click on the table then select Open Table Definition.

If that does not work for you let me know if it even opens the definition view.

 

Thank you MaineOne you've solved all my problems I've changed varchar from 800 to max with vwd, now all works fine I was wrong because I tried to change this value in the property window of description instead of the "Events" table as you wrote.

If somebody is interested to this topic there is a simple way to bypass this problem

1)Add new event as administrator

2)write the heading

3)select link and Use a link instead of inline content for this anouncement putting the page name as link: youreventpage.aspx

4)write a short description for this event and save (in a new page you can copy and paste text without problems and you can create new pages simply by coping a page as "contact" rename it and adding your content in the content place holder)

maybe this way is better for indexing events and news in search engines

Thank you very much MaineOne