html coding error from database?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Fary4u
    Contributor
    • Jul 2007
    • 273

    html coding error from database?

    Hi i'm just accessing value from the database & it's text filed when i'm display into browser it's displaying 1 extra value which is like this

    Stored in Database:
    Save: £

    Displaying in Browser:
    Save: £

    i've just delete the white space but still getting this error what this mean is ?

    Â

    if somebody already have this problem plz let me konw thx.
  • DrBunchman
    Recognized Expert Contributor
    • Jan 2008
    • 979

    #2
    Usually that's a sign of formatting or crap data or something like that being held in the database.

    Can you print the code that retrieves and displays the values?

    Do you have control over the content of that field in the db and if so are you certain that it was only normal text that was inserted?

    Dr B

    Comment

    • Fary4u
      Contributor
      • Jul 2007
      • 273

      #3
      Yes it's just text fild in a database & to access simple write the ADO query which is

      <%= rsCatalog("prod save") %>

      the only thing is when i remove the pound sign it's came up fine
      but when i insert the pound sign then it's bring the  there is no extra white space ?

      rest of the code is working fine.

      Thx for you concern.

      Comment

      • jhardman
        Recognized Expert Specialist
        • Jan 2007
        • 3405

        #4
        can you replace it with the html escape character (&#38;pound;) ?

        Jared

        Comment

        Working...