Replace Function Query

rsm42 · August 3rd, 2007, 05:30 AM

Hi,

Using asp.net 1.1 and vb.net I have a form that a user updates and their details are written to a database. One validation check I want to add is to ensure any quotation marks are removed from the entry before this is written to the database.

Within the Submit button sub procedure that updates the data into the database I have used the following coded examples :

1. txtInput.Text.Replace("'", "''")

OR

2. txtInput.Text = txtInput.Text.Replace("'", "''")

However these are not removing the quotation marks. No error is produced but the quotation marks are entered into the database. Any ideas why this is not working. Here's where I'm using the code :

Code:

Sub btnSubmit_Click(sender As Object, e As EventArgs)

    'txtInput.Text.Replace("'", "''") - 1st attempt
    txtInput.Text = txtInput.Text.Replace("'", "''") - 2nd attempt

   'Calls function to update database 
   UpdateDB(txtInput.Text)

    'Confirmation message
    Response.Write("Details submitted - thanks")

End Sub

dparsons · August 3rd, 2007, 11:38 AM

Try this:
txtInput.Text = txtInput.Text.Replace("'", "#39;")

What I imagine is happening is that since you are escaping the apostorphe ('') so it can be inserted into SQL that you are only seeing the one apostorphe in your table. The ascii code above will generate an apostorphe when the page is rendered by the browser.

hth

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========

rsm42 · August 4th, 2007, 04:59 AM

Thanks

However this is still not working. Whenever an entry is inputted with quotation marks e.g. "myentry" the database records the value with the quotation marks i.e. "myentry". Basically I want it to remove the quotation marks leaving just myentry.

Any ideas ? Here's the code I've used to date which does seem to look ok ? Also I'm using an access database.

Code:

Sub btnSubmit_Click(sender As Object, e As EventArgs)

       'txtInput.Text.Replace("'", "''")
       'txtInput.Text = txtInput.Text.Replace("'", "''")
        'txtInput.Text = txtInput.Text.Replace("'", "")

                  txtInput.Text = txtInput.Text.Replace("'", "")

        UpdateDB(txtInput.Text)

        Response.Write("Details submitted - thanks")

    End Sub

gaurav_jain2403 · August 4th, 2007, 05:07 AM

Change the code to:

Sub btnSubmit_Click(sender As Object, e As EventArgs)
                  txtInput.Text = txtInput.Text.Replace("\"", "")

        UpdateDB(txtInput.Text)

        Response.Write("Details submitted - thanks")

    End Sub

rsm42 · August 4th, 2007, 05:29 AM

Thanks

In the end the following line of code worked :

txtPassword.Text = txtPassword.Text.Replace("""","")

Thanks