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 RepliesI 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.
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 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?
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.
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.
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?
if there any asp or vb functions that can convert any audio format files to vox format.
View Replies View Relatedhow to format date in MM/DD/YYYY format in ASP?
View Replies View RelatedI have this problem in controlling a the text in a Text Area. How can I do
that for example the field size is 200, when it reaches 50 it automatically
goes to the next line. Bcoz im having problem when viewing it in my report,
it continuesly views in a strieght line and im having problem in printing.
When using ASP's FileSystemObject to create text files, I am unable to get user submitted text (in Hebrew) to save as anything other than "?????". The text file is being saved in Unicode and setting the CodePage in ASP proved unsuccessful. Strangely, hard coded Hebrew text in an ASP variable does add to the text file correctly.
Any ideas of why this happens and how to get it to work correctly?
I have a text area which I want to limit the number of words or number of text entered into it. Is this possible?
<textarea name="textarea" cols="35" rows="5"></textarea>
In the text area above, can I say limit the person filling in the text area to say 100 characters?
I have a form on asp page that pulls info from a DB when the page loads.
It them puts the info into text boxes on the page that are editable by the
user.
The only problem I have is say in the description text box it should
read "HP Laserjet 5Si" , it always cuts the text off where it just says "HP"
.. It does this on all the text boxes? I can't seem to figure out why it
is doing it. Here is the sample code:
With quotes around <%= vdesc%>
<td><input name="desc" type="text" id="desc" size="45" value="<%=
vdesc%>"></td>
And I tried it without.
I have text in a field coming from a database. The text has various
forms such as:
text1
text1 or text2
text1 or text2 or text3
text1; or text2
text1; or text2; or text3
etc...
how can I parse this with a reg ex? I tried this:
(.+);? or
but it only captures 1 submatch (text1) and only if theres an "or"
after it
I'd like to get 1 submatch for each piece of text separated by the
"or", just the text itself if there is no or.
Anyone know how to do it?
I have this problem in controlling a text in a Text Area. How can I do that, for example the field size is 200, when it reaches 50 it automatically goes to the next line. Because im having problem when viewing text in my report, it continuesly views in a straight line. Can you give me ASP code for that.
View Replies View RelatedI have text - ARI Promise, when I hover over the text I would like a box to appear with the Promise information. It would be several paragraphs that need to be formatted with paragraph and bullets. Is this possible to do? If so how would I go about it?
View Replies View RelatedI was wondering what would be the best function to format a name.
Say I have a function FormatName that takes in a string that is FRED SMITH and needs to return Fred Smith. The function basically needs to make sure the first character of each word is capitalized. What is the best way to do this?
how do you format an email in asp. For example: i want my email to read, The following customer has requested two tables then on the next line, it should provide customer's name then next line address and on and on.
Quote: Originally Posted by nschafer Or if you want a button instead of a link:
<input type="button" value="Close" onclick="opener.location='yourhomepage.htm';window.close(); ">
This will redirect the page that opens the popup as well as closing the popup.
I must have the format of the below line wrong for IE:
click <a href="cal.asp?sdate=<% =strDate1 %>&location=<% =strLocation
%>&eTime=<% =strDate2 %>">here</a> to add this information to your
Calendar<br>
When I hover my mouse over the link, the status bar at the bottom of the
page for IE says: shortcut to 2006 11:00 AM
With Firefox I get: http://sd-school/forms/cal.asp?sdate=10/18/2006 10:00
AM&location=Library&eTime=10/18/2006 11:00 AM
The form works in Firefox, which is what I use for testing. So either the
format is wrong, or IE doesn't like the spaces or something. It doesn't
matter which dates I use, I get the same results.
At the moment I'm entering a new record in my database for every pageview (the record holds several things like IP, useragent..etc). I think this is asking too much of my database, and I get a lot of errors all the time.
Perhaps I should switch to entering each 'record' into a XML-file, and use that for my statistics? Any disadvantages, performance issues?
I have a search page, after search returns value I want to display fields in text box instead of table.
View Replies View Relatedi am encountering some problems in converting some data into CSV format..i have alreadi retrieve the data however i do not knoe of ani methods of converting to CSV...is there ani method to save the directory to .csv
View Replies View RelatedCan someone help me with this request?
1. Data in my access database have the format "9/10 2005"
2. When I show all dates within an asp page I get the following format
"9/10/2005"
The format I want to show in my asp page is the following format "9/10-05"
My database (access) has a date field.
When I display the date through a recordset, it comes back in US format (mm,dd,yyyy)
How do you make it appear in UK format (dd,mm,yyyy)?
I have a problem don't know how to write the attachment file frm mail....
<html>
<head>
<title>Thank you for reply with us.</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<%@ Language=VBScript %>
<%
Dim strBody
Dim myElement
For Each myElement in Request.Form
Select Case Left(myElement ,3)
Case "txt","sel","rad":
strBody = strBody & Replace(Mid(myElement,4,len(myElement)),"."," ") & _
": "
if Len(Request.Form(myElement)) = 0 then
strBody = strBody & "UNANSWERED"
else
strBody = strBody & Request.Form(myElement)
end if
strBody = strBody & vbCrLf
Case "chk":
strBody = strBody & Replace(Mid(myElement,4,len(myElement)),"."," ") & _
": " & Request.Form(myElement) & vbCrLf
Case "are":
strBody = strBody & Replace(Mid(myElement,4,len(myElement)),"."," ") & _
": " & Request.Form(myElement) & vbCrLf
End Select
Next
strBody = strBody & vbCrLf & strFooter
'Time to send the email
'Dim smtp
Set smtp = server.CreateObject("CDONTS.NewMail")
'******************************************
' set the mail properties
'******************************************
smtp.Subject = "ApplicationForm"
smtp.From = "ApplicationForm"
smtp.To = "connie@auroraxsis.com"
smtp.Body = strBody
'******************************************
' fire off the email message
'******************************************
smtp.Send
'Response.Redirect "thankyou.asp"
'******************************************
' check return value error code
'******************************************
'if objMail.errorCode = mmeNone then
' Response.Redirect "thankyou.htm"
'else
' Response.Write ("Mail message was not delevered to the SMTP server." & "<br><br>")
' Response.Write ("Please try again later" & "<br><br>" )
' Response.Write ("The error code was :" & Cstr(objMail.ErrorCode) & "<br><br>" )
' Response.Redirect ""
'end if
'******************************************
' always destroy the object
'******************************************
' set smtp = Nothing
' Response.Write ("Thank you for advertising with us. We will revert to you soonest possible.")
' Response.Redirect strRedirectURL
%>
</HTML>
<script language="JavaScript">
<!--
//set message:
msg = "Welcome To International Education Counsultancy";
timeID = 10;
stcnt = 16;
wmsg = new Array(33);
wmsg[0]=msg;
blnk = " ";
for (i=1; i<32; i++)
{
b = blnk.substring(0,i);
wmsg[i]="";
for (j=0; j<msg.length; j++) wmsg[i]=wmsg[i]+msg.charAt(j)+b;
}
function wiper()
{
if (stcnt > -1) str = wmsg[stcnt]; else str = wmsg[0];
if (stcnt-- < -40) stcnt=31;
status = str;
clearTimeout(timeID);
timeID = setTimeout("wiper()",100);
}
wiper()
// -->
//-->
</script>
<style>
BODY { margin-top: 0.00in; margin-left: 0.0in;}
BODY{
scrollbar-face-color:#f5f5f5;
scrollbar-arrow-color:#000000;
scrollbar-track-color:#ffffff;
scrollbar-darkshadow-Color:'#FFFFFF';
</style>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="75%" cellpadding="0" cellspacing="0" height="40%" align="center">
<tr>
<td valign="middle" width="25%" height="288">
<div align="center"><img src="http://www.iec.com.my/images/tk.jpg" width="576" height="198"></div>
</td>
</tr>
</table>
</body>
</html>
I use an ASP mail object to send orders filled online to a recipient via an e-mail. I would like to know if it's possible to format the way the order looks in an e-mail? I tried the following, but see no change in the format:
H1 = "<b><font size=2 color=#ED171F face=Verdana, Arial, Helvetica,
sans-serif>Order Type:</font></b>"
StrBody = H1 + Request(OrderNum) + vbCrLf
Then I get Order Type: just as plain as it would come if it didn't have any formatting.
If I do the following:
StrBody = "<b>Order Type:</b> + Request(OrderNum) + vbCrLf
Then I get <b>OrderType:</b> as the heading.
Does anyone know if it's possible to format the way the text look in an e-mail that is sent using the ASP Mail Object? Is there a different way of controlling the format/appearance of the text that appears in an e-mail?
I've looked over the last 2000 posts for info on incorportating an RSS feed on a web page using ASP to control the display - especially which elements are shown and how many items are shown. I found a free ASP script that I hoped would do the job >>>
View Replies View Related<%Response.ContentType = "application/vnd.ms-excel"%>
which save my asp query to excel, but the TYPE of excel it saves as is WEB PAGE. is there a way to save as a excel workbook?