November 22, 2008 11:10am pst

1. jpaulino 1,119,455
2. TheLearn... 887,195
3. Idle_Mind 685,642
4. VBRocks 489,091
5. Dhaest 423,831
6. Fernando... 405,428
7. jaime_oliv... 401,274
8. Sancler 373,508
9. PaulHews 365,507
10. emoreau 345,526
11. webtubbs 312,204
12. CodeCruiser 279,173
13. jcoehoorn 264,456
14. angelIII 254,462
15. mlmcc 190,907
16. rachitkohli 188,104
17. vb_jonas 183,591
18. GreenGho... 168,411
19. graye 157,820
20. armoghan 145,665
21. TimCottee 135,200
22. Priest04 120,354
23. AkisC 116,655
24. prairiedog 108,567
25. mwvisa1 107,640

1. TheLearn... 4,341,678
2. Idle_Mind 3,762,794
3. Sancler 2,354,988
4. Fernando... 2,155,878
5. jpaulino 1,468,822
6. emoreau 1,160,849
7. RonaldBie... 1,159,695
8. VBRocks 1,044,272
9. iboutchkine 821,029
10. webtubbs 734,625
11. angelIII 721,169
12. Dhaest 704,026
13. Chaosian 693,334
14. PaulHews 652,548
15. graye 649,700
16. planocz 639,095
17. jaime_oliv... 631,875
18. arif_eqbal 596,164
19. gregoryyo... 596,085
20. vbturbo 489,530
21. ZeonFlash 488,195
22. AlexFM 473,611
23. BriCrowe 435,117
24. armoghan 418,652
25. TimCottee 413,724

07.08.2008 at 07:35PM PDT, ID: 23548945

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.0

VB.NET 2005 Replace function not replacing Single Quote with BackSlash Single Quote

Asked by TedPalmer in Microsoft Visual Basic.Net

Tags: Microsoft, Visual Basic 2005 (VS2005), 2005, OS = Windows XP SP2; RDBMS = MySQL

My OS is Windows XP SP2 and my IDE is Visual Studio 2005. My program is written in VB.NET 2005. My RDBMS is MySQL version 5.0.45

Context: I have been working on this program for about 2 years now so I have lots of experience writing dynamic SQL that successfully interfaces with MySQL. The commented out code
'Return Chr(39) & Input.Replace("'"c, "\'") & Chr(39)
was written about one year 5 months ago and was working just fine in VB.NET 2003. I upgraded to VB.NET 2005 last January and have not rigerously tested this function, FixSingleQuote1, since then. It just seemed to work when I used it till today when I happen to stress it a little harder. The commented line of code was provided to me by another EE Expert and was the only line of code in the whole function till today. He said it used Regular Expression syntax which I was not familiar with at the time, but I made up some rigorious test cases and it worked without any problems. I took him at his word and I still do. I confess I never really understood how it worked, but since it did, I didn't question it. I just used it and was glad for a freebee that solved a problem for which I had a much less elegent solution that only worked when there was just one single quote in the input text string.

Today I copied and pasted from a webpage some biographical data on one of the US Supreme Court Justices that I was using as test data. It had a few single quotes in it that caused MySQL to return an error message saying my SQL syntax had an error in it. Maybe this was the first time since converting to VB.NET 2005 that I have actually tried to enter any text that had single quotes in it.

I am just trying to convert all occurances of a string of length one from a single quote character to a two character string of backslash single quote and return the whole string delimited by single quote characters, The help gives the following example:

Dim TestString As String = "Shopping List"
' Returns "Shipping List".
Dim aString As String = Replace(TestString, "o", "i")

This looks like a very simple function to use. In debug I can step through the code and see the single quote characters in my Input string. I can execute the assignment statement and look at the Output string. Nothing has changed. The single quotes are still there without the backslash character preceding them. Char(92) = ASCII backslash character and Char(39) is the single quote character.

This is so simple I can't see where I am doing anything wrong. If I am wrong, I'm not too proud to admit it. If this is a known bug in VB.NET 2005, is there a commonly used work around?

Thank you,
Ted Palmer
www.tedpalmer.com Start Free Trial

         
           
           
             Public Function FixSingleQuote1(ByVal Input As String) As String
        Dim oldSingleQuote As String = "'"
        'Dim newSingleQuote As String = "\'"
        Dim newSingleQuote As String = Chr(92) & "'"
        Dim Output As String = ""
        'Return Chr(39) & Input.Replace("'"c, "\'") & Chr(39)
        'Return Chr(39) & Input.Replace("'"c, "''") & Chr(39)
        Output = Chr(39) & Replace(Input, oldSingleQuote,newSingleQuote) & Chr(39) '<-- As of 2008-07-08 by Ted Palmer
        Return Output '<-- As of 2008-07-08 by Ted Palmer
    End Function 'FixSingleQuote1

           
         

Keywords: VB.NET 2005 Replace function not…

	Title
1	VB.NET
2	How can i a make shopping basket in a…
3	Connecting from VB.NET to MySQL
4	adding bpay with vb.net
5	VB.NET and MySQL
6	MySQL Connection for VB.Net

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

VB.NET 2005 Replace function not replacing Single Quote with BackSlash Single Quote

Asked by TedPalmer in Microsoft Visual Basic.Net

Tags: Microsoft, Visual Basic 2005 (VS2005), 2005, OS = Windows XP SP2; RDBMS = MySQL

About this solution