Inserting a string into another string

Question

I am working on iPhone app. I have the SQL query:

 NSString *myRed = [NSString stringWithFormat: @"%1.4f", slideR.value];

 [self insertData:@"INSERT INTO colour VALUES("+myRed+")"];

It produces syntax error. How to insert a string into string. That approach in Java would have worked. Best regards

P.J · Accepted Answer · 2013-02-02 19:34:47Z

1

Try this :

NSString *myRed = [NSString stringWithFormat: @"%1.4f", slideR.value];

[self insertData:[NSString stringWithFormat:@"INSERT INTO colour VALUES(\"%@\")",myRed]];

If you don't want " then :-

[self insertData:[NSString stringWithFormat:@"INSERT INTO colour VALUES(%@)",myRed]];

Hope it helps you.

answered Feb 2, 2013 at 19:34

P.J

6,5579 gold badges46 silver badges74 bronze badges

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

Comments

AgnosticDev · Accepted Answer · 2013-02-02 19:37:10Z

1

You could try writing your query and your string appended together before hand.

             NSString *str = @"Your values";
             NSString *query = [NSString stringWithFormat:@"INSERT INTO color VALUES(%@)", str];
             [self insertData:query];

answered Feb 2, 2013 at 19:37

AgnosticDev

1,8632 gold badges20 silver badges37 bronze badges

Collectives™ on Stack Overflow

Inserting a string into another string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related