You are here

Blogs

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: 

Android USB driver for HTC Desire S

In android developing i found Eclipse ADT can not detect my new HTC Desire S, even i have updated the newest USB driver from Google. Someone said it need HTC Sync. But i found it is not necessary, you can find the HTC USB driver here:

http://developer.htc.com/

HTC Android USB Driver for Microsoft PC

 install and everything works fine!

Pages

Subscribe to RSS - blogs