tags:

views:

38

answers:

2

this is the output i want "SELECT * FROM wateat_tbl where name like '%love%' or desc like '%love%'";

where *love is a text enterted by use*r now i want to write this in effective way right now i am doing this lame code

    myStringPrt1=@"SELECT * FROM wateat_tbl where name like '%"

    NSString *trimmedString1 = [myStringPrt1 stringByTrimmingCharactersInSet:
                                [NSCharacterSet whitespaceAndNewlineCharacterSet]];

    myStringPrt2=UserText;// user input LOVE
    NSString *myStringPrt3=@"%' or desc like '%";
    NSString *myStringPrt4=@"%'";


    trimmedString1=[trimmedString1 stringByAppendingString:myStringPrt2];

    trimmedString1=[ trimmedString1 stringByAppendingString:myStringPrt3];
    trimmedString1=[ trimmedString1 stringByAppendingString:myStringPrt2];
    trimmedString1=[ trimmedString1 stringByAppendingString:myStringPrt4];
    NSLog(@"My string is  now =  %@", trimmedString1);
A: 

NSString* SQL_statement = [NSString stringWithFormat:@"SELECT * FROM wateat_tbl where name like '%@%%' or desc like '%%%@'", UserText, UserText]; 
ULysses
nope this is your outputSELECT * FROM wateat_tbl where name like 'SELECT * FROM wateat_tbl where name like '%' or desc like '%SELECT * FROM wateat_tbl where name like 'SELECT * FROM wateat_tbl where name like '%' or desc like '%'
ram
still i am getting something :)
ram
i have to add "" also to make query complete "SELECT * FROM wateat_tbl where name like '%love%' or desc like '%love%'"
ram
well then do not use `UserText`, this seems to be a property. Use the `myStringPrt2` instead. Will give you `NSString* SQL_statement = [NSString stringWithFormat:@"SELECT * FROM wateat_tbl where name like '%@%%' or desc like '%%%@'", myStringPtr2, myStringPtr2];`
ULysses
not working :( plz se
ram
perfect hoew about adding " in begining and at end "
ram
i cant add " at begining and " at end of this string
ram
c'mon, it's just like this `"\"qoted\""`
ULysses
am very close but its not working@"""SELECT * FROM wateat_tbl where name like '%%%@%%' or desc like '%%%@%%'", myStringPrt2, myStringPrt2]; i am out of mind :(
ram
const char *sqlStatement = SQL_statement;
ram
are you reading my comments? you have to escape the double quote to put it inside a string.`@"\"SELECT * FROM wateat_tbl where name like '%%%@%%' or desc like '%%%@%%'\""`
ULysses
u really help me thanks a lot but stil i dont knw why my query is not working andy way you did your best :-)const char *sqlStatement = SQL_statement;//"SELECT * FROM wateat_tbl where name like '%love%' or desc like '%love%' ";
ram
is that because char to string??
ram
`const char *sqlStatement = [SQL_statement UTF8String];`
ULysses
amazing you saved my life one beer to you and hats of you are wonderfull :-) i am glad i have no words for you keep this spirit to help others :-) have a nice day
ram
let me suggest that you mark the post as an answer, will do for a beer ;)
ULysses
A: 

you did it thanks :-)

ram