I've got a situation where I need to be able to replace "smart quotes" and similar characters that are created (presumably) by Microsoft Word. If you don't already know, smart quotes are those "curly quotes" that curl or angle in toward the text on each side. Here is an example, though I'm not sure how it will display in a browser: “
I thought I had just used a standard replace function in the past for these things, and that seemed to work when the text was coming from a form. However, now I am receiving them from a scraped web page, which I have retrieved using ServerXMLHTTP. In this case, a standard replace is not working.
I've noticed that when I use Server.HTMLEncode on the text, both left and right smart quotes, angled apostrophes, em dashes, etc. all get encoded as  which tells me something goofy is going on. I don't know if this is a character encoding issue or what. I could just HTMLEncode the string and do a replace on  but that also encodes other things that I don't want encoded, and there appears to be no such thing as Server.HTMLDecode in classic ASP.
if there is a way to find (to strip or process) smart quotes in text submitted via a form? These don't work:
strOutput = Replace(strOutput, "“", "“") ' left smart quote char as replace value strOutput = Replace(strOutput, Chr(147), "“") ' my best guess at where the left smart quote char is in the charset. I guess the real question is if I submit the page as Unicode is there a way to process it as cp-1252?
I have modified the sample code to use my SQL database as opposed to Access. I can upload files to an image field without problems. I am saving files (word, excel, pdf) to keep track of different version. I do want them in a database, and not saved to disk.
I cannot dowload files that I have uploaded. Does anyone have working code to dowload a file from an SQL database using aspSmartUpload?
I am using smart upload object to upload files in n/w it works fine with one of my server setup but when i tried to replicate in another server this is not working
I checked with the dll registration every thing is fine....
Can someone help me my quotes in LISTING 2 below? LISTING 1 works fine in HTML, but I'm having trouble with quotes in LISTING 2 near the javascript code when trying to response write the entire button code.
LISTING 1: HTML <INPUT TYPE=BUTTON VALUE="<< Previous <%=iMaxRecords%> Records" ONCLICK="document.location.href='paging.asp?iPage=<%=iPage-1%>'">
I have a product description in an sql database.which looks like this Do's and Dont's.When i pull it to look at it on the screen it displays fine.But now when i go to move that into another database for the order it only displays Do in the other table. Which means its cutting everything off from the ' forward.Ive tried just about everythign to my knowledge adn i still cannot get this to work.
help with the fix quotes? For example, I have persons name as Jo'Mario entered as text in a text box, I need to text to go clean without any error because I am generating an error as follows:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
And I think it is due to single quote I am using in the text box.I know there is a coding to fix this problem but not sure of it.
Below in GOOD CODE, I have a mix of ASP/HTML that works. I'm trying to convert the code into all ASP, but I'm failing in BAD CODE. The single quotes are very hard to master.
I'm currently writing a custom financial app that tracks stock purchases and values. however, I need help in retrieving stock quotes from the internet. A 20 minute delayed quote is fine. I do not want to revert to "page or screen scraping".
I have successfully taken over a number of variables from a .csv file and put them into an .asp page. Unfortunately the .csv file has all these variables enclosed in double quotes i.e "Hello" and appear this way on the .asp page. Is there anyway of removing the double quotes (") from the beginning and end of the variables? I have tried splitting the individual variables on the " with this sSeg2 = Split( var1, """ )
My ASP page allows user to enter comments into a form. To avoid errors I'm having to strip out double quotes before saving to the database. Is there anyway to encode these so that I can store them instead, in the way was an URLEncode works?
How do I "escape" any quotes, accidental carriage returns etc that are contained within strPageTitle? Do I have to use a series of replace() functions, or is there a cunning way that makes it OK?
(Using escape(strPageTitle) fills the box with % signs...)
I have some info stored on Access DB, when i pull it for updates I should print the data as fallow:
<input type="text" name="Field1" value="<%= RS ("Field1") %>" size="20"> All that well and good but the problem occur when "RS ("Field1")" contain a double quote!
I've got an HTML page with a series of links that are intended to search a category listing in a database.
for example
link 1 has a querystring of "?subid=Boats" link 2 has a querystring of "?subid=Cars & Trucks" link 3 has a querystring of "?subid=Men's & Women's Outerwear" etc
As long as the subid doesn't contain any single quotes or any special characters such as the "&", my SQL works ok and the records are retrieved. 'm using Request("subid") to get my querystring value.Is there any way I can escape the single quotes or other special characters in the Request("subid") so it won't break the SQL?
What is the best way to deal with quotes inside form data that a user is submitting to my page?It screws up my editing feature,in which I'm using a SQL string to edit the data.Adding works with the quotes,as I'm using .addnew for new records.
I'm still having trouble getting some of my data being returned properly when people use quotes. (ex ProjectName contents being - the "primary" project - The double quotes are the main issue. I am using a function for the single quote and it seems to have resolved the issue.
Code:
Term = trim (Term) if Term <> "" then Term = Replace (Term, chr (39), chr (39) & chr (39)) end if If Term <> "" then
I use this just when passing strings from a form. I tried altering it and using chr (34) for a double quote but it didn't work.
I have a form that asks for the size of a particular object. Sometimes the size is 4" X 8". The problem that arises is when the record is pulled back from a database to a textbox in a form; I get an error with HTML.
I try and place the 4" X 8" into a text box, like <input type="text" name="size" value="4" X 8""> Is there something I can do in ASP to keep this from happening after the client receives the data?
As I get further and further into ASP/VBscript I realize I just don't undertstand how to properly use single/double quotes at the same time. This is really holding me back. If anyone can help me understand this better or know some good articles I would appreciate it. My current problem is adding a logo to my page from the database. What quotes are needed inside my <img> tag. Code:
I'm trying to pass data from a <textarea> box to a confirmation page and then pass the same information from the confirmation page to a final page.
When the information gets passed to the final page it is truncating it where there are double quotes. I've tried to do a replace() function to try and escape the quotes out but it's not working.
Access 2000 doesn't allow single quote when updating records from the webpage. If the user need to insert for example the name O'neil in a field it will create this error:
I want to dynamically build a call to another asp page and include some parameters as part of the call. The basic format of the call is something like::
where there is a single quote followed by a double quote following the ...location=... and vica-versa after the variable
My problem is that the variable thelocation can include a single quote or a double quote. I tried Server.URLEncode and that didn't work. I got a string that ended up causing a Page Not Found (it encoded the dot in the page name and that didn't work)
How can I encode the data so that quotes will be accepted in this type of call?
I have a form that inserts data into a database...wow, big surprise there, huh? Anywho, my problem is when a user types a word like can't or won't etc.. The single quote obviously throws off the SQL string.
I looked through the forums to see if anyone else had similar problems and I found one. It was suggested to use a replace method upon inserting and then reversing that when reading data from the database. Code:
What is the best way to handle inserting double and single quotes into a database via input from a form?
It's not a good option to remove them, since I need the text to contain punctuation sometimes. Likewise if I replace them with special characters (e.g. Code: & # 34 ; (without the spaces) ) it buggers up any HTML formatting I have in the textbox.
Is the best way to handle this to replace with HTML special characters then replace them back again in the database output?
How can you insert a quote ' or " into a database from a forum without getting an sql error due to the quotes closing, or opening a new field in the sql string.
I have some data string like ~!@#$%'^&(*("}[;asd"> which contains double quote and greater then sign, first I need to insert this value into database, second this inserted value I have display in a textbox by retriving from database, as it has "> at end of the string values are getting discarded.
