Capturing UITextView data in an NSString
<p><img src="http://i.stack.imgur.com/j7blU.png" alt="alt text">
Hey all,</p>

<p>I am trying to accomplish something very simple yet getting an error and it's driving me nuts.</p>

<p>here is what I am doing:</p>

<p>Function 1: </p>

<pre><code>-(id)initWithText:(NSString *)text1 :(NSString *)text2 :(NSString *)text3 :(NSString *)text4 :(NSString *)text5

{
</code></pre>

<p>here I do the assignment. I have not initialized the NSString date, projectName, task, duration and comment, but I don't see that causing any trouble.</p>

<pre><code> date=text1;
 projectName=text2;
 task=text3;
 duration=text4;

 if ([text5 isEqualToString:@"Add Comment"]==TRUE || [text5 isEqualToString:@""]==TRUE) 
 {
  comment=@"No Comment";
 }    

 else {
  comment=text5;
 }
</code></pre>

<p>date, duration, task ,projectname, comment are all NSString type.</p>

<p>This function gets called in a different viewController using the statement:</p>

<p>Function1 Call:</p>

<pre><code>[self.summaryViewController initWithText:self.dateDisplay.text :self.projectNameDisplay.text:self.taskDisplay.text:self.durationDisplay.text:commentText.text];
</code></pre>

<p>where dateDisplay, projectNameDisplay, taskDisplay, durationDisplay are all UILabels and commentText is a UITextView</p>

<hr>

<p>now I try to save the values captured through the function into a database using another function.</p>

<p>Function2:</p>

<pre><code>-(void) insertValues:(NSString *)text1 :(NSString *)text2 :(NSString *)text3 :(NSString *)text4 :(NSString *)text5
{

 if([self openDB]==TRUE)

   {
    NSString *sql  = [NSString stringWithFormat:@"INSERT INTO mastertable(_date,_projectName,_task,_duration,_comment,_status) VALUES ('%@','%@','%@','%@','%@','Pending');",text1, text2, text3, text4, text5];

    char *err;

    NSLog(sql);

  if(sqlite3_exec(database,[sql UTF8String], NULL, NULL, &amp;err) !=SQLITE_OK)
   {

    NSAssert(0, @"error inserting values into table");
    sqlite3_close(database);
   }

   else
   {
    NSLog(@"Entry Made");

                sqlite3_close(database);

   }


 }
}
</code></pre>

<p>Function2 call:</p>

<pre><code>[master insertValues:date :projectName :task :duration :comment];
</code></pre>

<p>My insert into table query, when printed in NSLog, throws up this:</p>

<p>INSERT INTO mastertable(_date,_projectName,_task,_duration,_comment,_status) VALUES (' Aug 26, 2010',' Staffing',' Mentoring',' 01:01',</p>

<p>'( > )'</p>

<p>,'Pending');</p>

<p>I think it's because of the conversion of UITextView to NSString</p>

<p>Please help</p>

<p>Sayeed</p>
