how to display data that I have in an Access Database to be formatted in paragraph style when I have it written to my asp page - but does anyone know how I can format text to display as bolded or to show http:// as a hyperlink?
View RepliesI have a text area within a form that collects user data and enters this
into access db. Later this text is pulled out and put onto a page.
What I want to achieve is some formatting options for the user but I only
want CR and strong and no other formatting options available.
I made a website using ASP and MS Access in the back-end. One of the functions of the website is to post some news by using a web based form. Copy, paste, submit and voila! It works fine, However, Since it is mainly text that is pasted on the form, I would like to be able to keep the original formatting of the text and not to have it displayed, as is now, all together without spaces. Can anyone tell me how to achieve that wonderfull thing. Is it an Access problem or an ASP thing?
View Replies View RelatedI have a text field i am pulling from a database that uses vbcrlf to create line breaks.
I used the following code to replace them:
response.write Replace(rs_classes.Fields.Item("DESCRIPTION").Value, VbCrLf, "<br />")
But ran into the problem that when the field is blank, I get an error that shows a problem w/ the "replace" function.
So I tried the follwoing: Code:
As i write this post i have a variety of options to format my post such as bold, changing font, font colour, font size, putting text into paragraphs etc.
I am able to then preview all of this by clicking on "Preview Post". When i click on "Submit New Thread", my post gets stored inside a database (fully intact with paragraphs.)
I would very much appreciate anyone that can point me to script (prefferably ASP and javascript) to be able to do all of this including storing all the text fully intact (paragraphs) inside an access 2000 database.
I am pulling legislation information and expiry dates from an access database and posting to the web. The expiry dates in access are formatted as Month Day, Year (EG.. January 1, 2006) But when they are pulled from the database to the web, they come out as 01/01/06. I know that the format we have in access is simply a mask, however we require that format be carried through.
This is likely a simple solution, however I am new to ASP and can't seem to locate any information on this. I have searched the forum for related info on this but can't find anything that relates to my specific situation.
Here's the code we are using so far...
Code:
<%
Do While NOT Recordset.Eof 'i.e. carry on looping through while there are records
Response.write "<tr><td>"'open row and first cell
Response.write Recordset("Legislation")
Response.write "</td>"'close first cell
Response.write "<td>"'open second cell
Response.write Recordset("Repealed")
Response.write " "
Response.write Recordset("Expiry_Date")
Response.write "</td></tr>" 'close row
Recordset.MoveNext 'move on to the next record
Loop
%>
I have also found and implemented the following code:
Code:
dt=recordset("Expiry_date")
dt=Month(dt)&"/"&day(dt)&"/"&year(dt)
response.write(dt)
This lets me change the positions of the numbers, but I can't figure out how to make it display the full month name and full year.
I'm using Access Database with ASP. There is one particular thing that I
have issue with.
My purpose is for user to update their own profile. Their existing profile
information will be display in Edit Form format. The problem is if the field
has space, the second word will not display, when I display in input text
format.
E.g if My first name "User_FirstName" in my table has entry, let say "David
Johnson" as FirstName, when I execute following code and do a input text, it
will display "David" only. Code:
I've got a simple template based ASP page which pulls information in one of several different languages from an Access database.
The copy I have in the database is fine. All languages - including the Japanese are displaying correctly when I look at them in Access. However, when I pull the Japanese text from the database, each character renders in the browser as '???????'.
I've tried different HTML encoding, but nothing seems to make a difference.
I have an ASP site pulling from a SQL Server. When I pull a text field from the database into a text area, it keeps the formatting. If I pull the data from the database on a response.write, all of the formatting is lost. how can I prevent this from occuring?
View Replies View RelatedI have been having problems with an ASP page that extracts a newsletter from an Access DB. The record in the database has the proper format, meaning that after a paragraph, you can see that the enter key was pressed twice.
Problem is that when the newsletter is shown on the internet, all of the paragraphs have been run together. I don't know why this is happening.
I am currently using a combination of classic ASP and Access for coming up with a ride reports system for my cycling club - I have a control panel on the website which allows admin members to update the database via forms boxes (especially multi-line boxes)
However, the only problem I am having is that when in the control panel when I include text (with line spaces), and submit this to my Access database (in a Memo field), the output doesn't include any paragraphing or line spaces and it comes out in one unwieldy block of text. way that I can include paragraph formatting within this method?
I am new here and need some help in formating text stream coming out of MySQL database. Following is the row I have in MySql database.....
"one - two
Three four
five"
My asp code reads this string as...
"one - tow Three four five"
For some reason I am losing all the carriage returns and line feed. Asp puts the whole string in one line. Is there any asp function that I can use to keep my original text formating that I have in the database? Code:
Can anyone help me format text in a text area using ASP? I am bringing in data from a database and need to format headers for the data. Is there anyway to format this in a text area using ASP?
View Replies View RelatedI have an from that emails @ the mo But I have to insert e variables into the <boby>.
useing asp this works fine but the formatting is all over the shop I have looked on the net and can't seem to find anything that formats a textarea any ideas????
The following takes from the database a list of date and displays them in a table on an asp page
...........
<td align = center><font color = "black" size = 2><b><%=trim(rs.Fields (2))%></b></font></td>
..............................
however it displayes it in this format: May 12 2003 12:00AM
Is there a simple way of getting it in the mm/dd/yyyy format without reading it in as a string first? I mean can I just change something in the above code to do this?
I was trying the following but couldnt get it working, could you tell me how to use it in this context? Code:
I have a query that i have been having trouble with for some weeks and i am desperate to get working.
What i want to do is construct a statement from the values i pull from the database.
for example, i have 2 rows in the database, one field, called dbValue that has the values "Value 1" and "Value 2"
I want to pull the values from the database and construct an if statement like the following
if testing = Value 1 OR Value 2 then
else
end if
Could someone please help me out, the values have to be pulled from the database as they will be dynamic.
I have a text file from which i want to import data to access, does anybody know how i can go about this or where i can get information about this subject?
View Replies View RelatedI want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.
<code>Dim MM_connPang_STRING
'MM_connPang_STRING = "dsn=pangDSN"
MM_connPang_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:clientdatabasepangDB.mdb"</code>
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...
If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
I got a form (textarea); user can input details of the property. And I am saving it in database. I need to display it in the site. text should be formatted. For example
Thi is how user enter details in texarea Code:
I've created a db field with Memo type, and I have stored some text with
carriage returns (no html) So the 3 words start on a differnt line. In
access this displays correctly ( each word starts on a new line).
However when I display these on a web page all the words appear on the same
line.
I need the words to be displayed on a seperate line.
i have 2 text box whom data are generated randomly, how can i get this data and pass it to a access database using ASP?
View Replies View RelatedI copy my emails from microsoft inbox and save it into a textfile and try to read the information and save it into access table. But during i read the textfile i am stuck.
Dim fso, fil, ts, sContents
Set fso = Server.CreateObject("Scripting.FileSystemObject")
Set fil = fso.getfile(server.mappath("myemails.txt"))
Set ts = fil.openastextstream(1)
sContents = ts.readall
aBuild = Split(sContents, "From:", 2)
sFrom = Split(aBuild(1), vbCrLf, 2)(0)
response.write(sForm)
ts.close
Set ts = nothing
Set fil = nothing
Set fso = nothing
I have a MS Access DB that is used for a small web-based app. And I have an updated text file exported from the db on our local system.
I have got this import text file to access db asp script But it brings up a HTTP 500 Internal server error. site is running on Windows 2003 Server
Code:
I'm using asp to retrieve data from a server and import that data in a client that uses MSAccess, into a memo field. The text hes line breaks 0D 0A (the usual DOS line breaks). However the client sees these line breaks as two squares!
The strange thing is that when I look at the exported text (yes, I also export text from the client to the server), it also contains the same line breaks. So the exported text from the memo field can look exactly the same as the imported text, and before the export the line breaks are correctly shown als line breaks, but after the import that same line breaks are shown as squares! I would like to see line breaks after the import and NO squares.
I am to develop a multi-lingual website / content management system. I will use ASP (IIS on swedish or english windows 2000), Access, and for the content editing i will use the built-in editor in IE (in an IFRAME). Primary languages/charsets, apart from the western languages (swedish, english etc) will be russian and arabic.
Does anyone know how (if) this works? What should my main concerns be, will it work and what will the likely problems be?
I've tried to insert arabic text in regular text-fields in existing applications, but when they reach the database the text has been alterd. Though I can paste the same text directly into the database. Why?
I want o create a small site and I dont see the need for a database. So I want to use a text file for this site but I don't know how!
I know I can use Mysql or Access, but I don't want to. I simply want to use a flat file as it is called.
My site is an ASP site, so can anyone guide me on how to use "flat files" for databases
how can i format text so it can be read by a database? for example, for numbers i do cint(whatever). whats the equivalent for text?
View Replies View RelatedI have 2 textboxes. In first text box i need to enter name, the second text box shud be automatically filled with the person'd id.
Both the name and id is coming from database. I tried using this code, but i'm getting error saying System.NullReferenceException: Object reference not set to an instance of an object. at line 1 Code:
i am building a search form by word from text field in a table. for example the table has
1. ID
2. Price
3. Note
the Note field of a record could have sentence that contains words or jargon. What sort of method or approach can i use to solve the problem? can we use sql statement? if yes what sort of?
Is it possible to store html tags in a database field so that when data is retrieved from this field the formating is retained? For example I have an address field in my database, which I return using:
<p><%=(rsType.Fields.Item("DAT_Address").Value)%>
However they are times where I may want to have my city, state etc on seperate lines by using <br>, but right now if I store a <br> in my database it does not affect the formating of my displayed address.
Question about the performance of using an include file or reading from a text file compared to hitting the database.
I set up a client's web site so they can post a weekly message and also post a "of special interest" message on their home page. Originally these messages were stored in and retrieved from an Access 2000 database. I decided to try writing the messages to a text file then retrieving it through include file and also tried the text streaming object.
I used netmechanic.com to gauge the download times for all three methods on a 56K modem. According to the results, using the database was around 4 seconds quicker. Does this sound right? The site is on a shared hosting package using Win2000.