Insert Query for HTML string in SQL

Question

I have Sql database with table name QUESTION.

I want to insert value for QuestionTitle as html string. Insert query is

INSERT INTO 
   QUESTION (QuestionType,QuestionID,QuestionTitle) 
VALUES ("MRQ",
        "QNB5T6TKDMS",
        "<p><span style="font-family: comic sans ms,sans-serif; font-size: 
small;">what was the original concentration of the acid?</span></p>")

When I try to execute this query in Sql it gives an error . How can I do this so that it will work for html string.

it give error as:[ near "font": syntax error ] Exception Name: NS_ERROR_FAILURE — pallavi_ios
– pallavi_ios, Commented Jun 26, 2014 at 6:31
You might want to check this question : Preventing SQL Injection in ASP.Net VB.Net : stackoverflow.com/questions/4018174/… — naota
– naota, Commented Jun 26, 2014 at 6:37
is it complusary to replace " with ' in insert statement at time of insert html value — pallavi_ios
– pallavi_ios, Commented Jun 26, 2014 at 6:38
@pallavi_ios check it once again.I have edited answer.we can use any type of quotes — Techy
– Techy, Commented Jun 26, 2014 at 6:40

Charlesliam · Accepted Answer · 2014-06-26 06:44:01Z

4

You have error in using " inside the third inserted value

INSERT INTO 
   QUESTION (QuestionType,QuestionID,QuestionTitle) 
VALUES ('MRQ',
        'QNB5T6TKDMS',
        '<p><span style="font-family: comic sans ms,sans-serif; font-size: small;">
         what was the original concentration of the acid?</span></p>'
       );

You can also use escape slashes

edited Jun 26, 2014 at 6:44

Charlesliam

1,3133 gold badges20 silver badges37 bronze badges

answered Jun 26, 2014 at 6:33

Techy

2,6547 gold badges47 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

pallavi_ios Over a year ago

is it complusary to replace " with ' in insert statement

Ullas Over a year ago

Yes.. You have to do that

Ankit Bajpai · Accepted Answer · 2014-06-26 06:37:50Z

0

Try somthiung like this:-

INSERT INTO QUESTION (QuestionType,QuestionID,QuestionTitle) VALUES 
('MRQ','QNB5T6TKDMS','<p><span style="font-family: comic sans ms,sans-serif; font-size: 
small;">what was the original concentration of the acid?</span></p>');

Hope this helps you.

answered Jun 26, 2014 at 6:37

Ankit Bajpai

13.6k4 gold badges27 silver badges43 bronze badges

Collectives™ on Stack Overflow

Insert Query for HTML string in SQL

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related