You are here

leelight's blog

Force to update apache to newest version in CentOS 5

If you like me, try to update Apache in CentOS 5, but get this message:

No Packages marked for Update

But you have found that there is newer stable version in Apache website, please follow these steps:

1. check your Apache version:
httpd -v

2. Create a new repo file in /etc/yum.repos.d directory:

$ vi /etc/yum.repos.d/centalt.repo

[CentALT]
name=CentALT Packages for Enterprise Linux 5 - $basearch
baseurl=http://centos.alt.ru/repository/centos/5/$basearch/
enabled=1
gpgcheck=0

2. Update httpd now:
$ yum update httpd

3. Finished then restart Apache

Blog: 

WebOS development first step

Blog: 

Oracel SQL, use ROW_NUMBER() to filter same records when JOIN tables

Sometimes we will retrieve repetitive records when we use JOIN to join tables.
Now distinct, group by, and Having will not work, ROW_NUMBER() is a good choice.

for example:

select a.one, b.two from A a
LEFT JOIN B b ON a.id = G.id where where a.name like '%abc%' and a.time < 1234545;

using ROW_NUMBER() after

SELECT ROWNUM, C* FROM(
SELECT a.id, a.one, b.two, b.id,
ROW_NUMBER() OVER(PARTITION BY a.id ORDER BY a.time DESC) AS ROW_FLG
FROM (select * from A where name like '%abc%' and time < 1234545) a
LEFT JOIN B b ON a.id=b.id
ORDER BY a.time DESC

Blog: 

SQL code snipet, join multi-tables with one column

3 tables(CHART_TEST, CHART_TEST1, CHART_TEST2) need be joined with continious timestamb:

 ID    TIMESTAMP    VALUE
     1    115    456
     4    130    671
     5    190    135
     8    150    934
     9    160    296
     2    120    356
     3    125    556
     6    140    213
     7    145    363
     10    165    358

Blog: 

Display Vector layer from GeoServer WFS on OSM with GeoExt&OpenLayers

Supposed that you know what is GeoExt, GeoServer and Openlayers.

Preparation:
GeoServer with geo data under SRS 'EPSG:31467'

Purpose:
Display vector layer from WFS of GeoServer on OSM(Open Street Map).

Problem:
Can not display vector layer on OSM map, but no problem for displaying vector layer on a normal WMS map.

Codes(only key part) for displaying vector layer on WMS map:

============For WMS=====================

vectorLayer = new OpenLayers.Layer.Vector(
"vector"    );

Simple KML: Cocoa parsing library for Keyhole Markup Language(KML)

Simple KML is a simple & lightweight parsing library for KML written in Objective-C for the iOS platform.

It is not meant for drawing, but rather for parsing.
That is, it is up to the developer to turn the data structures returned
by Simple KML into drawing code, be it for annotations in MapKit,
constructs in an external mapping library, drawing paths on a UIImage,
or otherwise.

iPhone Web Map(WMS) Clients

1. WhateverMap allows you to connect to any OGC compliant WMS in iPhone, written in native iOS SDK

http://mapserver.mendelu.cz/iphonelayers

 

Blog: 

How to upload Multiple APK in Android Market

Android Market supports multi APK from July, as Google said, this is good solution help developers manage their products more effectively in Android Market, and help users to avoid compatible problem. I havnt noticed this news until many users complained me that they can not download my app from Google Market, they got "Compatibility Problem", but the app ran well in their devices before July.

List Picker&DropDown List for WP7

Here are some doc&source code for  List Picker&DropDown List in WP7:

Blog: 

Pages

Subscribe to RSS - leelight's blog