Comments by SanjeevJayaram

SanjeevJayaram 1-Aug-13 0:56am View

Thanks bro it works.

SanjeevJayaram 29-Jul-13 8:26am View

I am able to pass values to another html page to another and also image. But my problem is how to pass both at the same time.(ie) by clicking one button.

SanjeevJayaram 10-Jul-13 8:36am View

What is the error are u getting.

SanjeevJayaram 2-Jul-13 3:16am View

i didn't reset and finalize the query properly. Now i got it. Next time i will post the question with code :). And thanks for your advise bro :)

SanjeevJayaram 2-Jul-13 3:10am View

Actually i tried to send mail through simulator so i didn't get mail. i tried in device and now it works.
I indent the code next time and thanks for your advice :)

SanjeevJayaram 6-Jun-13 0:49am View

i tried single = in where clause but still the same error occurs.

"Failed to execute the query 5"

SanjeevJayaram 16-May-13 3:16am View

- (IBAction)deletedata:(id)sender {
NSArray *data1 = [[DBManager getSharedInstance]deletebyregisterno: findByRegisterNumberTextField.text];
if (data1 == nil) {
UIAlertView *alert = [[UIAlertView alloc]initWithTitle:
@"Data not found" message:nil delegate:nil cancelButtonTitle:
@"OK" otherButtonTitles:nil];
[alert show];
}
else
{
NSLog(@"delete success");

}
}
-(NSArray*) deletebyregisterno:(NSString*)registerNumber
{
NSLog(@"here");

const char *dbpath = [databasePath UTF8String];
if (sqlite3_open(dbpath, &database) == SQLITE_OK)
{
NSLog(@"here inside");

NSString *querySQL1 = [NSString stringWithFormat:@"delete from studentDetail where regno=\"%@\"",registerNumber];
const char *querySQL1_stat = [querySQL1 UTF8String];
if (sqlite3_prepare_v2(database, querySQL1_stat,-1, &statement, NULL)== SQLITE_OK)
{
if (sqlite3_step(statement) == SQLITE_DONE)
{
return YES;
NSLog(@"Deleted row");
}
}
else {
return NO;
}
sqlite3_reset(statement);
}
return nil;

}

whats wrong in this . it displays no data found? plz help me

SanjeevJayaram 13-May-13 8:41am View

i need the code for deletion of tabledata for this table "create table if not exists studentsDetail (regno integer primary key, name text, department text, year text)" with regno as id

Comments by SanjeevJayaram (Top 8 by date)