Dfisplaying Long String Without Massing Up Formatting
i am stuck while trying to display a long string, its not just one string though, itsa field from a database that has a problem solution in it, most data is just how to stuff like:
"do this, install this and then restart and install the new stuff... etc."
but some of the solutions have long links to (for example) servers and there is then maybe 150 characters all in a line and no breaks to make the line break - this makes my table (390 pixels wide) get streched to hell on one side.
i have tried going through the code, counting the characters and then taking a "left" of code depending on how many groups of 50 there are but that breaks words in half and thats looks nearly as bad.
I have a very long string statement that needs spltting down into smaller sections and segments. I know how to use the split() function, and it splits the string down into smaller sections, however when I try and split one of these smaller sections into segments it throws an error out. Firstly is it possible to keep splitting the same string again and again to break it down? If not does anybody know how I would go about breaking down the string?
I am displaying a modal dialog in JScript using window.showModalDialog passing a long string as URL - i.e. it contains variables values just like a Get request. Problem is that string is now tool long and showModalDialog fails. I'm aware of the DialogArguments and passing an object to receiver but this is no good for me as the receiver needs to access the long string in server side code and so would not know anything about the dialogArguments class. Can anyone suggest a way for me to show the dialog as modal and at same time get the long string into the dialog and have the string accessable from both server side code and client side within the dialog recever file ?
I have the following test.asp page which needs one parameter querystr but my querystr is a very long string value. When I send a long value the query string is getting truncated after some characters.
Can you please kindly share the code segment to workaround how to pass such a long string value to a asp page. This is how I invoke the test page:
http://localhost/?querystr=select ............ from xxxxx
but part of my query string never gets passed to the asp page appears asp as a limitation on max string length can you please provide me a workaround how I can overcome and pass the right string to asp.
I'm passing a query string from one script to the other via a hidden input. Right now I'm just response.writing the query string out to make sure the query is getting there.
The query string will display no problem if the query has no single quotes ( ' ) i.e. returns: SELECT * from table WHERE int_field = 123 ORDER BY id
But when the query contains quotation marks to handle text it chokes, i.e. returns: SELECT * from table WHERE text_field =
when this should be:
SELECT * from table WHERE text_field = 'textvalue' ORDER BY id
I've tried various arguments with the REPLACE function, but can't get it to work...
In line 7, I need to display the results of the variables strFName and strLName (and have a space in between the two) but I don't know the proper formatting. If I just use the & then I get the literal strFname instead of the value. Could someone please show me the correct syntax for this?
I have a string of HTML (used for a specific purpose) that I'd like to use somewhere else but as plain text. Rather than introduce a specifically created plain text version I'd like to strip the tags code from the HTML version. This in itself is easy, using a function such as:
Function HTMLDecode(Expression) Dim sTemp sTemp = Expression sTemp = Replace(sTemp, ">", ">", , , 1) sTemp = Replace(sTemp, "<", "<", , , 1) 'Repeat for each defined entity HTMLDecode = sTemp End Function
However, the difficulty comes when trying keep each paragraph seperate. For example, the string "this is<p>my name" shows on screen as:
this is
my name
if I use the above function, it strips out the <p> tag and shows the result on one line:
this is my name
I thought I could use something like:
str = replace(str, "<p>", chr(10))
but that doesn't seem to work. Can anyone help me replace <br> and <p> tags with something that's recognised as "plain" text but will keep the paragraphs and new lines formatted correctly??
When sending long emails a mysterious space-character is added after a certain number of characters. Any idea why that happens? I am using a Dundas Mailer control (if that matters) called from an asp script.
I have a database-driven site and it is possible for users to leave comments, which get written to the database. How do I make it so large comments can be added?I am getting this error message:
Microsoft JET Database Engine error'80040e21'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/wall2.asp, line 37
I have set the default field type in the database to be 'memo'and set the default text field size to 255 (the maximum allowed)
Is anyone aware of any sort of asp coding to deal with long URLs? I have a few asp that pull URLs from fields within a MS db, which then display on a width-limited table. Is there any way to wrap these long URLs such that my table doesn't get widened? e.g. wrapping at "/" or something similar?
ok I have a page that displays all of the 3000+ records of people, phone numbers, and email addresses. on this page I have added a link that combines all of the e-mail addresses into one mailto: link so that we can mass notify these people of upcoming projects. the problem is that i think the link is too big for the browser to handle. the view source shows that everything is there but i cannot click the link. i have tried both IE and FireFox to no avail. The code is below just in case i have a typo or something...
sql = "Select * from people WHERE (IsNull(m_idstatus) OR m_idstatus <> 'id2') AND (m_email Like '%@%')" ...
y = 0 do while not rs.eof If (rs("m_email") = "" OR IsNull(rs("m_email"))) Then e_email = e_email Else e_email = e_email & rs("m_first_name") & " " & rs("m_last_name") & "(" & rs("m_email") & "); " y = y + 1 End If rs.movenext loop ...
I have also tried changing the format of the link by adding test@test.com before the ?bcc= but get the same results on both browsers. Like I said in the beginning I assume that the link is just too big for the browser; does anyone have any ideas besides making a mail form in the page? I would prefer to stick with a mailto link so that we can keep internal Outlook features.
I'm currently working on an ASP site that connects to a MySQL database I've built a form that allows users to insert press releases. They add the date and title and then the text of the release.
The problem that I'm having is that every so often when the user submits the form they get an error message saying "Command text too long" The record isn't added to the database after this
I use a longtext field for holding the main text of the press release Code:
I'm trying to use ServerXMLHTTP on an ASP (not ASP.NET) page to retrieve large binary data from a remote server. When the request is large (more than a few megabytes), the ServerXMLHTTP page jumps to nearly 100% CPU utilization for an unusually long time. The remote server needs a few seconds to prepare the request, during which time the CPU seems OK. It seems that as soon as the data is ready to retrieve, the CPU usage jumps and remains that way until the data has all been copied to the requesting server. That takes way too long - about 35 seconds when requesting a 12 MB file over a gigabit Ethernet.
I use ServerXMLHTTP hundreds of thousands of times daily on this same system on the same network, with absolutely no problem - but for smaller requests. There's something about the size of the request that makes it blow up.
I saw some reports of older systems with this problem (Windows 2000), but I'm running IIS 6 on Windows Server 2003, SP1.
I am trying to simply print to screen all the data in a colum from a .mdb file. Later I will do more advanced things but for now this would be good.
What I have WORKS, but takes a LONG time to retrieve the first record, if I tell it to retrieve more than one row it will time out. I was hoping to connect to the file directly and not have to create an ODBC connection. The code seems simple enough and the server is no dud (p4 2.4ghz) so do I need to setup a DSN and connect to it that way? Code:
I am trying to return a recordset of data. The problem is my SQL query does not fit on 1 row. What do I need to do to start a new row. I tested the asp when I trimmed my query down to 1 row and it worked.
I'm developing an intranet application using W2k server and IE5.5 - 6.x clients. I've got one particular function that calls a stored procedure to update a number of records, depending on user input. The problem we have run into is that this procedure can take a few minutes to complete in certain circumstances, and of course IIS times out.
I've been doing some searching for a solution, but most of the answers I've found relate to showing a 'Please wait' message while processing the page, which doesn't help in this situation. The others I've found relate to using MSMQ, which would probably help, but leads to a load of testing issues that I'm not prepared to deal with at the moment.
Are there any other 'common' ways to handle this at the ASP level?
I want to divide long HTML page (paging) into smaller pages.I know how to do it if I use recordset but in my project, I dont need to read from a Database, I'm reading a file system wich is a folder and list all files insid it.
I was performing some testing on my forms and in the comments section of the form, I copied and pasted a large amount of text. All of the text appeared on my confirmation page that I have that shows all of the submitted information. Once I hit submit on the confirm page so that the INSERT will occur, only about 1/4 of the text that was entered shows up on my "Submission Confirmation" page.
The text insert appears in the database, but only the 1/4 of the text that was entered. I'm using the "text" datatype and the length is set to 16. Can anyone think of why only a portion of my text is being displayed and then inserted into the table?
I'm trying to put a long hyperlink into my database table which works fine. I used longtext as the field type. My records insert just fine. But when I try to retrieve the records on the asp page all the other data shows up but the hyperlink data. Here's an example of my link.
I have an Oracle database which has a field LONG RAW type to store text files. I'm trying to display the output of this field in ASP but I'm having problems. I've gone through many different approaches but they either do nothing or do the following;
I've tried doing response.binarywrite(rs("data_object")) and I get somethinglike below ....
If the content of a db field is too long, (like when the web page ends up being 3 A4 page lengths due to alot of content in the db field), is there a way of say, creating a 'next page', thus splitting the data content over 2 pages?
I have a recordset that has 12 records in it, and about 25 columns. Unfortunately, I have to write the records out as columns in an ASP page, and the columns as rows. So, what I have done is a Do Until myRS.EOF and write all the records in <td></td> tags. I then do a myRS.MoveFirst before going to the next line.
I have one page that is identical in code, just using a different recordset, that is taking about 7 seconds to write per line. The other 2 pages are taking less than a second per line. Has anyone seen anything like this before? Anyone have any suggestions? Below is an example of a loop that is taking so long to run.