Hi,
I'm looking to find out how to properly handle the input of certain
characters into a textbox that will be inserted into a database. In this
app, text is copied and pasted into a textbox from various sources, and
sometimes contains the funky curly quotes and apostrophes which end up being
dropped on the database insert. I'm not sure if the issue resides in my
asp.net code or in the database itself (SQL 2000). Thanks for any help. 4 1247
On Wed, 04 Aug 2004 15:50:50 GMT, "anony" <no**@m.com> wrote: Hi,
I'm looking to find out how to properly handle the input of certain characters into a textbox that will be inserted into a database. In this app, text is copied and pasted into a textbox from various sources, and sometimes contains the funky curly quotes and apostrophes which end up being dropped on the database insert. I'm not sure if the issue resides in my asp.net code or in the database itself (SQL 2000). Thanks for any help.
When doing an insert into the db - use a paramaterized query.
Bobby Ryzhy
bobby @ domain below http://weekendtech.net
I am using a paramaterized query on the insert... any other suggestions?
Thanks.
"Bobby Ryzhy" <bo***@weekendtech.net> wrote in message
news:cb********************************@4ax.com... On Wed, 04 Aug 2004 15:50:50 GMT, "anony" <no**@m.com> wrote:
Hi,
I'm looking to find out how to properly handle the input of certain characters into a textbox that will be inserted into a database. In this app, text is copied and pasted into a textbox from various sources, and sometimes contains the funky curly quotes and apostrophes which end up
beingdropped on the database insert. I'm not sure if the issue resides in my asp.net code or in the database itself (SQL 2000). Thanks for any help.
When doing an insert into the db - use a paramaterized query. Bobby Ryzhy bobby @ domain below http://weekendtech.net
On Thu, 05 Aug 2004 14:03:45 GMT, "anony" <no**@m.com> wrote: I am using a paramaterized query on the insert... any other suggestions?
Thanks.
"Bobby Ryzhy" <bo***@weekendtech.net> wrote in message news:cb********************************@4ax.com.. . On Wed, 04 Aug 2004 15:50:50 GMT, "anony" <no**@m.com> wrote:
>Hi, > >I'm looking to find out how to properly handle the input of certain >characters into a textbox that will be inserted into a database. In this >app, text is copied and pasted into a textbox from various sources, and >sometimes contains the funky curly quotes and apostrophes which end upbeing >dropped on the database insert. I'm not sure if the issue resides in my >asp.net code or in the database itself (SQL 2000). Thanks for any help. >
When doing an insert into the db - use a paramaterized query. Bobby Ryzhy bobby @ domain below http://weekendtech.net
if you are using a parameterized query to insert - it will maintain all integrity of the charachters.
Bobby Ryzhy
bobby @ domain below http://weekendtech.net
It must be on the database end then. I'm using SQL Server 2000, and the
textbox.txt is going into a text field. Things like curly quotes and the
"sharp" apostrophe are getting dropped on insert.
"Bobby Ryzhy" <bo***@weekendtech.net> wrote in message
news:tj********************************@4ax.com... On Thu, 05 Aug 2004 14:03:45 GMT, "anony" <no**@m.com> wrote:
I am using a paramaterized query on the insert... any other suggestions?
Thanks.
"Bobby Ryzhy" <bo***@weekendtech.net> wrote in message news:cb********************************@4ax.com.. . On Wed, 04 Aug 2004 15:50:50 GMT, "anony" <no**@m.com> wrote:
>Hi, > >I'm looking to find out how to properly handle the input of certain >characters into a textbox that will be inserted into a database. In
this >app, text is copied and pasted into a textbox from various sources,
and >sometimes contains the funky curly quotes and apostrophes which end upbeing >dropped on the database insert. I'm not sure if the issue resides in
my >asp.net code or in the database itself (SQL 2000). Thanks for any
help. >
When doing an insert into the db - use a paramaterized query. Bobby Ryzhy bobby @ domain below http://weekendtech.net
if you are using a parameterized query to insert - it will maintain all
integrity of the charachters.
Bobby Ryzhy bobby @ domain below http://weekendtech.net This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Albretch |
last post by:
I am trying to insert some textual data belonging to an HTML page into
a table column with 'TEXT' as data type
mysql's maual _/manual.html#String_types tell you, you may insert up
to (2^16 - 1),...
|
by: User |
last post by:
I am trying to use JDOM's SAXBuilder to parse an XML document that contains
encoded latin-1 characters. After I parse the document, the special
character Strings seem to be replaced with their...
|
by: TTroy |
last post by:
Hello, I'm relatively new to C and have gone through more than 4 books
on it. None mentioned anything about integral promotion, arithmetic
conversion, value preserving and unsigned preserving. ...
|
by: anony |
last post by:
Hello,
I can't figure out why my parameterized query from an ASP.NET page is
dropping "special" characters such as accented quotes & apostrophes, the
registered trademark symbol, etc. These...
|
by: rlueneberg |
last post by:
I am having difficulty with preserving field values in a DetailsView
control after clicking the insert button event.
protected void DetailsView1_ItemInserted(object sender,...
|
by: Naveen |
last post by:
I am trying to write a conatiner which has std::map like methods but
preserves the order of insertion.
TO achieve this I thought of providing my own function for comparing
the keys of the map....
|
by: Clive Green |
last post by:
Hello peeps,
I am using PHP 5.2.2 together with MP3_Id (a PEAR module for reading and
writing MP3 tags). I have been using PHP on the command line (Mac OS X
Unix shell, to be precise), and am...
|
by: TheRealDan |
last post by:
Hi all.
I'm having a problem with a special characters.
I have php script that reads from an xml file and writes to a mysql db.
It's a script called phptunest that I found on the net, although the...
|
by: sophia.agnes |
last post by:
Dear all,
I was going through the book "C a software engineering approach by
darnell & Margolis" there was a section named sign preserving vs value
preserving
it is as follows
sign...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
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
| |