Inserting text and special characters

I just need someone to talk me through/ explain how to insert and then display special characters into an MSSQL2000 database.

I have a form with a textarea which submits to a new page, thie new page should display the form data *exactly* as it was entered in the form, including returns, double quotes, < and >, and any special character.

This display page will then submit this [url removed, login to view]("varfromtextarea") to a new page which inserts the form data to as a parametere to a stored procedure. I *dont* need the forms, commands, or stored procedures coded. I ONLY need someone with experience to explain what i have to do to the form data to 1) display the form data (with special characters) on the page proceeding the form and 2) explain how to insert this form data into the database (i.e. do i use [url removed, login to view] or some replace function(s)) and 3) How do i display this data from the database while preserving all special characters (i know how to display data from a database using asp, the problem i am having is displaying special characters).

e.g. I have a form textarea in which i input

<test input>

"test input"

test input

'test input'

<%test input%>

etc etc etc

This form data is displayed on the following page exactly as input in the textarea.(Do i use [url removed, login to view] to display it, or combine with Replace())

So how do insert this into the database and then display the database field from another asp page while preserving all special characters.

I would also appreciate some code or ideas (maybe functions) to prevent any malicious input at the same time (maybe from sql injection).

Any questions, please email.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

Windows, IIS, ASP, VBScript.

Habilidades: ASP, Engenharia, Microsoft, MySQL, PHP, Arquitetura de software, Teste de Software, SQL, Tradução, Área de trabalho do Windows

Veja mais: sql injection test, sql commands, new characters, characters, textarea complete, vbscript php, function stored procedure, sql stored function, stored procedure function, request text, vbscript installation, special software, asp code injection, test vbscript, text sql, character problem, windows iis asp, php vbscript, asp insert data, combine forms, run program vbscript, php double submit, data test forms, asp replace, text test questions

Acerca do Empregador:
( 6 comentários ) United Kingdom

ID do Projeto: #2968568

Concedido a:


See private message.

$12 USD em 14 dias
(1298 Comentários)

2 freelancers estão ofertando em média $9 para esse trabalho


See private message.

$5.1 USD in 14 dias
(54 Comentários)