I am attempting to pull data out of a sql database and then parse it so that i only send the data after the last carriage return to the actual page.example
blah bla 1 ( carriage return )
blah bla 2 ( carriage return )
blah bla 3 ( carriage return )
blah bla 4 ( carriage return )
blah bla 5 ( carriage return )
blah blah blah 6
my code should return blah blah 6
I am using an HTML form and creating a tabbed text file with the .xls extention.
only problem remaining is when multi-line text area is used the user might press 'return' to create new line in the text area but this also creates a new row in Excel.
what's the best way to replace the 'return' in the form data with the little rectangle that Excel uses to create a carriage return inside a cell?
I've found the MS XML parser as shown in below code. I'm just attempting to display the various ListNames in the ListStruc section of an incoming XML file (generated by the SelectLists API call). On the line with the astrik though, I'm getting the error "Object required: '[object]'. Is this because I don't have this parser installed? (I'm running XP Pro w/IE 6.0.)
Also, I'm not sure about the line xmlDoc.load(request), shouldn't it be xmlDoc.load(xml.responseText)? Code:
I have a select statement that gives me the following results (for example) "test documentation/software product version document.doc" I need to parse the data to only grab everything between the "/" and ".". So, in other words, "software product version document" - I have absolutley no idea how to do this .
View Replies View RelatedI have a select statement that gives me the following results (for
example) "test documentation/software product version document.doc" I
need to parse the data to only grab everything between the "/" and
".". So, in other words, "software product version document" - I have
absolutley no idea how to do this - can anyone help?
My problem is this: This database has a field called "b_name" which contains the first, middle (if any) and last names of registered users. The table also has corrosponding other demographics pertaining to each registered user.
I've used the code below to parse the full names in "b_name" in the original table and put the names in another new table which has 3 fields, "FirstName" "MiddleName" & "LastName".
My problem is the fact that the way the names are stored in the original table and the parsed names in the new table do not correspond. Code:
I have an url where I have xml data POSTED and I need to parse the URL to read the data - Meanwhile here is my xml data Code:
View Replies View RelatedI'm looking to grab data from an XML stream...and parse the information so that I can just take what is between the tags and add the information into a DB. Code:
View Replies View Relatedam trying to make a carriage return of the following:
Mailer.BodyText = "From: " & Request.Form("FRM") & VbCrLf & VbCrLf & "Message: " & Request.Form("MSG")
but it doesnt work.
when i received the email on my mailbox, the format is all in one line, like this:
From: John Message: Test message only
but i would like the "Message:" to appear in the second line.
This code doesn't give me a carriage return.Why?
strEmailMess= "Name: " & strName &vbCrLf
strEmailMess= strEmailMess & "Email Address: " & strEmailUser &vbCrLf
Also this code takes user to aspemail.asp page.I want it to go to a page of my chosing, like www.newpage.com
If MyMail.Send Then
Response.Write("Message Sent With ASPEMail.<br />")
Else
Response.Write("Message Not Sent With ASPEMail.<br />")
End If
how I can keep the formatting (carriage returns) that the user enters into a memo field and then display that later. I figured I might be able to use:
'replace carriage returns with BRs
comment=Replace(comment, chr(13), "<br>")
but obviously net.!
The <pre> tag doesn't sem to help either as the embedded return is lost by the time you get past Request.Form
I am using asp to retrieve data from an SQL Server database and display it on a web page. The data in the database has been formatted using multiple carriage returns however, when the data is displayed on the page these carriage returns are lost.
View Replies View Relatedhow can i get this to work? trying to get carridge returns display in the output:
strBody = strBody & "<td width=550><font class='data3'>" & Request.Form("subject"),VBCrLf, "<br />"
I have a form with a <textarea></textarea> to receive user input. This input is then stored in a database and sent by fax... I need to be able to remove the carriage returns (enter key... vbcrlf...) from the input so that somebody doesn't do something like fill the textarea with 100s of keypresses of the enter key and end up spitting out tonnes of
blank pages on the fax machine.
I am using asp to retrieve data from an SQL Server database and display it on a web page. The data in the database has been formatted using multiple carriage returns however, when the data is displayed on the page these carriage returns are lost. Does anyone know a way around this problem?
View Replies View RelatedI have a text box that a user is allowed to enter what ever text they wish. I then take the text store it in a Database, and at a later time print it in a document. All that part I have done.
The problem I'm having is I have a client that hits return at the end of their last sentance. When this prints on the document, it sometimes causes an extra blank page to be produced to account for the last carriage return, depending on how much text they have entered.
What I'm looking to do is take out any whitespace or un-needed carriage returns at the end of the string.
I want to send an Email using ASP (I know how to to this) The body of the Email contains several variabels How do I concat string values and separate them by carriage returns/ Line
feeds?
If I want to remove x-amount of trailing carriage returns from a string in ASP (ie, someone has entered text into a text area and left a few carriage returns) - what's the easiest way to do this?
Trim() only removes white space
Also, I don't want to remove carriage returns within the main body of submitted text.
Any ideas if there's an easy way to do this?
I have some aspUpload code running that validates and uploads files beautifully to my web server. It uploads upto 3 files at a time and produces a message for each whether it be successful or not. The problem I have is that the 3 messages come out in one long line. I'd like to put each on a new line. Below is my code.....
View Replies View RelatedI have a textarea that is being sent to email using an asp code to process the form.
strBody = strBody & "<br><br><b>Resume: </b><br>" & Request.Form("resume")
I want to keep the carriage returns for the textarea. How can I do that using the Request.Form?
I have a form which contains a textarea input, when I request the value of this and display the contents in HTML the carriage returns are gone, so I am trying to find a way to re-insert any carrigage returns.
I have tried using a regular expression with the replace() method to search for a carriage return in a javascript string and replace it with a <br> - but no joy
I thought the following would work (code is in Javascript by the way): Code:
how do I parse a textbox of text separated by carriage returns?
I have a web form with a textbox, when the user presses submit I would like to process the text in the textbox line by line. How can I iterate through it line by line and do something on each line of text?
I have a field in a SQL Server table named DetailedDescription that is
a varchar. If the user adds/edits a detailed description, they do so
in a MulltiLine TextBox control. Therefore, they are able to click
enter on their keyboard and have multiple carriage returns inside the
DetaildDescription. Code:
I am using the asp sendmail script from brainjar. But I'm using a text area instead of input field for comments. Is there a function that I should run this thru in order to get it to recoginize carriage returns. Currently it won't send anything after the first carriage return.
View Replies View RelatedI am performing a post from one classic ASP page to another in order to get the value of a string passed between the two pages. I have a client script variable declared to take the value of the value being received in the page i.e. var x = '<%=varName%>'. Unfortunately, ASP seems to be adding a carriage return to the value of varName when it
is passed in i.e. it expands the stated line to var x = 'FieldContents';. I.e. somewhere a carriage return has been added. The string gets passed in OK if I use the Get mechanism. Don't know why this carriage return is being added when using Post mechanism. Anybody seen this before? Is it a bug in ASP ?
Am facing a problem when trying to display a carriage return in firefox in a title attribute,i ve tried using VbCr and chr(13) ,in either cases a strange character appears instead of the carriage return. does anyone know about this error. The code looks like this:
titles(iday) = titles(iday) & chr(13) & objRS("event_title")
<a href="javascript:showevent('0<%=links(i)%>')" title=" <%=titles(i)%>"><%=i%></a>
Am not having this strange character when running it on explorer.
how to replace carriage return upon extracting text from Access file.
However I think it will be smarter to do it before (during) inserting text into acess file.
It might be primitive question, but I started my ASP learning just last week and many things are confusing me on this stage.
QUESTION:
What should I change in my ASP file code (file inserted data from the HTML form file into database file) to replace all carriage returns and line brakes during inserting text into field GuestSory? Code:
Is there a way to detect if the user has placed two returns in a form field for example as below:- This is a short paragraph This is the second paragraph
And automatically add the surrounding <p></p> tags on inserting this into the database. Same with the edit of pages. Rather than showing the <p></p> in the form is there a way to just apply the paragraphs for the user to visually see thus preventing code in the form window?
i want to ask is there any way that i could get the value from field (the value will be used in SQL statement) without submit the form coz if i use Request.form("name"), it need to submit the form to get the value
View Replies View RelatedI'm interested in creating an asp function that enables the general parsing of xml. The function needs to take into account the structure of the xml document, as the document(s) can be quite complex.
The use of getElementsByTagName() is not appropriate in this case as I'm trying to avoid picking up the wrong data. The function also needs to be able to test if a node has any attributes and what the attributes are. Here's an example of the document I'm trying to parse: Code:
ASP
I have
value(0) = 1
value(1) = 2
value(2) = 3
value(3) = 4
etc...
I need to have as output
1,2,3,4 ...
Finnaly I must submit that to 2nd asp page, and use it inside the javascript. Any ideas?
I do a regular HTML form POST to a third party server. The server processes the request and displays result in XML format. However, I need to parse this xml and display in HTML. The problem is how can I get the control from the form POST.right now, the form posts and the result is displayed but I need the control back.
View Replies View RelatedI need to use forum code for my site, and making things bold, etc, is very easy however, I cannot work out how to use the tags [*url]http://site.com[/*url], the asterix will avoid it being parsed to create links.
I want to be able to get the text between the two URL tags, and build a link, so <a href=""" & textinbetween & """>" & textinbetween & "</a>".