Textarea Apostrophe
i have a textarea in my form, and it worked. but if the input text contains apostrophe, i would get sth like this:
Microsoft OLE DB Provider for ODBC Driverserror '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''rtert'','Judy Nadia Jolonius');'. /saveRemarks.asp, line 195
how can i make asp ignore the apostrophe?
View Replies
ADVERTISEMENT
how to dispaly text from a text area on a page as page copy (using the replace function)
How do I display this text inside another textarea, holding formatting? All variations of 'what I thought would work' do not.
I am using the following function:
Function DisplayMemo(theText)
DisplayMemo = ""
on error resume next
DisplayMemo = CStr(theText)
if (len(DisplayMemo) > 0) Then
DisplayMemo = Replace(DisplayMemo, vbCrLf, "<br>", 1, -1, 1)
end if
End Function
calling it like:
<textarea cols=119 name=ownSubmitted rows=7>" & DisplayMemo(getInfo(0)) & "</textarea>
NOTE: getInfo(0) is a variable holding my value. Yes the value is there. It is showing the text I want, however the <br>'s are rendered inside the text area?
View Replies
View Related
I am writing a small database utility to catalog all of my favorite ASM/JS/VBS functions and scripts on an asp page. Everything is going smoothly except for one thing that I can't quite seem to think my way around.
I am using a <textarea> to display the code but some of my scripts have <textarea> tags in them and when the </textarea> tag is entered, it closes my <textarea> and the rest of the code ends up outside of the textarea.
Example: (the code after the middle </textarea> show up outside of the textarea box)
<textarea>
code...code...code...
code...<textarea></textarea>code...
code...code...code...
</textarea>
View Replies
View Related
I am getting a bug with regards to submitting an ASP form. Here's the scenario:
I am entering info in a form and calling an ASP page to process it. I am collecting info from the fields like so Code:
View Replies
View Related
I’ve a form with a textbox called Message. When visitor enters text, I use Replace function to handle an apostrophe code that will receive the text and store in the database.
It works fine.
When I try to retrieve the text message, it doesn’t show what I’ve in the DB, but it displays, for example: I?m. It supposes to display as “I’m”
I did try:
<%message= Replace(trim(RS("message")),"'","''")%>
<td><p><%=message%></p></td>
View Replies
View Related
I know this is a very commonly asked question, but I can't find a solution
anywhere that I have looked.
I need to take the text that will be typed in paragraph form by the user
(textarea field) and do two things with it:
1. Store it in a SQL Server database field
2. Send it in an email upon page submit.
Of course, single quotes have caused problems, so I have this code:
strInternalDesc =
Replace(Trim(Request.Form("InternalDesc")),"'","''")
Problem is, it shows up like this in the email that is sent:
==============================
We''re in the process of
==============================
I would like to get rid of the double apostrophes, but not sure how. Went to
an article on ASPFAQ, and saw something which directed me to do this:
strInternalDesc =
Replace(Trim(Request.Form("InternalDesc")),"'",chr(34))
However, that just makes it a regular double-quote. I guess I could try and
find out what the character number for apostrophes are, but not sure where
that is. Besides, will that mess up my SQL Server or the email if I do that?
View Replies
View Related
I know a few ways to handle an apostrophe, but am at a loss for which i should use for this. The ways I know how to deal with it are.
alias = Replace(Request.form("alias"), "'", "''")
alias = Replace(Request.form("alias"), "'", " & #39; ")
The name of the field is self explanitory. When the admin searches for a person using the "'" , " ' ' " method they find the user. But when ever we display that info anyware it has the O''conner setup. Code:
View Replies
View Related
I'm trying to query a database where some records contain apostrophes in them. Is there an effective way to do this?
View Replies
View Related
I am running into a very common problem that i cannot seem to find a solution for. I have an access database with a text field. Some of the records will contain an apostrophe. i have used the replace method to escape the apostrophe and turn it into ~~~. I can sucessfully change that back to an apostrophe everywhere but a text box. Here is my code:
response.write "<input type=text name=title" & icount & " value='" & replace(rs("title") ,"~~~", "'") &"' size=55><br>"
View Replies
View Related
Below is the code I use to send data from form to database. Problem is if an apostrophe is entered in cQuestion field or any field for that matter the form errors out. Code:
View Replies
View Related
When I want to execute a SQL statement (as we all know) certain characters will cause an error. You can't execute a statement with a " in one of the parameters or else the command will stop short and result in an error.
Let's say for example that I'm trying to update a field named "code" and the value of the field "code" is: Code:
View Replies
View Related
I currently have a simple html page that consists of a text box and submit button. A user supplies a quote in the text box and presses the submit button. When the submit button is pressed the quote is added to a ‘Quote’ table in an MS Access database.
This works perfectly well, however if a quote contains an apostrophe, such as … this won’t work… It will not add to the database. If I had typed in …this wont work… It would be added to the database with no problems. Code:
View Replies
View Related
how to add the symbol ' (Apostrophe) to the code so that the validation accepts this within a surname such as o'neill? this is wot i hav at the minute:
With regExName
.Pattern = "^[a-z]+$"
.IgnoreCase = true
.Global = true
End With
View Replies
View Related
how to accept ' or apostrophe when adding on the database? because I created a simple guestbook and when i tested it it works fine but once i add apostrophe like TOY'S etc it generates error.
View Replies
View Related
I am having a problem with the apostrophe not showing up correctly when doing a mysql query and returning the data.
I am using a function to keep apostrophes from causing the queries to fail and the data that does get displayed to the user (html) turns out right 90% of the time but on a certain page it displayes the apostrophy twice instead of once. Here are the relevant pieces of code:
View Replies
View Related
I am using a Replace function to replace single quotes with double when
submitting a text field in the database i.e. Replace (q, "'", "' ' ")
which works fine. When I retrieve the field from the database which has
apostrophe I am getting 'Object expected' error message. Is there a
way to fix this?
View Replies
View Related
Isn't there some line of code that I can write to tell ASP to treat everything between BLAH and /BLAH as text (including the apostrophe). So that users can type a name of "O'Malley" in a form and I can retrieve it and store it in my database.
View Replies
View Related
What is the correct data type to use if the phrase I'm saving to my table contains an apostrophe such as in the phrase "yesterda's news". I've tried "text" data type, I've tried "varchar" and "char". They all give me bugs when I save to the database and if I remove the apostrophe from the phrase, then it saves correctly with any data type.
View Replies
View Related
I am able to populate the contents of my textares with employees. However when I view it in the browser (IE 6.0), then I see that the 1st employee is aligned towards the right.
Like this: Code:
Emp1
Emp2
Emp3
Emp4
Emp5
How can I ensure that my alignment is is proper? Code:
View Replies
View Related
Simple vbscript,html page loading into access.
Input pg posting to Confirm pg, then sending to access.
when using;
<textarea name="name" tabindex="15">
</textarea>
as an input renders tab spaces automatically.
I took out <Div> tags, and tried nowrap, and tried
reformatting data before sending to dbase (CStr, Trim)
View Replies
View Related
I made a simple <textarea> , but the problem is, everytime I want to press Enter to break row , I gotta put <BR> .. can I do something that the user can type freely and the ASP will insert <BR> where needed?
View Replies
View Related
I've written several scenarios where the end user needs to enter data into a textarea (descriptions, messges etc) which becomes part of a form. End users often put apostrophe's and carrige returns in the textarea... however, when the code i write is submitted to the database, it generates an sql command from the page that sent the action.
Client Side:
<form action="somepage.asp" method="post">
<input type="text" name="emailaddress">
<textarea cols="20" rows="5" name="comments"></textarea>
</form>
On code submission...
sql="insert into tableName (email,comments) values ('" & request.form("emailaddress") & "','" & request.form("comments") & "');"
db.execute(sql)
Now, when strange people put carrige returns, it stuffs up the string and therefore produces an error, and to make matters worse if it did recognise a carrige return, it wouldn't be displayed on HTML output. Apostrophes are even worse - they signify the end of a variable in the SQL sentance Can anyone help me and figure out a new way of writing to the DB?
View Replies
View Related
I've got a page on a website I'm developing that contains a textarea.
The textarea will allow users of the site to enter a description of an
item.
When they submit the form that contains the textarea, the textarea and
other form elements data are stored in a database. So far so good.
My problem concerns carriage returns, new lines, line feeds or whatever
else you want to call them :-)
I want them preserved, so when the user wants to edit the description of
the item, the format of the description is displayed exaclty as it was
entered.
The problem is that HTML renders the carriage returns as white space, so
when the database is read and the textarea populated with the
description field, the carriage returns are lost.
I have tried the ASP REPLACE function to replace carriage returns with
<br>, but the code below actually displays all the <br>'s.
<%=Replace(myRecordset.Fields.Item("myField").Value,Chr(13),"<br>")%>
I played around with different combinations of chr(13) and vbcrlf and I
managed to get the textarea to display the description as it was entered
with carriage returns, but upon further testing and editing of the
description, because of the REPLACE function, the number of carriage
returns was doubling each time!
View Replies
View Related
i have 2 tables one table stores the information for the prof and second table stores information for the subject he teaches so first table deptprof has the id,name,email for the professor
so i get his last name and email which is working second table design is name is deptlist
fields are
deptautoid
deptid
subjectname
desc
so one professor might be teaching 3 subjects
so the records in table are
1001
3
maths
maths subject is boring
1002
3
science
science is good
1003
3
sports
make some time for it
so now this page lets the professor update the subject and its desc
so what i do is fill up the subjects and desc he is currently assigned to and then he can change the subjects
and desc
subjects have a checkbox and desc has a textarea
what happens is for example a professor has 3 subjects he is teaching now
so 3 checkboxes are selected and all the desc for them are displayed in the textarea
but now the professor decides he wants to teach 4 subjects
so he selects the 4th subject checkbox and doesnt enter the desc i want to fire the alert
but it doesnt fire the alert
second way prof is teaching 3 subjects
3 checkboxes are selected and 3 textarea are filled
professor decides to delete desc in one of them and hits submit i want to fire an alert
saying he forget desc but it doesnt fire so whenver desc is deleted from the textarea and checkbox for it is selected
i want to fire an alert
can someone tell me whats wrong with the code
thanks,
todd
Code:
<%
getid=trim(request.form("id"))
sqlstr = "SELECT *FROM deptprof WHERE ID = '" & getid & "'"
Set rsdept = Conn.Execute(sqlstr)
getlname=rsdept("LastName")
getemail=rsdept("Email")
rsdept.close
Set rsdept=nothing
sqldeptdetails = "SELECT *FROM deptlist WHERE deptid = '" & getid & "'"
Set rsDetails = Conn.Execute(sqldeptdetails)
%>
<head>
<title>Dept List</title>
<script type="text/javascript">
<!--
function formCheck(formobj)
{
var fieldRequired = Array('LName', 'Email');
var fieldDescription = Array('Last Name', 'Email');
var alertMsg = "You can't submit the form until ALL the mandatory fields have been filled out.
";
alertMsg += '_________________________________________________ ___
'
alertMsg += "Please complete the following fields, then press 'Update dept':
";
var c = 0;
for (var i = 0; i < fieldRequired.length; i++)
{
var obj = formobj.elements[fieldRequired[i]];
document.getElementById(fieldRequired[i]).style.backgroundColor = '#' +'ffffff';
if (obj)
{
switch(obj.type)
{
case 'select':
if (obj.selectedIndex == -1 || obj.options[obj.selectedIndex].text == '')
{
alertMsg += ' - ' + fieldDescription[i] + '
';
document.getElementById(fieldRequired[i]).style.backgroundColor = '#' + 'f8e563';
c++;
}
break;
case 'text':
case 'textarea':
if (obj.value == '' || obj.value == null)
{
alertMsg += ' - ' + fieldDescription[i] + '
';
document.getElementById(fieldRequired[i]).style.backgroundColor = '#' + 'f8e563';
c++;
}
break;
default:
if (obj.value == '' || obj.value == null)
{
alertMsg += ' - ' + fieldDescription[i] + '
';
document.getElementById(fieldRequired[i]).style.backgroudColor = '#' + 'f8e563';
c++;
}
}
}
}
alertMsg += '
These fields have been highlighted for your attention.';
if (c == 0)
{
var strGroupName="rad1";
var checkedCount=0;
for (var i=0; i<document.frm1.elements[strGroupName].length; i++)
{
var curBox=document.frm1.elements[strGroupName][i];
if (curBox.checked)
{
if (document.frm1.elements["txt"+(i+1)].value=='')
{
alertMsg += "Please complete the following fields, then press 'update dept':
";
alertMsg += "You have not entered the value for the "+(i+1)+" Specify desc
";
alert(alertMsg);
document.frm1.elements["txt"+(i+1)].focus(0);
return false;
}
}
}
document.getElementById('submit').value = 'Next...';
return true;
}
else
{
alert(alertMsg);
c = 0;
return false;
}
}
//-->
</script>
</head>
<body>
<form name="frm1" method="post" action="conflist.asp" onsubmit="return formCheck(this);">
<p>Last name:<input type="text" size="32" name="LName" id="LName" value="<%=getlname%>"><br/>
<p>Email:<input type="text" size="32" name="Email" id="Email" value="<%=getemail%>" /><br/>
<table>
<tr>
<th>No</th>
<th>Dept</th>
<th>Desc</th>
</tr>
<tr class="evenrow">
<td>1.</td>
<td><input type="checkbox" name="rad1" value="Maths"
<%
do while not rs.eof
if rsDetails("subjectname") ="Maths" then
Response.Write "checked"
end if
rsDetails.movenext
loop
rsDetails.movefirst
%>
>
Maths</td>
<td><textarea name="txt1" id="txt1" rows="2" cols="35">
<%
Dim rs1,sqlr1,raexp1
raexp1="Maths"
sqlr1 = "SELECT desc FROM deptlist WHERE deptid = '" & getid & "' and subjectname='" & raexp1 & "'"
Set rs1= Conn.Execute(sqlr1)
if not rs1.eof then
%>
<%=rs1("desc")%>
<%
else
End if
rs1.close
Set rs1=nothing
%>
</textarea></td>
</tr>
<tr class="oddrow">
<td>2.</td>
<td><input type="checkbox" name="rad1" value="Science"
<%
do while not rsDetails.eof
if rsDetails("subjectname") ="Science" then
Response.Write "checked"
end if
rsDetails.movenext
loop
rsDetails.movefirst
%>
>Science</td>
<td><textarea name="txt2" rows="2" cols="35">
<%
Dim rs2,sqlr2,raexp2
raexp2="Science"
sqlr2 = "SELECT desc FROM deptlist WHERE deptid = '" & getid & "' and subjectname='" & raexp2 & "'"
Set rs2= Conn.Execute(sqlr2)
if not rs2.eof then
%>
<%=rs2("desc")%>
<%
else
End if
rs2.close
Set rs2=nothing
%>
</textarea></td>
</tr>
<tr class="evenrow">
<td>3.</td>
<td><input type="checkbox" name="rad1" value="sports"
<%
do while not rsDetails.eof
if rsDetails("subjectname") ="sports" then
Response.Write "checked"
end if
rsDetails.movenext
loop
rsDetails.movefirst
%>
>sports</td>
<td><textarea name="txt3" rows="2" cols="35">
<%
Dim rs3,sqlr3,raexp3
raexp3="sports"
sqlr3 = "SELECT desc FROM deptlist WHERE deptid = '" & getid & "' and subjectname='" & raexp3 & "'"
Set rs3= Conn.Execute(sqlr3)
if not rs3.eof then
%>
<%=rs3("desc")%>
<%
Else
End if
rs3.close
Set rs3=nothing
%>
</textarea></td>
</tr>
<tr class="oddrow">
<td>4.</td>
<td><input type="checkbox" name="rad1" value="arts"
<%
do while not rsDetails.eof
if rsDetails("subjectname") ="arts" then
Response.Write "checked"
end if
rsDetails.movenext
loop
rsDetails.movefirst
%>
>arts</td>
<td><textarea name="txt4" rows="2" cols="35">
<%
Dim rs4,sqlr4,raexp4
raexp4="arts"
sqlr4 = "SELECT desc FROM deptlist WHERE deptid = '" & getid & "' and subjectname='" & raexp4 & "'"
Set rs4= Conn.Execute(sqlr4)
if not rs4.eof then
%>
<%=rs4("desc")%>
<%
Else
End if
rs4.close
Set rs4=nothing
%>
</textarea></td>
</tr>
<tr class="evenrow">
<td>5.</td>
<td><input type="checkbox" name="rad1" value="computers"
<%
do while not rsDetails.eof
if rsDetails("subjectname") ="computers" then
Response.Write "checked"
end if
rsDetails.movenext
loop
rsDetails.movefirst
%>
>computers</td>
<td><textarea name="txt5" rows="2" cols="35">
<%
Dim rs5,sqlr5,raexp5
raexp5="computers"
sqlr5 = "SELECT desc FROM deptlist WHERE deptid = '" & getid & "' and subjectname='" & raexp5 & "'"
Set rs5= Conn.Execute(sqlr5)
if not rs5.eof then
%>
<%=rs5("desc")%>
<%
Else
End if
rs5.close
Set rs5=nothing
%>
</textarea></td>
</tr>
</table>
<p><input class="button" type="Submit" id="Submit" value="Update Dept" /><input class="button" type="reset" id="reset" value="Clear" /></p>
<%
Conn.close
Set Conn=Nothing
%>
</form>
</body>
</html>
View Replies
View Related
I am useing "<iframe style="width:650;height:220;overflow:auto;" src="blank.gif" name="IDtemp" id="IDtemp" contentEditable="true"></iframe>"
an i really need to copy selected text from that iframe into
View Replies
View Related
I am trying to display data pulled from a sql db in a text area. The field in the db is of type ntext. I am printing the data using the following code.....
<TEXTAREA name="HTML" COLS=100 ROWS=21>
<%Response.Write(rsCreativeElement("ElementHTML"))%>
</TEXTAREA>
But this is printing as <Long Text>, how can I print the actual data from the db.
View Replies
View Related
Is there a simple way to get the content of my textarea
not encoded !? My text area has comments in it and right
now, I have to replace all encoded characters...
View Replies
View Related
I'm looking for some basic end user textarea formatting, similar to the formatting available when messages are created in this forum, bt even more basic.
I really would like let the user add hyperlinks and to add bolded text without knowing the html tags for these. Any suggestions on where to look for this. Ideally something that would work with all browsers (i.e. including Opera).
View Replies
View Related
I need to create a form with a textarea on an ASP page that, when opened, fills the textarea with the current contents of a field in an Access database, and each time the form is submitted, appends any new text added to the existing text in the database field. I can do this, but the text runs together when it fills the text area. Example:
Entry 1
Entry 2
comes back as
Entry 1Entry 2
Any suggestions on how I can maintain line feeds when I pull the appended field back from the database.
View Replies
View Related
I am using TEXTAREA as input. While entering texts sometimes I am creating paragraph and save them .But when I retrieve from database it comes without paragraph.
Is there any way we can create paragraph in TEXTAREA?
View Replies
View Related
i can get the data out the db but then i am at a loss as to how i fill the txtarea with the text from the db, anyone know?
View Replies
View Related
I know this is not a core .asp issue, but I'll try anyway. I've used the TEXTAREA element for a while, but as you know it's limited when it comes to formating part of the text inside a TEXTAREA.Does anyone have expirience using other text cointainer objects (Java/ActiveX), which is easy to use and easy to read values from when sending a form to a procedure .asp page?
View Replies
View Related
I have this textarea in my form that is not displaying data. BUT when you look at the source you can see the text in the 'value'.here is the code:Code:
<textarea name="txtgen" value="<%=rs("gen_av_m")%>" cols="138" rows="5" id="txtgen"><%=rs("gen_av_m")%></textarea>
there are no error messages.
View Replies
View Related