Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2006
    Posts
    3

    Question Unanswered: server.htmlencode in sql store procedure?

    hi, i save some text into my database which looks like this..
    <ol>
    <li><strong>adfadsf as </strong>
    <li><strong>asf as </strong>
    <li><strong>dfas </strong>
    <li><strong>df sad </strong>
    <li><strong>f as</strong> </li>
    </ol>

    how m i gg to display them as numbered list in my report?

    i'm using store procedure to retrieve them out into pdf format..

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by cynthialiu
    how m i gg to display them as numbered list in my report?
    w/ vb.

    -PatP

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    xlnt soltn., Pat.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Sep 2006
    Posts
    3
    wat do u all mean? i dun understand.

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    y is yr dta strd lk ths?
    wt r u usng 4 rpts?
    u may hv 2 rite custm sql c0de 2 parse ths.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Sep 2006
    Posts
    3
    my data is like that is because i allow the user to do html formatting of their data.. just like this forum allows u do the the formatting..

    so when i save into my database, it appear likes <strong>test</strong>

    i'm using store procedure of sql to display my reports in crystal reports.

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    If you are only allowing basic formatting, you should consider storing your data formatted as rtf in text datatypes.
    I certainly would refrain from storing data as html in a database unless that data was intended to be displayed in a browser.
    Regardless, this is what we refer to as a "presentation" issues. How the data is displayed has nothing to do with the database server, and is completely up to the reporting software. So you will need to find out whether Crystal Reports can display html code, and can convert it to a numbered list. Check the Crystal help system or post your question in the Crystal Reports forum, but I would not count on finding a simple solution to this.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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