Formatting data BEING TAKEN FROM AN aCCESS DB

Author Message
Slayer73

  • Total Posts : 17
  • Scores: 0
  • Reward points : 0
  • Joined: 6/27/2001
  • Location: USA
  • Status: offline
Formatting data BEING TAKEN FROM AN aCCESS DB Monday, July 09, 2001 1:00 PM (permalink)
0
i'M TAKING DATA FROM AN ACCESS DATABASE AND POSTING IT TO AN ASP PAGE. tHE PROBLEM IS THE ONE OF THE FORMS IS A TEXTAREA FIELD THAT HOLDS UP TO 200 CHARACTERS. wHEN i COPY THE DATA BACK FROM THE ACCESS FILE IT MAKES THE PAGE TOTALLY SCREWED UP. iS THERE ANYWAY TO FORMAT THE THAT FIELD BEFORE IT IS GENERATED ON THE ASP PAGE. TY ALL. S73

 
#1
    adminkoe

    • Total Posts : 114
    • Scores: 0
    • Reward points : 0
    • Joined: 12/23/2000
    • Location:
    • Status: offline
    Re: Formatting data BEING TAKEN FROM AN aCCESS DB Wednesday, July 11, 2001 6:06 AM (permalink)
    0
    What kind of formatting?. Visual formatting?

    Regards,
    Andi Zain
     
    #2
      Slayer73

      • Total Posts : 17
      • Scores: 0
      • Reward points : 0
      • Joined: 6/27/2001
      • Location: USA
      • Status: offline
      Re: Formatting data BEING TAKEN FROM AN aCCESS DB Thursday, July 12, 2001 11:58 AM (permalink)
      0
      In other words when I take the information from the database and post it to my page within a table I want it to be x characters wide. Not one big long string that extends across the entire page. It looks like crap. Am I making sense? I'm new to this so correct me if I am. TY

       
      #3
        adminkoe

        • Total Posts : 114
        • Scores: 0
        • Reward points : 0
        • Joined: 12/23/2000
        • Location:
        • Status: offline
        Re: Formatting data BEING TAKEN FROM AN aCCESS DB Thursday, July 12, 2001 12:24 PM (permalink)
        0
        Ahh, you should specify the dimension for the textare field.

        It will be something like this:

        <textarea cols=50 rows=10>

        your data here
        </textarea>



        Regards,
        Andi Zain
         
        #4
          Slayer73

          • Total Posts : 17
          • Scores: 0
          • Reward points : 0
          • Joined: 6/27/2001
          • Location: USA
          • Status: offline
          Re: Formatting data BEING TAKEN FROM AN aCCESS DB Thursday, July 12, 2001 2:58 PM (permalink)
          0
          Andi,
          I tried that. The information will be inputted by a user (no more than 250 characters) upon submit it is sent to an Access Database and the user is sent to a following page. On that page they have the option of looking at the most recent submissions. By selecting "reports" the information in the Access DB is called to the page and displayed. My problem is when it is called it comes in a huge line totally screwing up the layouf of that *.asp page. I think that may be better. My *.htm page is set up like you said previously. TY

           
          #5
            imav8n

            • Total Posts : 95
            • Scores: 0
            • Reward points : 0
            • Joined: 7/3/2001
            • Location: USA
            • Status: offline
            Re: Formatting data BEING TAKEN FROM AN aCCESS DB Friday, July 13, 2001 11:03 AM (permalink)
            0
            So if I understand this right, then you have an html page with a fixed width textarea field, that submits to an .asp page that writes to a db...then you want to be able to read and display the contents of the db, but the display is all horked up...so try bounding your displayed information in a table, and restrict the width of the table or cell...

            ie: <table width=50%><tr><td> YOUR DATA HERE </td></tr></table>

            ~imav8n
             
            #6
              Slayer73

              • Total Posts : 17
              • Scores: 0
              • Reward points : 0
              • Joined: 6/27/2001
              • Location: USA
              • Status: offline
              Re: Formatting data BEING TAKEN FROM AN aCCESS DB Friday, July 13, 2001 12:10 PM (permalink)
              0
              ~imav8n
              All true but I did that. I bounded that field just like that but it still doesn't work. I'm beginning to believe that I'll have to format the string before it submits to the asp page and writes to the DB. It is an Access DB. That is funny horked up and that is exactly the word. It spread the screen like a mile to the right. I'd like to have to text wrap at designated points like the 25 character or a blank character in or around that whichever comes first. What to do? TY Slayer73


               
              #7
                adminkoe

                • Total Posts : 114
                • Scores: 0
                • Reward points : 0
                • Joined: 12/23/2000
                • Location:
                • Status: offline
                Re: Formatting data BEING TAKEN FROM AN aCCESS DB Friday, July 13, 2001 12:27 PM (permalink)
                0
                Slayer,

                If that's the case, you should insert some <br> tags inside the long string in your access database field. This should fix the problem.




                Regards,
                Andi Zain
                 
                #8
                  nagesh840

                  • Total Posts : 1
                  • Scores: 0
                  • Reward points : 0
                  • Joined: 7/14/2001
                  • Location: India
                  • Status: offline
                  Re: Formatting data BEING TAKEN FROM AN aCCESS DB Saturday, July 14, 2001 8:41 AM (permalink)
                  0
                  abcdefghijklmnopqrstuvwxyz
                  1234567890

                  nagesh
                   
                  #9

                    Online Bookmarks Sharing: Share/Bookmark

                    Jump to:

                    Current active users

                    There are 0 members and 1 guests.

                    Icon Legend and Permission

                    • New Messages
                    • No New Messages
                    • Hot Topic w/ New Messages
                    • Hot Topic w/o New Messages
                    • Locked w/ New Messages
                    • Locked w/o New Messages
                    • Read Message
                    • Post New Thread
                    • Reply to message
                    • Post New Poll
                    • Submit Vote
                    • Post reward post
                    • Delete my own posts
                    • Delete my own threads
                    • Rate post

                    2000-2012 ASPPlayground.NET Forum Version 3.9