id name

1 Belex

2 2LOL

3 Alex

so we need to sort this table in ascending order but in way those names starts with number should be after names which starts with letters

so if you make this query:

SELECT * FROM table1 ORDER BY name ASC

You’ll get this

2LOL

Alex

Belex

but we need:

Alex

Belex

2LOL

So here is solution:

SELECT * FROM table1 ORDER BY ORD(name) < 65 ASC, name ASC

In code above we used function ORD that takes first character’s integer code and then compare it to be less than letter code, almost all characters and numbers will have less value, after this we’r making ascending sorting, that is it.

@interface NSString (MyCategory)
 
-(void) myMethod:(NSString*)name;
 
@end

You should put this code into header file (for example NSString+MyCategory.h), then implement method in implementation file (NSString+MyCategory.m). Then you try to call myMethod for any NSString instance. But you get error unrecognized selector myMethod, you can think “hm….., why?!!! i’m linked header file “  (with #import “NSString+MyCategory.h”),  even XCode IDE gives you myMethod automatically, but in some reason it does not work. So solution is very simple  you just need to import implementation file along with header file #import “NSString+MyMethod.h”. I can not explain why, but in some way compiler does not link implementation file automatically.

add_action('admin_menu', 'rotator_bar_admin_actions');
 function rotator_bar_admin_actions() {
 add_options_page("WP Rotator Bar", "WP Rotator Bar", 'read', "rotator-bar", "rotator_bar_admin");
}

so 4th option for function add_options_page should be the same name as your main plugin file for example my one is rotator-bar.php, if you have different name there you will get error above

var urlRequest:URLRequest = new URLRequest();
urlRequest.contentType = 'multipart/form-data;';

But this wont work!

So there is very easy solution. Instead of using code above use code below:

var urlRequest:URLRequest = new URLRequest();
urlRequest.requestHeaders.push(new URLRequestHeader('Content-type', 'multipart/form-data; boundary=' + UploadPostHelper.getBoundary()));

You can find UploadPostHelper in the internet.

Solution:
To solve this issue just add another wrap(container), for example Canvas, inside you component and put there all your content, and mask this is container instead of actually component.
So your code should looks like this:

<?xml version="1.0" encoding="utf-8"?>
<mx:Canvas xmlns:mx="http://www.adobe.com/2006/mxml">
   <!-- ... any code there ... -->
   <mx:Canvas id="containerToMask" mask="{customMask}">
       <!-- content -->
   </mx:Canvas>
</mx:Canvas>

/* this will allow sidebar stretch vertically in right way */
html, body {
	min-height:100%;
	position: absolute; 
        width:100%;
}
 
/* stretching our sidebar */
#sidebar{
 width: 300px;
 height: auto;
 min-height:100%;
 position:absolute;
 background-color: #555;
}

To make content block is not to hard and you need is to set margin-left the same width as sidebar width