Lowyat.NET: Latest topics by zzero

Wired + Wireless

zzero — Thu, 29 May 2008 12:22:36 +0800

I have 2 different connection..
connection A - wired
connection B - wireless
both connection have internet access and is on 2 different router/modem

is it possible to split the usage..?
eg.
IE to use connection A
Firefox to use connection B

im not sure what exactly the term to use..

tSQL query help..

zzero — Tue, 21 Aug 2007 11:39:30 +0800

need some help on querying

tblA structure:

id xx amt
-------------
1 a 10
1 a 20
1 b 5
1 c 2
2 a 10
2 b 2

i need to query it to become like this:

id xxA_amt xxB_amt xxC_amt
----------------------------------------
1 30 5 2
2 10 2 0

table tblA is huge..
i need to take care of the performance.. make sure the query is fast and not lagging the system

should i use this?

select tblB.id,
select sum(amt) tblA where zz=tblB.id and xx=a,
select sum(amt) tblA where zz=tblB.id and xx=b,
select sum(amt) tblA where zz=tblB.id and xx=c
from tblB

or joining tblA 3 times?
or the cursor way?
or any other suggestion?

J2ME application compatibility

zzero — Mon, 28 Aug 2006 18:34:23 +0800

i recently developed a j2me application (cldc 1.0, midp 1.0).. i tested on few phone model, some works some doesnt.. and some stuck when connecting to server..
any suggestion on any setting i should set? there's some optional package included in the setting but im not sure if this causes the compatibility.. any idea? im using netbeans ide..

btw, im new to j2me..

J2me retrieve data

zzero — Wed, 26 Jul 2006 15:02:21 +0800

how actually j2me application retrieve data from database?
i'm thinking of using web services and returning xml back to j2me..
but i was told that mobile service provider (eg. Maxis) will filter out anything except wml format.. can anyone clarify this?

Windows Services

zzero — Thu, 06 Jul 2006 16:05:33 +0800

is there any possible way developing windows services with user interface? in vb.net
any idea how to do it?

the current project is a listener vb.net (not windows services), it always accidentlly close by someone, hence now want to convert it to windows services..

Sql Server Printin..

zzero — Wed, 12 Apr 2006 18:05:09 +0800

Is there a way to print out sql server table? i mean send to printer print out hardcopy.. where it print out all the field name and data type..