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.
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 use <textarea> input more than one paragraph to the database, whose field
type is set to "text". Then I retrieve it to display in <textarea>, which is
OK, paragraph by paragraph, but not in the other tabs because of no <P> or
<br> between each paragraph.
Is there any solution to display in other tabs
than <textarea> paragraph by paragraph. Or do I have to change the database
field type other than text? And which type is good in this case. Thanks for
any idea.
I've created my database on MS Access and linke it to the web using ASP. I can display data from db. The problem I have now is when I display a data from db on ASP page I get the text as one block with no spaces or paragraphs format. Can anybody give me a hand of how to display my text as I entered. I stored text on field with memo type.
View Replies View RelatedI am using RTF files to store a template which has certain tags which should be replaced with content with ASP.I can use the VBScript function replace to do this substitution but is it possible to merge the pages in one file with those in another from ASP?Is there also an easy way to print out the result?
I need a user to follow a format. For example entering a date. I need the user to enter a date in this format MM/DD/YY. How do I check to see if they followed that format?
I need the user to enter a currency amount without the "$" sign. How do I check to see if the Request.Form("price") value has a "$" sign in it? I guess I need to know how to parse a string in ASP.
I have a text file containing korean fonts, i saved it as a unicode format in notepad.
i tried to load it in asp using #include file, i get an "UNICODE ASP files are not supported" ....
Is anyone having problems with formatting text using the ASPPDF component? I am having problems when it fills in the pdf form from data entered through a form. For some reason it doesn't allow me to format the text or resize it...
View Replies View RelatedI have a function at the moment which will take the contents of a <textarea> form field, and replace carriage returns with an HTML <br /> tag,
Assume the textarea, named "this" contains:
Therefore, all projects can be broken down into 8 standard processes (according to the Prince2 methodology): Code:
i have several fields in the database that the format is number. then, i have a report page that allow user to open it the ms excel. my problem is, when all data transfered to ms excel, all data that is in number format, they are located at the right of the cells and there is 1 data named noIC, suppose this data is a 12 digits number but in the ms excel, it became something like this 780945+E12....
to solve this problem, i have to change the cell's format everytime all data have been transferred to ms excel. i have to set to left indent for all fields that contain numbers and for the noIC i have to set from General to Number.
Is this possible to check if a text box on form.htm is in mm/dd/yyyy format before submitting to asp page?
if you enter say 2/2/04 it gives a incorrect date format error. The asp page uses this text box in the select statement for a db2 table query that is a date field.
One is that is there anyway I could use cookies or anyother method so that when my visitor visits my site,it will display "Hello ComputerA" where ComputerA is the name of the computer the visitor is using.
I have frontpage2000 and access 97, i tried to create a webdatabase wizard using fp2000, then i go to the folder where the database was created by fp and tried to open the database(.mdb) file in access97 and it prompted "Unrecognized database format c:foldernamefile.mdb".Could this be because i have fp200 and access97?
I set up a menu program for a client a few days ago using ASP and an Access database. I have a field in a form with a popup calendar. The form field is such that a date will be entered as 09/05/2005 (short date).
I specifed as much in the Access database when setting it up. Ok, so it was working great for a few days but then today I went to open the program on my father in laws computer (in Hungarian) and when I open the Access database, the date field is entered like this - 2005.05.09 I am clueless as to what is going on. Anyone shed some light?
I have an access db from which I would like to display records in a formatted manner. I can display all the records one after the other on one page no problem, but I would like to display maybe 6 records on one page (3 across, 2 down). I would then need a page break for printing purposes.
Displaying all the records on one page would be fine if I can put a page break in so that they print correctly. I currently have it fomatted correctly, but my loop is not working correctly. Instead of different records displaying, I have 6 of the same record displaying, then the next record displaying 6 times, etc.
Even if it's better to do this over multiple pages, that would be fine as long as I can print the report with all records by clicking Print only once. Maybe even display the records on multiple pages with next and previous buttons, but when the user clicks print, then it would print a report from access.
I hope this all makes sense. Does anyone have any ideas or suggestions or pointers on the best way to do this both for viewing and printing purposes? Code:
my database, sqlplus oracle, has a column ccexpiry, whch is set to date. In my form in asp, there will always be an error whenever i pass in a date that is not in the DD MMM YYYY which is the standard for oracle. My qn is how can i pass in a date that is in DD/MM/YYYY format? Code:
View Replies View RelatedI am using the code below to add a date input into an access database.
Quote: rs.Addnew
rs("Date")= Request.Form("Date")
Instead of inserting a date with the format dd/mm/yy, a date format of yy/mm/dd will be inserted into the database.
I entered the following code before the insertion Quote: response.write request.form("Date") and it displayed the correct date format as dd/mm/yy.
Pls how do I insert the date into the database for it to store the date as dd/mm/yy instead of as yy/mm/dd. The date format in the date field of the database is dd/mm/yy.
I have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar scripts but I need one that's creates a table resizable to a report size format. Using the existing MS Access db I've written is also a plus.
Any suggestions on where to start?
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
I 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?
I 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:
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.
I'm trying to write a page that will accept form POST method variables from another page and save them to an Access database via a DSN connection. I'm using code like this:
<%
SQL = "INSERT INTO myTable (postVar1,postVar2,postVar3)"
SQL = SQL & " VALUES ('" & request.form("postVar1") & "','" & request.form("postVar2") & "','" & request.form("postVar3") & "')"
dsnConn.execute(mySQL)
%>
I'd like to make sure that I clean up the text that the user inputs before trying to send it to the database. Can someone please give me an example of what ASP code I need use to get rid of quotes, slashes, and anything else a user could enter that might mess up the SQL insert?
I'm trying to put some text into the database using ADODB.Command object. Seems like a reasonable thing to do and I can do it. But in this instance my text is an HTML code which contains many quotes. But i have to save it as is into the database field.
I use:
INSERT INTO (f1, f2) VALUES (v1, v2) comand. But since my v2 contains some quotes in it, (many quotes), I get an error. (it works otherwise). Is there any way ?
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.
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 Replies View RelatedI have a database that was originally in Excel. After modifying it, I have saved it with .txt and another one with .csv format. DB.txt (Text (Tabl delimited)(*.txt)
DB.csv (Text Comma Separated Value) (*.csv). What is the command/statement in oppening database record for these formats?
I am trying to make a guestbook, wich should be accessable through a executable exe. I think, the easyest way to do this, is through your browser. I am looking how to add text to a database without entering text in a form, but only text in the address bar of your browser.
View Replies View RelatedI am looking for a script in which I can replace any word in one table
(which corresponds) to other table with a link....
To for example when the name Bill Clinton is in a large piece of text in
TABLE1 and Bill Clinton is a row in TABLE2 then I want Bill Clinton in the
text to display as a link leading to a page where there's more info on Bill
Clinton from TABLE2
I was thinking something allong the way of: Code:
how do i allow the user to add in a value that has a ' in it (e.g int'l) in the form. apperantly if i do that there will be an error... how do i go about this?
View Replies View Relatedif there any asp or vb functions that can convert any audio format files to vox format.
View Replies View RelatedI have two columns in my microsoft access database.
1st column is company_logo (jpg image)
2nd column is company_name (text)
I want to build a form, a dropdown box which I would populate with the help of a sql statement from my database. The both columns from up there are associated.
When the user clicks on that dropdown box, I need that company_logo and company_name to be shown one beside another. It should list all the companies availible (taken from that sql statement or recordset).
Does anyone knows if this could be done?
Maybe I should stick just with the textual part?
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: