Posts

MySQL Unknown Column Error 1054 Simple Update -

using mysql workbench, i'm getting odd behavior when attempting execute following statement: update jobs set customer = 'ben' po = 1011; the output of is: error code: 1054. unknown column 'jobs.po' in 'where clause' the goal here update statement, or equivalent, execute. can't determine issue. what's particularly odd following statements: select * jobs; select po jobs; select * jobs po = 1011; select po jobs po = 1011; all function expected. specifically, no errors, returns , displays entries asked for. why might select execute without 1054 error when update can't? the create table statement (if it's helpful), executed sql script through workbench: create table `jobs` ( po mediumint not null, part tinyint unsigned not null default 1, `last dash` smallint unsigned not null default 0, customer varchar(80), description varchar(350), completed date, notes varchar(350), constraint pkjobs primary...

calculate Cookie Size in PHP -

i wanted read cookie , calculate length on server side using php, can't find direct method so. how achieve task ? what ? setcookie("user", "dino babu kannampuzha", time() + 3600); if (isset($_cookie["user"])) { $data = $_cookie["user"]; $serialized_data = serialize($data); $size = strlen($serialized_data); echo 'length : ' . strlen($data); echo "<br/>"; echo 'size : ' . ($size * 8 / 1024) . ' kb'; } // output length : 21 size : 0.232 kb

parse.com - Migrate from parse to backendless -

i want install backendless terminal in ubuntu 14.04 server @ home , don't have clue. after migrating parse backendless, need change parse client sdk ? thank you. i think might have few misconceptions. backendless mbaas parse, not iaas as heroku & mongodblabs together. stated parse server migration steps , heroku hosts parse-server source via nodejs, , points mongodb instance via config vars. however, can migrate parse baas endless utilizing export/import of tables , objects. if migrating backendless, need conform api/sdk. means rewriting code work them. if wish continue using parse api/sdk, need create server running nodejs express run parse-server, , link mongodb instance via heroku config vars connection using driver via standard mongodb uri. however, parse-server limited in scope @ point. may time before sorted out. why parse suggest setting local instance develop on, migrating hosted version before jumping in. things login authentication have issues , ...

iphone - iTunes sync apps failed to install using Phonegap -

i have created .ipa file using phonegap. testing uploaded developer certificates , device udid. working fine. now, want distribute apps using application loader. uploaded apple distributor certificate , distribute mobile provision file on phonegap cloud , generated .ipa file. when tried apps iphone 6.3.1, giving me error: itunes sync apps failed install please me out of problem.. are trying submit app (you mentioned application loader used submitting apps) or install on devices testing? assuming trying install on devices testing. if app fails install, check 1 of these the mobileprovision using has device's udid. test apps can installed on devices udid included in mobileprovision (unless distributing enterprises) the mobileprovision installed on device (try using service testflight - you'll know whether device has necessary setup)

PHP PDO / Retrieving OUT Parameters from MySQL Stored Procedure -

i need retrieve out parameters mysql stored procedure. can't find explains (and makes sense me). try { $dsn = 'mysql:dbname=db_name;host=localhost'; $dbh = new pdo($dsn, 'usr_name', 'password'); } catch (pdoexception $e) { echo 'connection failed: ' . $e->getmessage(); } $stmt = $dbh->prepare("call db.stprnewuser(:usremail,:newuserok,:stprcomment)"); $stmt->bindparam(':usremail', $tmpemail, pdo::param_str); $stmt->bindparam(':newuserok', $newuserok, pdo::param_int,1); $stmt->bindparam(':stprcomment', $stprcomment, pdo::param_str,100); $stmt->execute(); $outputarray = $dbh->query("select @newuserok, @stprcomment")->fetch(pdo::fetch_assoc); print "procedure returned [" . $outputarray['@newuserok'] . $outputarray['@stprcomment'] . "]\n"; i found last 2 lines on item, returns null values. try this... see if works... try { ...

javascript - Parse string and loop angularjs -

i take string in format this: "something example $takethis $takethisalso". want parse string , list of strings have $ ($xxx). this: foreach($xxx in list) { var field = xxx; // here want field have value takethis // field } so best practice in angular. use old plain javascript or maybe have angular. sounds want filter function on angular, can accept predicate https://docs.angularjs.org/api/ng/filter/filter

java - How to start drawable animation after click ImageView? -

i have problem. want make drawable animation after click "imageview". found answer question , didn't find. my code looks like: import java.util.locale; import android.app.activity; import android.graphics.drawable.animationdrawable; import android.os.bundle; import android.speech.tts.texttospeech; import android.util.log; import android.view.motionevent; import android.view.view; import android.widget.button; import android.widget.edittext; import android.widget.imageview; public class talking extends activity implements texttospeech.oninitlistener { private texttospeech tts; private button button1; private edittext edittext1; private animationdrawable penguinanimation; @override protected void oncreate(bundle savedinstancestate) { // todo auto-generated method stub super.oncreate(savedinstancestate); setcontentview(r.layout.talking); tts = new texttospeech(this, this); button1 =...