Click here to Skip to main content
16,006,440 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionCrysaltal Report Pin
sivaprakas28-Jan-08 19:34
sivaprakas28-Jan-08 19:34 
GeneralWrong forum Pin
pmarfleet28-Jan-08 19:42
pmarfleet28-Jan-08 19:42 
GeneralRegarding Importing excel file to asp.net page Pin
sandhya1428-Jan-08 19:29
sandhya1428-Jan-08 19:29 
GeneralRe: Regarding Importing excel file to asp.net page Pin
R.Palanivel28-Jan-08 19:38
R.Palanivel28-Jan-08 19:38 
GeneralRe: Regarding Importing excel file to asp.net page Pin
sandhya1428-Jan-08 20:07
sandhya1428-Jan-08 20:07 
Generalupdate panel Pin
solarthur0128-Jan-08 13:28
solarthur0128-Jan-08 13:28 
GeneralRe: update panel Pin
bokuceres28-Jan-08 15:51
bokuceres28-Jan-08 15:51 
Questionour forum has msgs > 8K Pin
shefali_sinha28-Jan-08 11:08
shefali_sinha28-Jan-08 11:08 
Hi,

Our website provide users with a forum where they can enter messages. So, typically, a user would enter a message, click submit, and their message would be displayed on the forum.

The db that stores these msgs uses a varchar field. Now, we're adding a facility to convert any urls that are entered to links by adding 'a href' tags, so that when users see messages with urls, those urls appear as links, and they can click on them. The problem is that if a user enters a message of 8K chars, then we add 'a href' tags to any urls they have, that makes the message length > 8K, preventing us from storing it in our db. (Please note that we do need to add HTML tags for other reasons as well, not just to convert urls to links.)

We thought about adding 'a href' tags during pre-render, thus avoiding storing html in the db, but found that doing such string manipulations, while a user is waiting to see their post displayed on the forum, was expensive. Timing tests revealed that the time to render such pages more than doubled.

I have solved such problems previously by adding an extra field in the db to store any overflow data, that is, data that appears after the first 8K chars.

However, I learnt of sql server 2005's varchar(max) datatype, and 'am wondering if the best way to solve this problem would be to replace the varchar field with varchar(max).

Thanks in advance for any advice.
Shefali
GeneralRe: our forum has msgs > 8K Pin
Not Active28-Jan-08 13:11
mentorNot Active28-Jan-08 13:11 
QuestionForm fields appear dynamically Pin
Muhammad Gouda28-Jan-08 7:50
Muhammad Gouda28-Jan-08 7:50 
GeneralRe: Form fields appear dynamically Pin
Mike Ellison28-Jan-08 8:32
Mike Ellison28-Jan-08 8:32 
GeneralRe: Form fields appear dynamically Pin
Not Active28-Jan-08 8:32
mentorNot Active28-Jan-08 8:32 
GeneralRe: Form fields appear dynamically Pin
Sandeep Akhare28-Jan-08 20:02
Sandeep Akhare28-Jan-08 20:02 
GeneralASP.NET & Sharepoint error when adding control to a project Pin
michael@cohen28-Jan-08 7:46
michael@cohen28-Jan-08 7:46 
QuestionCalling a javscript from a function in asp.net Pin
Yatish Kasa28-Jan-08 6:33
Yatish Kasa28-Jan-08 6:33 
GeneralRe: Calling a javscript from a function in asp.net Pin
Not Active28-Jan-08 8:21
mentorNot Active28-Jan-08 8:21 
QuestionChanging Skin of Web Page [modified] Pin
wEb GuRu...28-Jan-08 6:15
wEb GuRu...28-Jan-08 6:15 
AnswerRe: Changing Skin of Web Page Pin
newc128-Jan-08 23:35
newc128-Jan-08 23:35 
GeneralWindows Authentication : NT Authority\Anonymous LOGON error Pin
ss.mmm28-Jan-08 5:50
ss.mmm28-Jan-08 5:50 
Questioncheckbox CheckedChanged event not firing after conversion to .net 3.5 Pin
icewolf_snowfire28-Jan-08 5:31
icewolf_snowfire28-Jan-08 5:31 
GeneralASP.NET Web application Pin
zeeShan anSari28-Jan-08 3:22
zeeShan anSari28-Jan-08 3:22 
AnswerRe: ASP.NET Web application Pin
newc128-Jan-08 5:24
newc128-Jan-08 5:24 
GeneralRe: ASP.NET Web application Pin
zeeShan anSari28-Jan-08 6:49
zeeShan anSari28-Jan-08 6:49 
GeneralImage Preview Pin
NjMikw28-Jan-08 2:37
NjMikw28-Jan-08 2:37 
GeneralRe: Image Preview Pin
newc128-Jan-08 5:33
newc128-Jan-08 5:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.