Am not sure about entering data into MS SQL Server 7.
Now, if I were to enter lines of text, with line spacing between each sentence, when I pull the data back out from the d/b into my ASP page, would the line spacing turn out, or would all the text be clumped together? Code:
I have a prebuild freeware script that is installed and working fine. I am not a programmer by any means, but can usually hack through it and figure out how to make the changes needed. I just can't seem to get this one figured out.
The output is double line spacing and only a single column. Can someone help me to make the changes required to have it just one breakrow (no line spacing), and if possible, to have 2 or three columns? Code:
Im trying to extract data from a website, however after removing all of what i no longer need, it is somehow, littered with tab'd spaces, like the length of | | sometimes appears as a small box on notepad.
i've tried removing it using replace, but it doesn't like what im doing. Anyone have advice on how to remove said spacing?
I am working with an .asp page that creates an email using CDONTS. I need to be able to capture a text screenshot out of a mainframe session and send it in the email. When the email is sent, I am losing the spaces that align the screenshot. Ex.
THIS IS A PRIVATE COMPUTER NETWORK ---
UNAUTHORIZED USE WILL RESULT IN PROSECUTION
Returns> THIS IS A PRIVATE COMPUTER NETWORK --- UNAUTHORIZED USE WILL RESULT IN PROSECUTION .
I'm inserting data into my SQL server database via an ASP/HTML form. I have a textarea in the form where the user can enter content and I want to maintain any new paragraphs entered - however, when i insert the content into the database and reproduce it on another page, the spacing is lost and all the content is displayed in one paragraph. Is there a simple way to get round this issue?
The column on the database is set up as Type - Text (size 16).
I had created a macro to read data from an excel sheet and write the values to a text file. I had used "ActiveSheet.Range("GB" & k).Value" command to read the values from the excel.some cells in the excel sheet is having two lines value and four lines data, the text file is generating that value in a single line. (Ex. the cell value in address column is in four lines and should display in four lines in the text file generated from the macro)
Can i do something in the excel sheet or in vb script to read the address value line by line and write line by line in text file?
I have an encrypted .txt file created by asp. Its formatted with lines etc. Title followed by description underneath. I need to read this into ASP now, and parse it line by line. On each line read, run the function to unencrpt and add line to a new file.
Its the line by line Im having trouble with. If i do the full textstream no formatting takes place coz im adding the fulltextstream all in one addline call. How can I loop through lines ?
I've managed to code a function that will straightly replace some given character to another, for security of my pages. For example, I can convert (") to " and (') to ´ ..etc in the form(text field) that allow user to post some data to be stored in the db. But then I don't want the user to write it in HTML tag, and I want that when user press [Enter] on the keyboard, then I can redisplay the message in the way that the user really type in (new line). What I'm thinking is if I can replace the [ENTER] pressing to <br> to be stored in my db. But I didn't found the way I can do that. /n such as in c++ didn't solve. Anybody knows? I use ASP VBscripts/ Does my question clear?
I am trying to trap my ASP errors using the ASP error object. Everything works almost fine, but I can't retrieve the line number where the error occured. Here is a little piece of my code: ========================== If Err <> 0 Then Response.Status = "500 Internal Server Error" Response.Expires = 0
in my textbody, i have several fields to send as an e-mail, but they would not fit into one row, how could put on the other line in the text body e-mails my other fields, thanks
# Set myMail=CreateObject("CDO.Message") myMail.Subject="Sending email with CDO" myMail.From="mail@mail.com" myMail.To="mail@mail.org" myMail.TextBody = "comment " & request.form("comment") & "; " & "city " & request.form("city") myMail.Send set myMail=nothing /#
1. I have a form that insterts data in a database 2. I show this information in a pop-up page 3. When the user enter too much content it makes all the pop-up too widther and it breaks the design.
I want determinate a specific number of caracters and then do a line break.
Im developing a site for an organisation im a member of. Im trying to make updating the site a simple as possible for the organistions staff, some of which are not the computer literate. So i have made a kind of template site where the content of all the pages held in a access db. I have then made an admin backend where organisation staff can login and update the contents of pages simply by editing text in a text box and clicking the update button.
However, i've come across a problem. When users leave a line break in the text box the output page doesnt display the gap. I am using a simple response write to display the contents of the attribute on the page. Currently the only way im managing to get line breaks is to enter a '<br>' into the text box on the admin page.
How could i make it so when a line is left blank on the text box the database records this and displays it on the output page?
ive checked the text file for it to validate it for removal, if it returns true i need to remove the line and clear that line so new lines can be added in the future. how can i remove a spcified line from the file?
We've built a page that allows users to enter items that will ultimately become a list. One particular user enters them into the textarea on the page and for some reason always puts a hard return into the textarea before she submits. This goes into SQL as a line break and it's screwing up how the page renders.
How do I find this via code so that I can replace it? I've tried looking for chr(13) + chr(10) and vbCr and vbCrLf and replacing them with "" but it doesn't seem to work. Am I missing something?
I'm trying to save to a message field with the field type, memo. Say I save the message: "Test 1 Test 2 Test 3"
When I response.write it, it will turn out like " Test 1 Test 2 Test 3" losing all the line breaks and such If I response.write it within <textarea> </textarea> tags it comes back
It just inserts a new record into the db. What we did was add an autonumber field to the db, but now it won't update.
We know why - because it needs a value for every category in the db - but we don't know how to code it so it will update the db correctly. So, if anyone could help me with the (????) line in the coding so it will correctly update, that would be perfect!
Had developed a webpage to refresh automatically from one ASP page to another, with the feature of displaying local data that is actively poll & inserted from other remote database servers. The local server is using IIS & Microsoft SQL 2000. I have the problem of "Out of Memory at line 30" after the ASP page has ran for 13 hours, at client machines that is connecting to the server hosting the ASP. However by closing the Internet Explorer and re-open the ASP page, the problem is temporary resolved until another 13 hours later. I think i've had the server objects set to nothing, and had put all queries into sub. I couldn't think of other solution for the problem...
Is duplication of sub affecting the performance? Any setting to be done on server, e.g. IIS / SQL? I've attached the ASP file.
i have a text area for user to enter remarks. and their remarks can be very very long my output page is a table which i underline the lower boundry of the table.
when i wan to output the remarks on this line,it will over shoot the line and page.how do i make it such tat it will move onto the next line?
How do you write something in a new line?I looked it up on Google, and it seems to be the code vbcr. However, this only returns a white space. I need a NEW LINE. So far, nothing seems to do it.
I'm using the filesystemobject to read textfiles, and that works ok, but i have one problem. I want to read only a single line, fx line 2 in the file. Is it possible to do somting like stream.nextline ?
I created a form mail script. I am receiving an HTML email from the user input. However, If the user enters a line break in the comments field I am receiveing a single block of text in my email.
Is there a way to get the line breaks to show up in the email. I tried Wrap=physical in the input but its still the same.