objective c - How to recieve data of a group by sqlite query in iOS ? -


i want data of group query , load them textfields. here table integer id name text duration real time real there few names in in name column tried calling method each name , caused insert failure.

i want receive query , load result on specific label: dont know how can response 

select  name,sum (time)  cost group name;

there current code

 nsstring *docsdir; nsarray *dirpaths;   double totaltime = 1.0;  // documents directory dirpaths = nssearchpathfordirectoriesindomains(nsdocumentdirectory, nsuserdomainmask, yes); docsdir = dirpaths[0];  // build path database file databasepath = [[nsstring alloc]                 initwithstring: [docsdir stringbyappendingpathcomponent:                                  @"database.db"]];   nsstring *querystring=@"select sum(duration) total records"; sqlite3_stmt    *statement;  if(sqlite3_open([databasepath utf8string], &mydatabase) == sqlite_ok) {      if(sqlite3_prepare_v2(mydatabase, [querystring utf8string], -1, &statement, nil) == sqlite_ok){         while (sqlite3_step(statement) == sqlite_row) {              totaltime =  sqlite3_column_double(statement, 0);             nslog(@"the sum  %f ", totaltime);         }     } } integer_t intotal=totaltime; nsstring* total=[nsstring stringwithformat:@"%d min",intotal]; totaltimefield.text=total;

this covered pretty nicely in documentation, but, in short, once update sql have 2 columns:

const unsigned char* name = sqlite3_column_text(statement, 0); double totaltime =  sqlite3_column_double(statement, 1); nslog(@"the sum %s  %f ", name, totaltime);

the second parameter int sqlite3_column_x functions column number.


Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

c# - Resource not found error -

i have problem accessing method on homecontroller. show code of method : [httpget] public actionresult decriptidentifiantetredirige(string login_crypter, string mdp_crypter) { string loginacrypter = _globalmanager.protegemotdepasse(login_crypter); string mdpacrypter = _globalmanager.protegemotdepasse(mdp_crypter); user userapp = new models.user(login_crypter, mdp_crypter); if (userapp.authentificationvalidee(userapp.userlogin, userapp.password)) { session["name"] = userapp.userlogin; return redirecttoaction("accueil", "home"); } else { return redirecttoaction("validerauthentification", "home"); } } then in routeconfig.cs wrote route : routes.maproute( name: "authentificationapresdecryptage", url: "{controller}/{action}/{login_crypter}/{mdp_crypter}", defaults: new...
Read more