473,320 Members | 1,961 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Does anyone know? Please Read [Third Attempt]

If you got the answer, thank you so much.
OK I have to ask this question again as I know it can’t be that
difficult, nor is it that rare. So a lot of people are doing something
wrong, but what are we doing wrong?
Someone types text in Ms Word, say a blog entry or forum post, then
they cut that text out of word and past it into a form on the web and
submit it. It get written to SQL Server.
The problem, word takes a single quote character #39 and turns it into
#146 in most cases, by default.

You then use a method let’s say GetDataSet() and work with that
data. The text is messed up: "It’s" becomes "it’s" This is
NOT a problem when using a DataReader, but when you return a DataSet...
XML you get this behavior.
Example
I have searched the web for the afore mention characters and found that
"many" web sites are displaying text in this manner For example here is
one that does so:
http://www.artima.com/forums/flat.js...&thread=159914

The first paragraph starts off this way:

“Using ASP.NET 2.0’s new GridView control with the new
ObjectDataSource ”

same messed up text in firefox
Using ASP.NET 2.0’s new GridView control with the new
ObjectDataSource allows

Nov 29 '06 #1
1 1127
What exactly are you asking? When you paste into a textarea, you are pasting
into a browser form element that accepts only pure text. How the formatted
text is "translated" into pure text is a function of the user's operating
system and/or the browser, of which there are many of both operating
systems, browsers, and system configurations on the Internet.

Therefore, there is no way to know from one form post to another what has
been sent from the user's computer to the server. The form data that arrives
on the server is pure text. The server cannot know whether what arrives is
what was intended by the user. It only knows what text it has received. It
faithfully handles the text data exactly as it was sent by the user. That is
all it can do.

In other words, GIGO - Garbage in, Garbage out. While is is possible to
create software that is intelligent enough to figure out all of these
things, it certainly hasn't been done yet, and is cost-prohibitve. What
you're describing is some fairly advanced artificial intelligence. Even if
Microsoft or some other software company were to come up with such software,
the cost of creating it would make it too expensive for most people to buy.

At some point, regardless, it is the user's responsibility to use their
software correctly. The idea that computers can be so smart as to figure out
the intentions of the user regardless of the input, and to correct any
possible mistakes made by the user is a pipe dream. If the day comes when
computers are as good at fuzzy logic as humans are, they will most likely
become as unreliable as humans are. No matter how smart computers become,
people are highly likely to keep out-dumbing them.

--
HTH,

Kevin Spencer
Microsoft MVP
Virtual Carpenter
http://unclechutney.blogspot.com

Paranoia is a state of mind.
"DaBrain" <Ta**********@gmail.comwrote in message
news:11**********************@h54g2000cwb.googlegr oups.com...
If you got the answer, thank you so much.
OK I have to ask this question again as I know it can't be that
difficult, nor is it that rare. So a lot of people are doing something
wrong, but what are we doing wrong?
Someone types text in Ms Word, say a blog entry or forum post, then
they cut that text out of word and past it into a form on the web and
submit it. It get written to SQL Server.
The problem, word takes a single quote character #39 and turns it into
#146 in most cases, by default.

You then use a method let's say GetDataSet() and work with that
data. The text is messed up: "It's" becomes "it?Ts" This is
NOT a problem when using a DataReader, but when you return a DataSet...
XML you get this behavior.
Example
I have searched the web for the afore mention characters and found that
"many" web sites are displaying text in this manner For example here is
one that does so:
http://www.artima.com/forums/flat.js...&thread=159914

The first paragraph starts off this way:

"Using ASP.NET 2.0’s new GridView control with the new
ObjectDataSource "

same messed up text in firefox
Using ASP.NET 2.0’s new GridView control with the new
ObjectDataSource allows
Nov 29 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: lawrence | last post by:
I'm learning Javascript. I downloaded a script for study. Please tell me how the variable "loop" can have scope in the first function when it is altered in the second function? It is not defined...
13
by: Jason Huang | last post by:
Hi, Would someone explain the following coding more detail for me? What's the ( ) for? CurrentText = (TextBox)e.Item.Cells.Controls; Thanks. Jason
2
by: rrossney | last post by:
Please look at the "what I've already done" section of this message before responding to it: I believe that I've done everything that the people who experience this error are typically told to do....
2
by: Patti | last post by:
I am building an application using VB.NET 1.1 and I have an issue with Font properties in my Radio Button Lists and Check Box Lists. My issue is that the Font Names and Font Size for these...
130
by: Daniel Manes | last post by:
I'm baffled. I have a column in a SQL Server Express database called "Longitude," which is a float. When I view the table in a DataGridView, some of the numbers, which only have two decimal places...
2
by: Greg Scharlemann | last post by:
The last time I tried to ask this question...Google Groups screwed up my message and there was no subject (sorry for that - I know it's annoying). I'm trying to learn how to develop a plug-in...
4
by: skatemore9690 | last post by:
#1 in Calculus you learned that log(1+x) = x - x^2/2 + x^3/3 - x^4/4 + ... for x in the interval (-1,1] (here x^2 means "x squared", etc.). Write a program which asks the user to type a...
19
by: active | last post by:
The ColorPalette class has no constructor so how does one use it? I define a variable by: Dim cp as ColorPalette but don't know how assign an object to the variable. Thanks in advance
1
by: Blubaugh, David A. | last post by:
Pauli, Yes, I am utilizing the windows environment. I cannot install f2py. I obtain the following error when I try to execute the setup.py file within the f2py folder located within the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, youll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.