Just want to post a solution to an error I was getting when I was trying to build my Titanium app for Android.
I always got this error
[ERROR] Application Installer abnormal process termination. Process exit value was 1
Turns out I had to set the API version in the tiapp.xml like this where my API version is 17
Hope this helps someone else.
To find the string ‘foo’ inside the array $array and remove it, you can do this.
You don’t need SSH access, just use this command:
mysql -h db.server -u user -p dbname
You’ll need mysql installed on your machine to run it. If you’re on a Mac, you can install mysql through homebrew by typing in terminal:
This can be really handy if you don’t have phpMyAdmin access or your Navicat is acting up.
You can find it here on GitHub
You just have to include the script below your CSS and it handles it all for you. Very handy.
I have a table like this:
This query will figure out which time range the current time fits in. In this case, it figures out if we’re in breakfast-zone or lunch-land.
IF(CURTIME() BETWEEN starttime AND endtime,1,0) AS active
If you’re not used to using BETWEEN, here’s a way using the > and < operators.
IF(CURTIME() >= starttime AND CURTIME() <= endtime,1,0) AS active
This makes a seperate field called active and sets it to 1 if the meal is within the current time, otherwise it’s 0.