Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>In order to render my comment more precisely:</p> <p>Your code looks <em>almost</em> correct, but there are a few issues:</p> <p>First, a "boundary-delimiter" MUST be preceded by a CRLF. And, conceptually, this preceding CRLF belongs to the "boundary-delimiter.</p> <p>Second, a "Content-Type" header for parameters won't hurt.</p> <p>Thus, I would suggest to change the following from</p> <pre><code>// add params (all params are strings) for (NSString *param in _params) { [body appendData:[[NSString stringWithFormat:@"--%@\r\n",boundary] dataUsingEncoding:NSUTF8StringEncoding]]; [body appendData:[[NSString stringWithFormat:@"Content-Disposition: form-data; name=\"%@\"\r\n\r\n", param] dataUsingEncoding:NSUTF8StringEncoding]]; [body appendData:[[NSString stringWithFormat:@"%@\r\n", [_params objectForKey:param]] dataUsingEncoding:NSUTF8StringEncoding]]; } </code></pre> <p>to </p> <pre><code>// add params (all params are strings) for (NSString *param in _params) { [body appendData:[[NSString stringWithFormat:@"\r\n--%@\r\n",boundary] dataUsingEncoding:NSUTF8StringEncoding]]; [body appendData:[[NSString stringWithFormat:@"Content-Disposition: form-data; name=\"%@\"\r\n", param] dataUsingEncoding:NSUTF8StringEncoding]]; [body appendBytes:"Content-Type: text/plain; charset=utf-8\r\n" length:41]; // (other headers if any) // close headers with CRLF: [body appendBytes:"\r\n" length:2]; // param value: [body appendData:[[NSString stringWithFormat:@"%@", [_params objectForKey:param]] dataUsingEncoding:NSUTF8StringEncoding]]; } </code></pre> <p>Forth, you should not append a CRLF to binary data! When outputting a part which contains binary data, follow the above lines: as you can see, there is no closing CRLF after writing the parameter value to the body part.</p> <p>Hence:</p> <pre><code>if (imageData) { [body appendData:[[NSString stringWithFormat:@"\r\n--%@\r\n", boundary] dataUsingEncoding:NSUTF8StringEncoding]]; [body appendData:[[NSString stringWithFormat:@"Content-Disposition: form-data; name=\"%@\"; filename=\"harryimg1.png\"\r\n",FileParamConstant] dataUsingEncoding:NSUTF8StringEncoding]]; [body appendData:[@"Content-Type: image/jpeg\r\n\r\n" dataUsingEncoding:NSUTF8StringEncoding]]; [body appendData:[NSData dataWithData:imageData]]; } </code></pre> <p>Furthermore, you omitted the "close-boundary-delimiter:</p> <p>After the last part, add the following:</p> <pre><code>[body appendData:[[NSString stringWithFormat:@"\r\n--%@--", boundary] dataUsingEncoding:NSUTF8StringEncoding]]; </code></pre> <p>A last CRLF is not required, but won't hurt also.</p> <h3>Edit</h3> <p>Further notes:</p> <p>It's not recommended to use <code>NSURLConnection</code>'s convenient class method sendSynchronousRequest: when sending large data. You are better of implementing NSURLConnection delegates which lets you cancel the request, when something goes wrong, and also gives more control.</p> <p>Furthermore, this approach uses a <code>NSData</code> as the request body of the multipart/form-data message. This requires that the while body must fit into memory. This can lead to memory issues. A more robust approach would utilize a input stream as request body, but this implementation is much more complex (really MUCH more).</p> <p>iOS 7 has a new API where it should be more easy to transmit large files. Please consult the documentation of <code>NSURLSession</code> and <code>NSURLSessionUploadTask</code>.</p>
    singulars
    1. This table or related slice is empty.
    1. POImage post to Server with data json not working ios
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCouchDeveloper
    1. USCouchDeveloper
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    1. COI would like to know why people down vote this. Obviously it didn't work for you? If so, please tell what's your issue! Please note that composing a multipart message "by hand" is quite error prone. Show your code if you have issues.
      singulars
      1. PO
      1. USCouchDeveloper
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload