Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004

    Unanswered: Different Display based on Text

    I have an HTMP form and for some reason, when I use a regular TextBox to display a field, Via an ASP conneciton to the database, it cuts it off when it gets to a " (A quote)


    Field: Title
    Data: Where do "rabbits" come from?

    If I try to pull that field into a regular html textbox it dispays,

    Where do

    Then if I change the textbox to a textarea it displays the entire field

    Where do "rabbits" come from?

    Is this a setting that causes this in SQL Server on the table.

    I am new to SQL Server and am trying to learn these little differences.

    Any help would be greatly appreciated.


  2. #2
    Join Date
    Aug 2003
    Andover, MA
    Sounds like an ASP problem. SQL is ignorant of how you are displaying the data.

    Perhaps you need to double the quotes when using a textbox?

    --> Where do ""rabbits"" come from?

    Just guessing.

  3. #3
    Join Date
    Jan 2004
    Then the quotes get saved as double when you display the field in a different manner.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts