Enter Text In Text Data Type

  • Hi, How do I add text to Sql Server table? I used every data type possible and when I enter text using a textbox and retrieve the added text it is in one long string (won't wrap) in datalist area. Please help me! I only works if I copy and paste the text from a Word documents. Then it wraps in the datalist area. But I need to allow users to enter data like I'm doing now. You can email me a ManEFacezz@aol.com.

  • This was removed by the editor as SPAM

  • Hi gregforeman,

    quote:


    Hi, How do I add text to Sql Server table? I used every data type possible and when I enter text using a textbox and retrieve the added text it is in one long string (won't wrap) in datalist area. Please help me! I only works if I copy and paste the text from a Word documents. Then it wraps in the datalist area. But I need to allow users to enter data like I'm doing now. You can email me a ManEFacezz@aol.com.


    I'm not sure if I understand you.

    You have problems adding text into a varchar or text column?

    Normally this shouldn't be a big thing

    Can you post some more explanations on what you use as frontend, maybe some sample code and the structure of the table in question?

    Frank

    http://www.insidesql.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Hi gregforeman,

    What language are you using to create the text box? Does the text box have a property to turn off the word wrapping of data? SQL Server couldn't care less what the data has in it so long as it matches the data type. Thus something like word wrapping is being caused by the front end application and not SQL Server.

    Gary Johnson

    Microsoft Natural Language Group

    DBA, Sr. DB Engineer




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply