Dying to solve this problem :-( "SINGLE QUOTATION"

Question

Post reply

Dying to solve this problem :-( "SINGLE QUOTATION"

Ahmed_07

Valued Member

Points: 73
More actions
October 6, 2012 at 4:22 pm

#263647

it's only about ( SINGLE QUOTATION) in ASP.NET
here is my SQL Query:
SELECT ID, Title
FROM viewTopTitles
WHERE Title = ' you're most welcome '
but duo to the SINGLE QUOTATION I have a fatal Error, I tried to use function like this:
WHERE REPLACE("you're most welcome", " ' ", " ' ' ")...
Error I get with this is :
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near ')'.
and thene tried like this :
WHERE Title = REPLACE("you're most welcome", " ' ", " ' ' ")...
Error I get with this is :
Msg 207, Level 16, State 1, Line 3
IS THERE ANY BODY CAN GIVE ME A FULL EX. OF THE QUERY, OR TELLS ME HOW APPROPRIATE SHOULD I'VE TO USE THIS;
THANK YOU
PS: I AM KINDDA NEW TO THIS :ermm:

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

imex Ten Centuries Points: 1234 More actions · Answer 1

Try:

WHERE Title = 'you''re most welcome'

Hope this helps.

https://www.imoveisemexposicao.com.br/imobiliarias-em-guarulhos

Ahmed_07 Valued Member Points: 73 More actions · Answer 2

thanks imex

but it would work in Query Engine in SQL Server but as in my case am in ASP.NET and can't fix with this all the links (Titles) that contain SINGLE QUOTATIONS

so how could I avoid the error dynamically ????? :ermm:

Ahmed_07 Valued Member Points: 73 More actions · Answer 3

I found it 🙂

here is the solution

public string mySTRING (string singleQ){

return singleQ.Replace(" ' ", " ' ' ");

}

SELECT ID, Title

FROM viewTopTitles

WHERE Title = mySTRING (you're most welcome)

SOURCE : http://www.sqlfr.com/forum/sujet-PROBLEME-AVEC-APOSTROPHE_1349006.aspx

info : the forum is in French lang but you should see the full code there probably understand 🙂

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 4

Ahmed_07 (10/7/2012)
I found it 🙂
here is the solution
public string mySTRING (string singleQ){
return singleQ.Replace(" ' ", " ' ' ");
}
SELECT ID, Title
FROM viewTopTitles
WHERE Title = mySTRING (you're most welcome)
SOURCE : http://www.sqlfr.com/forum/sujet-PROBLEME-AVEC-APOSTROPHE_1349006.aspx
info : the forum is in French lang but you should see the full code there probably understand 🙂

If you run that result query you posted, I'm pretty sure you'll find that it doesn't actually work. The single quote needs to have two single quotes and the whole string literal needs to be wrapped in single quotes.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ahmed_07 Valued Member Points: 73 More actions · Answer 5

you're right, it's just that I didn't mentioned or write it in here, but I did wrap it with a single quotation to the whole string 🙂

thank you 🙂

Sean Lange SSC Guru Points: 286590 More actions · Answer 6

Or for an even better approach don't use pass through sql from your .NET app. Instead use parameters. From the issues you are facing it is very likely that your application is vulnerable to sql injection.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Scott D. Jacobson SSCertifiable Points: 6149 More actions · Answer 7

Scott D. Jacobson

SSCertifiable

Points: 6149

October 8, 2012 at 10:12 am

#1546824

Obligatory: http://xkcd.com/327/[/url]

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 8

Scott D. Jacobson (10/8/2012)
Obligatory: http://xkcd.com/327/[/url]

+1000 Absolutely agreed!

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ahmed_07 Valued Member Points: 73 More actions · Answer 9

okey 🙂 thankx for the advice 'll think doing so