Maintaining Paragraphs & Spacing When Inserting
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).
View Replies
ADVERTISEMENT
I am having trouble maintaining Session state between pages within my website. I had someone test the pages on their website and sessions state was maintained between pages, but for some reason, the same pages on my server do not. what might be happening?
View Replies
View Related
I have a web interface where the user types in ID's one at a time. After an
ID is typed in, a button is clicked and the button click event has code that
does a query and returns a data reader and then appends the data to a
dataset that is built in the Page_Load code in the if(!isPostBack) block.
When I try to add a row in the button click event code I get an error saying
that "Object reference not set to an instance of an object". I'm saving the
dataset in a Session object and then restoring it in the else clause of the
if(!isPostBack) block. I've pasted code below, please help. I'm relatively
new at asp.net development but have lots of asp and ado experience. Code:
View Replies
View Related
I am pretty new at all of this but I have managed to create a interface (dreamweaver, vbscript, access) so that a few of my writers for the web site can log in and submit there text. The question is, how can they (or what do I have to do) place CR and Paragraphs in there content. It seems as thought the Access DB ignores any manual CR that is entered during input. (just like in this input box)
I just pressed the ENTER key twice to get to hear but if I do that in my input box that does not happen.
Also, is there any tutorials that could show me how to place buttons like the ones above this input box so they could put in images along with their text.
View Replies
View Related
When for ex. somebody writes something in the textarea and if they press Return (on the keyboard) in the textarea everything seems OK. But in the database "Returns" are gone and when you retrieve data from the database "Returns" are gone.
I know that if i write html code in the textarea everything is ok - "Return" is there. I use Mysql database so maybe there is something wrong with settings or maybe when i select data from the database.
View Replies
View Related
i use this set of codes,
arrModels = split(request("model"),",")
arrSerials = split(request("serialno"),",")
arrQty = split(request("qty"),",")
not sure why when i do this sql
for i = 0 to uBound(arrModels)
sql = "INSERT INTO TableInventory (SerialNumber, Qty, ModelId, Hostname, IPAddress, LocationId) VALUES ("
sql = sql & "'" & arrSerials(i) & "', " & arrQty(i) & ", " & arrModels(i) & ", '" & request("txtHostname") & "', '" & request("txtIPAddress") & "', " & request("Five") & ")"
response.write sql & "<br />"
next
response.end
i get the second serialnumber with a extra spacing infront.
can advise me? Code:
View Replies
View Related
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?
View Replies
View Related
This is the code I've written (based on kbogart's suggestions) ....
View Replies
View Related
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 .
View Replies
View Related
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:
View Replies
View Related
I’m trying to allow large amounts of text, like up to 6 pages (many paragraphs) of text to be inputted into textarea that then sends off thru email.
When I receive the email, all the paragraphs that I’ve submitted become 1 big long paragraph.
I tried wrap attribute but it does nothing.
Is it possible to receive a paragraph by paragraph by using textarea?
View Replies
View Related
Access Database
Field required = no
for i = 0 to 2
arrParap(i) = MakeSafe(Request.Form("ppara_text"&cstr(i+1)),2400)
arrImgp(i) = MakeSafe(Request.Form("pimage"&cstr(i+1)),50)
arrImgpPos(i) = MakeSafe(Request.Form("pimgpos"&cstr(i+1)),50)
if len(arrParap(i)) > 0 then
strQp1 = "INSERT INTO paragraphs(para_page, paratext, paraimage, imgposition)"
strQp1 = strQp1 & "VALUES ('" & objRS1("Subcateg_id") & "', '" _
& arrParap(i) & "', '" _
& arrImgp(i) & "', '" _
& arrImgpPos(i) & "')"
objConn.Execute strQp1
End If
result
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Field 'paragraphs.paraimage' cannot be a zero-length string. /content-builder/admin/pageadd.asp, line 53
View Replies
View Related
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:
View Replies
View Related
There i seem to be having a problem when inserting certain characters into my access database using a form, mainly (') characters.
View Replies
View Related
I get the following error message
Microsoft VBScript compilation error '800a03ee'
Expected ')'
/weblinkup/chat.asp, line 1775
oConn.Execute("INSERT into chat (username,nametext,roomname,type,priv,thetime,msg) VALUES ('" & username & "', '" & username & "', '" & Roomname & "', 'msg', '0', '" & now() & "', '" & username & " has just said " & emotetarget & "." ')")
what the problem is with the code?
View Replies
View Related
i have a database Access with Book Table and Author Table. now i have created a form which inserts info submitted into the Book Table, yet it keeps giving me this error "You cannot add or change a record because a related record is required in table 'Author' " while the names of the authors are all registered.
it works in Access but not in asp it doesn't make much sense. People just enter the names of the books which their authors are in the Author table. it keeps giving me error. how to know why this is so?
View Replies
View Related
I have an error as follows:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not bulk insert. File 'c:mydata.csv' does not exist.
My mydata.csv file is inside the directory i stated. But why does the server complains that the file is not fould?
My codings:
strSQL = "BULK INSERT NAME FROM 'c:mydata.csv' WITH (FIELDTERMINATOR = ',',ROWTERMINATOR =
'
')"
Response.Write ("test")
Set oRS = conn.Execute(strSQL)
View Replies
View Related
I had some Error when i write the update sqlp query
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/fyp/Quiz/updateQuiz.asp, line 21, column 77
SQL_query= "update Activity_Status set UserID = '" +Request.Form("username") "'" "where Score = '" +Request.Form("QuizScore" + "'")"
Code:
SQL_query= "update Activity_Status set UserID = '" +Request.Form("username") "'" "where Score = '" +Request.Form("QuizScore" + "'")"
View Replies
View Related
I'm using ASP + MS SQL. I wrote a simple insert into command but nothing is happening... it gave no error and no information is stored in the db. When I response.write my SQL, I got the following:
INSERT INTO [blog_entries](title,user,entry,date) VALUES('test','admin','test','Tuesday, December 25, 2007')
View Replies
View Related
I'm wondering if it's possible to create an instance of an ADO Recordset and add values to it by ASP ??
Ex :
I have 2 arrays :
arr1 = Array(1,"allo")
arr2 = Array(2,"bonjour")
Is it possible to add these 2 arrays into a Recordset to manipulate de data more easily?
If yes, could you provide me with a little example to see the synthax, because I tried almost everything and it didn't worked at all
View Replies
View Related
how do i design my site interface such that users can insert smilies along with text in the form field just like it is here on sitepoint...
View Replies
View Related
i've tested my code and it seems to send back an error, when i'm trying to insert a record into my db (sql server)
Basically when I udpate one of the records it's fine ( I update at a certain "productID")
But when I insert a new record it sends back an error telling me that my "productID" can't be a null value?Any ideas on how to fix this?
View Replies
View Related
When I insert info into a DB from a form, it cuts the string off at the first apostrophe (").
How would I make it insert the data as-is, with the apostrophes? Here is the code used to insert the Data:
View Replies
View Related
I am developing web pages , therein doing database
connectivity using ASP with Microsoft Access.I want to
insert a file (.opt/.pmopt) into a field 'OLE Object'. Also
I want to display that file name in tabular form and a link
to download that file.
View Replies
View Related
I am trying to make a web-based front-end for one of our programs. I'm running into a problem. Here's a sample of one of our tables:
Code:
CaseNo ChargeCount ArrestCharge FiledCharge
123 1 13 13
123 2 14 14
199 1 03 03
The ChageCount column cannot have nulls and must be unique. is there a way when I'm adding a new charge, i can check to see if a chargecount exists? For example, if inserting a new record, it will first check if there is a chargecount, if there is not, it will make it 1. if there is a charge count, it will +1 to the existing chargecount
View Replies
View Related
Im doing a update page and noticed this error, whenever you want to write for example "can't, i've" it errors on submit, but characters like "." are okay. Why doesn't it like these characters and how can i make it like them? I need some extra code?
View Replies
View Related
I have the folllowing page where a user can add a review to the website. So far the page works fine, but on the review rating section I know that the rating is between 0 - 5.
But its posible for a user to enter 1000 if they wished, which still means the page works but the answer is too high.
Also if they write text in the field it errors the page. How do i code this so that they can only enter a number between 0 and 5 and only a number and not text.
View Replies
View Related
I want to make a button just like here (when posting new thread) to insert hyperlink into text.
For example when user is typing text into textarea I would like to have also a button that can enable users to post different links to other intenet pages.
And I would also like to have button that makes the text bold
(Actually those are buttons that appear on most forums when posting a new thread)
View Replies
View Related
I got a webpage in which I am cheking various checkbox values.Actually the problem that I am facing is that,I am not able to insert the contents in to the database.
But no error is coming.What I am doing is that,when the user submits the form,using a retrun querystring,i am storing all the checked values in to an array.I am able to print this array with correct output.But whn i am trying to insert in to the database,it is not getting inserted.
View Replies
View Related
I'm having problems inserting into a table in an oracle database. I am reading in variables from a ASP form and trying to enter these into the database. however only numbers will insert, even though I can print out the string variables on the ASP page. IF I inclose a string value in the insert statement it works ok so there is nothing wrong with my SQL code. Code:
View Replies
View Related
I am right now calculating distance between 2 zip codes and storing them in a table along with extra information like a persons name and address and stuff like that.
For some reason for distance "0" ..doesnt get inserted in my table..? What do i need to do in my code so that "0" distance + information gets in the table since i need that info to be displayed later for people to make calls to those people with 0 distances.
View Replies
View Related
I have created an online database for a school project, and everything WAS going fine until today. I created the add record page and for some reason, whenever i try to add the records to the database THIS error message comes up: Code:
View Replies
View Related
I have successfully pulled data from an LDAP server and now what I want
to do is drop the data into a database table. The following is my code
that will insert the data but that has problems.
View Replies
View Related
