Goal: to avoid the event_scheduler stopped after server restart As I realized the events scheduler never working after my server restarted. The why is in the my.ini file. Find the [mysqld] section and put the following line event_scheduler=ON like this. So when the server restarted the event scheduler will be alive again.
8 Jun 2014
mysql event_scheduler after server restart
14:40 |
mysql
|
1117 views
7 Jun 2014
sidebar count with style revisited
11:40 |
wordpress
|
1193 views
Goal: fix all the sidebar list (archives by …, categories) I did this correction earlier on categories list ( see also: category count with style ). I will do this on archives list as well based on the previous solution and overriding that one. 1. get the archives list with count: 2. counter changes: We […]
Goal: fix all the sidebar list (archives by …, categories) I did this correction earlier on categories list ( see also: category count with style ). I will do this on archives list as well based on the previous solution and overriding that one. 1. get the archives list with count: 2. counter changes: We […]
6 Jun 2014
javascript if function – created on other way
10:19 |
javascript
|
1015 views
Goal: to go out of box… The if construction is simple Meanwhile I use the following for in many cases: But! Never use return from the comma chain! someThing == ‘value’ && ( $(this).stop().animate({‘opacity’:0}, 250), this.obj.isHidden = true, return true; /*
Goal: to go out of box… The if construction is simple Meanwhile I use the following for in many cases: But! Never use return from the comma chain! someThing == ‘value’ && ( $(this).stop().animate({‘opacity’:0}, 250), this.obj.isHidden = true, return true; /*
6 Jun 2014
jQuery Select Cheet Sheet
9:05 |
cheetsheet
, jquery
|
1154 views
Goal: to collect all the available select types textbox: see also: other cheet sheets
Goal: to collect all the available select types textbox: see also: other cheet sheets
5 Jun 2014
easy trace in javascript
9:10 |
javascript |
1089 views
Goal: to notice the console trace function Who called my function? Easy question if you know about how you can trace. Just put one line to your function: This is for functions. If you want to know about variable changes, use getter/setter use this form So this is nice but here is a more flexible […]
Goal: to notice the console trace function Who called my function? Easy question if you know about how you can trace. Just put one line to your function: This is for functions. If you want to know about variable changes, use getter/setter use this form So this is nice but here is a more flexible […]
5 Jun 2014
split to array is sometimes dangerous
8:58 |
javascript |
1059 views
Goal: to notice the split function special feature just split a delimited string to an array: but there is a strange behavior we have an empty element! We need to check the source string is valid or not. The result is correct now. Just be careful.
Goal: to notice the split function special feature just split a delimited string to an array: but there is a strange behavior we have an empty element! We need to check the source string is valid or not. The result is correct now. Just be careful.
3 Jun 2014
split string to array
18:46 |
oracle
|
1216 views
Goal: create array from a long string
Goal: create array from a long string
3 Jun 2014
dbms_output available length extender
18:32 |
oracle |
1102 views
Goal: to extend the character limited dbms_output If the output is too short for you use instead of
Goal: to extend the character limited dbms_output If the output is too short for you use instead of
3 Jun 2014
round up with decimals
18:23 |
oracle |
1159 views
Goal: to create a function to round up numbers with decimals We need to round up every numbers for a catalog view. May be with decimals or without.
Goal: to create a function to round up numbers with decimals We need to round up every numbers for a catalog view. May be with decimals or without.
3 Jun 2014
select all rows where we have non numeric characters in the column
17:26 |
oracle |
1129 views
Goal: to find all the rows with invalid order number. We have a process where some outsider application send orders to a web page and read the answer from the server. The answer sometimes is incorrect. The page structure is seemingly good, but we have incorrect data. For example the place of order number contains […]
Goal: to find all the rows with invalid order number. We have a process where some outsider application send orders to a web page and read the answer from the server. The answer sometimes is incorrect. The page structure is seemingly good, but we have incorrect data. For example the place of order number contains […]
