Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


Formatting data BEING TAKEN FROM AN aCCESS DB

 
Logged in as: Guest
arrSession:exec spGetSession 2,3,259
 Active Users: There are 0 members and 0 guests.
 Users viewing this topic: none
 

 

 
  
  Printable Version
All Forums >> [Scripting] >> ASP >> Formatting data BEING TAKEN FROM AN aCCESS DB
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!
Page: [1]
Login
Message << Older Topic   Newer Topic >>
 Formatting data BEING TAKEN FROM AN aCCESS DB - 7/9/2001 12:00:56 PM   
  Slayer73

 

Posts: 17
Score: 0
Joined: 6/27/2001
From: USA
Status: offline
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
 
 
Post #: 1
 
 Re: Formatting data BEING TAKEN FROM AN aCCESS DB - 7/11/2001 5:06:56 AM   
  adminkoe

 

Posts: 117
Score: 0
Joined: 12/23/2000
From:
Status: offline
What kind of formatting?. Visual formatting?

Regards,
Andi Zain

(in reply to Slayer73)
 
 
Post #: 2
 
 Re: Formatting data BEING TAKEN FROM AN aCCESS DB - 7/12/2001 10:58:06 AM   
  Slayer73

 

Posts: 17
Score: 0
Joined: 6/27/2001
From: USA
Status: offline
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

(in reply to Slayer73)
 
 
Post #: 3
 
 Re: Formatting data BEING TAKEN FROM AN aCCESS DB - 7/12/2001 11:24:22 AM   
  adminkoe

 

Posts: 117
Score: 0
Joined: 12/23/2000
From:
Status: offline
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

(in reply to Slayer73)
 
 
Post #: 4
 
 Re: Formatting data BEING TAKEN FROM AN aCCESS DB - 7/12/2001 1:58:38 PM   
  Slayer73

 

Posts: 17
Score: 0
Joined: 6/27/2001
From: USA
Status: offline
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

(in reply to Slayer73)
 
 
Post #: 5
 
 Re: Formatting data BEING TAKEN FROM AN aCCESS DB - 7/13/2001 10:03:40 AM   
  imav8n

 

Posts: 95
Score: 0
Joined: 7/3/2001
From: USA
Status: offline
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

(in reply to Slayer73)
 
 
Post #: 6
 
 Re: Formatting data BEING TAKEN FROM AN aCCESS DB - 7/13/2001 11:10:16 AM   
  Slayer73

 

Posts: 17
Score: 0
Joined: 6/27/2001
From: USA
Status: offline
~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

(in reply to Slayer73)
 
 
Post #: 7
 
 Re: Formatting data BEING TAKEN FROM AN aCCESS DB - 7/13/2001 11:27:07 AM   
  adminkoe

 

Posts: 117
Score: 0
Joined: 12/23/2000
From:
Status: offline
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

(in reply to Slayer73)
 
 
Post #: 8
 
 Re: Formatting data BEING TAKEN FROM AN aCCESS DB - 7/14/2001 7:41:59 AM   
  nagesh840

 

Posts: 1
Score: 0
Joined: 7/14/2001
From: India
Status: offline
abcdefghijklmnopqrstuvwxyz
1234567890

nagesh

(in reply to Slayer73)
 
 
Post #: 9
 
 
 
  

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> ASP >> Formatting data BEING TAKEN FROM AN aCCESS DB Page: [1]
Jump to:





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
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts