Long Posts
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)
View Replies
ADVERTISEMENT
I have noticed that there are nearly 100x the number of posts here in the PHP forum, as opposed to the ASP forum, and my curiosity was aroused by this vast difference.
Does this mean that PHP is more popular than ASP?
Or that PHP is harder to learn than ASP, thus more people turn to the forums?
Or has the PHP forum been around longer?
Or is there another reason?
View Replies
View Related
I have a simple address-script (its actually a guestbookscript that I changed a bit). Part of the code looks like this:
Code: ....
View Replies
View Related
I have a database I built with Access with a Users_Table holding User_ID, User_Name, etc. A Posts_Table, with Post_Content, Post_ID, Post_DateandTime, Thread_ID (pointing to whichever thread the post is in from the Threads_Table), User_ID (pointing to the user who made the post in the Users_Table). Also a Threads_Table, with Thread_ID, and Thread_Title, etc.
I want to pull the Posts content, Post DateandTime, User who posted it, and thread title from the database (the page simply knows the ThreadID and the idea is to select all posts with that ThreadID). Could anyone help me create the SQL I need for this. I understand Inner Joins, and this would be the perfect place for them I would have thought, but I cannot get an inner join to work here. perhaps because this is an access created database,.
View Replies
View Related
I understand that this forum uses some sort of cookie system to detect which threads have been read by users. I am trying to accomplish the same thing. My thought is to have a cookie with two keys: one with the last activity of the user, and the other with the posts that have been read.
Now, the only problem, is that I more than likely will need to update these reads threads based on a date/timeframe criteria, correct? Has anyone wrote one of these? In my threads table, I have a column named 'forumLastPostID' for each thread.
View Replies
View Related
I want to insert a new row in my db but it says that the "identifier is too long"...
ORA-00972: identifier is too long
to be more precised... I googled it but I can't seem to pinpoint how to work around this
View Replies
View Related
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.
View Replies
View Related
How do i make this number shorter?like 65.3846153846154%.how to make it like.let's say 65.39?
View Replies
View Related
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?
View Replies
View Related
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
...
<a href="mailto:?bcc=<%= e_email %>">E-MAIL ALL</a> |
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.
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
give me a sample code to display a "please wait"
message while retrieving results from the database in ASP.
View Replies
View Related
I have a sql statement that contains many fields. I am having problems with the way I am writing the sql statement. Here is an example:Code:
filePath = server.MapPath("directory/dbName.mdb")
Set conn = Sever.CreateObject("ADPDB./Connection")
conn.Provider = "Microsoft.Jet.OLEDB.4.0"
conn.Open filePath
mysql = "SELECT field1,
field2,
field3,
I get an error at the comma on the line "SELECT field1,
What is the proper syntax for line continuation?
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
I am using some code like the one below to work with a text file, modifying
its lines one by one:
Set objFS = Server.CreateObject("Scripting.FileSystemObject")
Set objF = objFS.OpenTextFile("MyText.txt", 1)
Do While objF.Line <= 26 ' --- I am reading only certain lines
'--- get entire line
strTemp = objF.ReadLine
'--- do some other stuff here
Code:
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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.
INSERT INTO products
(manufaturer, prod_category, prod_link)
VALUES ('Xtra','Irons','<a href="http://www.kqzyfj.com/click-1692223-10304326?url=http%3A%2F%2Fwww.golfsmith.com%2Fppage.php%3Fstynum%3DCL1480%26tcode%3Dcj" target="_top" >CG1 Irons w/ Steel - 3-PW Iron Set<br>$799.99</a><img src="http://www.afcyhf.com/image-1692223-10304326" height="1" width="1" border="0">');
What am I doing wrong.
View Replies
View Related
anyone got an idea on how to cut the output of a number? coz i made a computation and the output was this
81.5740740740741
and i want to make it 81.57
anyone got an idea?
View Replies
View Related
I'd like to get a number, and every third character from the right add a comma (aka 10000 becomes 10,000). How can this be done in ASP please?
View Replies
View Related
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 ....
View Replies
View Related
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?
View Replies
View Related
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.
do until myRS.EO
Response.Write("<td bgcolor=#eeeeee>" & myRS("OutstandingInCompliance") & "</td>" & vbcrlf
iTotal = iTotal + cdbl(myRS("OutstandingInCompliance")
myRS.MoveNex
loo
View Replies
View Related
Whenever an ASP.NET server-side control is processed, the client form is repainted from the top forcing users to scroll back to where they were on long forms. How can I work around this issue?
View Replies
View Related
I don't excactly know whether this is an ASP, webserver or SQL-Server problem:
I have an ASP with a search form. By clicking the submit button it redirects to my result.asp page which initiates a database query that takes pretty long (up to 4 minutes).
Now if I push the cancel button in my browser because it takes too long and want to open another ASP page in that browser window I just get the "page loading" bar until, it seems, the query I initiated before has finished, and then shows up the wished page.
What I think is, that the webserver is waiting for the the command:
set rs = db.Execute(sql_search_string)
to be finished by the SQL-server and does'nt respond to other page requests (but only in the same browser window) until the recordset is filled with the information from the SQL-server. Code:
View Replies
View Related
I'm new to using long raw fields with ASP. I know it would be easier
to leave the files on the file system, but the client wants them in
the database. Based on what I've read so far, I have used the
following code to read files from a hard drive and stuff them in the
database. Code:
View Replies
View Related
I need function that parses string, and splits it if it is longer than predefined number of characters.
View Replies
View Related
Here's what I have thus far:
<% =month(now) %> <% =year(now) %>
How can this be modified so that it, for this month, it would read:
August 2005
Also, how can I make certain there is a space between the month and the year without using a ?
View Replies
View Related
i have write a simple asp application, which is used to send batch email. the process will running for few hour, it depend on how much email needed to send. however i have a problem in ...........i can't find a way to stop this sending process until it send out
all of the email (or let say unless i reset the iis by in cmd typing iisreset).
i also have try different method such as before it need to send each mail it need to check the session, at that time (during send) user can press a button on the pop up page that change the session value. however this method is not work, it need to wait until the sending process finish.
View Replies
View Related
