mike55 Posted April 14, 2004 Posted April 14, 2004 Yo, Anyone know how to deal with the apostrophise character (hope its spelt correctly, its the character on the same key as the @ sign) when passing data containing one into SQL Server?? Mike55 Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
Joe Mamma Posted April 14, 2004 Posted April 14, 2004 Yo, Anyone know how to deal with the apostrophise character (hope its spelt correctly, its the character on the same key as the @ sign) when passing data containing one into SQL Server?? Mike55 @ is on the 2 key on my computer. . . are you talking about the single quote character? use two single quotes Quote Joe Mamma Amendment 4: The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no warrants shall issue, but upon probable cause, supported by oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized. Amendment 9: The enumeration in the Constitution, of certain rights, shall not be construed to deny or disparage others retained by the people.
Moderators Robby Posted April 14, 2004 Moderators Posted April 14, 2004 In other word Replace all single quotes with two single quotes. s = s.replace("'","''") Quote Visit...Bassic Software
Joe Mamma Posted April 14, 2004 Posted April 14, 2004 In other word Replace all single quotes with two single quotes. s = s.replace("'","''") yep . . . Now if you parameterize your queries, this isnt an issue USE PARAMETERS WHERE EVER POSSIBLE!!! Quote Joe Mamma Amendment 4: The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no warrants shall issue, but upon probable cause, supported by oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized. Amendment 9: The enumeration in the Constitution, of certain rights, shall not be construed to deny or disparage others retained by the people.
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.