iOS Xcode with web service

[Suki.N]

I had a Objective-C program which call a Web-service method to insert data into SQL. But i failed in inserting "&" and "+". Any idea on how i can solve this problem??

 

[jiminaus]

Do you mean data the contains either & or +?

 

[Suki.N]

I try to store user text message into sql. so it could be a single "&" or "&" with other text.

 

[jiminaus]

I'm still not sure I correctly understand your problem. Is the problem that a text message may containing a & or + and that "corrupts" your URL?

For example, you can't send a text message like "You & me + him" because you're producing URLs like the following?

http://myserver/dosomething?msg=You+&+me+++him

 

[z3r0inc]

Can you show us what you're sending? Just put placeholders for the sensitive parts.

 

[Suki.N]

Successful Insert into SQL: http://testing.com/sms_send.asmx/send_sms?SMS=test

Failed Insert into SQL: http://testing.com/sms_send.asmx/send_sms?SMS=+

 

[lefooey]

Failed Insert into SQL: http://testing.com/sms_send.asmx/send_sms?SMS=+

You have to encode your URL query strings.

NSString *unencoded = @"+";
NSString *encoded = [unencoded stringByAddingPercentEscapesUsingEncoding:NSUTF8StringEncoding];

That should point you in the right direction.

 

[chown33]

For a list of characters that must be encoded, see this:
http://en.wikipedia.org/wiki/Percent-encoding

For example, you must encode a literal percent character as %25.

You also ought to know about the application/x-www-form-urlencoded MIME-type.

And since SQL data insertion was mentioned, you should also be aware of little Bobby Tables:
http://xkcd.com/327/

 

[Suki.N]

Thanks crown33.

I able to insert the user input sms into db.

Now the problem is when i input "&&&", the program successfully insert into sql. but when i retrieve the data from sql, it give me "&" only.

Any idea what is going on??

Below is my code:

‎
- (void) downloadingMessages:(NSString *)fromOpp{ 
     NSString *queryString = [NSString
     stringWithFormat:@"http://testing.com/sms_receive.asmx/receive_sms?FromPhone=%@&ToPhone%@",
     fromOpp, fromNumber];
     NSURL *url = [NSURL URLWithString:queryString];
     NSMutableURLRequest *req = [NSMutableURLRequest requestWithURL:url];
     [req addValue:@"text/xml; charset=utf-8" forHTTPHeaderField:@"Content-Type"];
     [req addValue:0 forHTTPHeaderField:@"Content-Length"];
     [req setHTTPMethod:@"GET"];
     NSURLConnection *conn = [[NSURLConnection alloc] initWithRequest:req delegate:self];
     if (conn) {
            webData = [[NSMutableData data] retain];
     }
}