Lowyat.NET: Latest topics by oxygen_

Upgrade BB plan - not update in MyLaunchPad

oxygen_ — Wed, 28 Oct 2015 09:57:56 +0800

Hi..
I just upgrade my wireless broadband plan couple days ago. Before this, I often monitor my data usage & balance using MyLaunchPad website. When I upgraded the plan, I guess I can continue to monitor it, but it shows plan = N/A. I guess my MyLaunchPad account don't link to my new bb account.

How can I link my MyLaunchpad account to my new bb account? Or.. do I have to register a new MylaunchPad account? I hope not...

Thanks.

upgrading my plan - change to 'faster' modem

oxygen_ — Tue, 13 Oct 2015 16:50:40 +0800

hi guys..
i'm currently using 4gb plan. i'm planning to upgrade to 7gb plan (or maybe 12gb plan, not decide yet).
now, i'm using ZTE MF70, provided by maxis.. so, besides upgrade plan, i'm planning to get the LTE mobile wifi modem that has been advertise in the maxis wireless broadband website.

my question is, will i notice any difference of speed (loading website / streaming / download)..??

thanks..

need help on SQL statement

oxygen_ — Fri, 10 Oct 2014 15:44:31 +0800

hello guys..

sample data:
BRANCH CUSTOMER_CODE TRANSACTION
KL SA001 1
KL SA002 2
KL SA002 3
KL KC001 4
Ipoh SA001 1
Ipoh KC001 2
Ipoh KC002 3

based on the sample data above, i want to categorize those customer into 2 category - SA & KC - and sum (or should i use count?) each of them based on branch. the customer have to be distinct.

the result should be like this:

BRANCH SA KC
KL 2 1
Ipoh 1 2

my trial statement:
select branch,
sum(distinct case when customer_code like 'SA%' then 1 else 0 end) as SA,
sum(distinct case when customer_code like 'KC%' then 1 else 0 end) as KC
from table1

the result of the statement:

BRANCH SA KC
KL 1 0
Ipoh 1 0

..not getting the result that i want..

hope you guys can help.. thanks..!!

what the best solution for me?

oxygen_ — Fri, 04 May 2012 11:31:25 +0800

hi..
ok now i hav streamyx 1mbps (rm110) package back at my hometown aka my parent house which apparently i only use when i balik kampung lah my parent only use it lightly, say below 1gb.

now, i based in kl n really want to get a wireless broadband here & at the same time terminate the streamyx & replace it with another wireless broadband package for my parent. so, meaning i wanna get 2 wireless broadband (1 5gb-20gb & 1 1-2gb). fyi, i dont think hav prob with coverage back in my hometown..

so, what the option (2 packages.. example: 2gb umobile + 10gb yes) do i hav?? hopefully (juz hoping ) within my current bill - rm110 (for both)...
thanks!

help me approx how long b4 reach limit

oxygen_ — Fri, 27 Jan 2012 12:57:23 +0800

hey guys n gals
as we all know, there r 1gb, 1.5gb, 3gb bla bla bla data plan

i've been using streamyx, so dont really care bout data limit
but now, im considering to use mobile internet
so, can u guys enlighten me how long each of d data plan approximately can i use b4 it reach limit..
to make it easy, let say i use it juz for youtube, couple of hours per day

err..n mayb u guys can propose the suitable package(s) too..

thanks in advance..

fireworks - new year celebration

oxygen_ — Tue, 27 Dec 2011 09:49:51 +0800

hi..
there will b fireworks on new year eve right..??
so, if in KL, where is (are) the best spot to photograph the fireworks?

thanks

hp mini 110-3558tu netbook

oxygen_ — Tue, 02 Aug 2011 11:53:15 +0800

hi guys...
where can i download driver(s) for the netbook stated?
i know can find them at hp website..but i find it a bit troublesome to download them separately..
a zip file containing all of them is what im searching for...

hope u guys can help...
thanks!

background music

oxygen_ — Tue, 01 Mar 2011 09:58:50 +0800

as title stated...
hope u guyz n gals can suggest suitable song that i can use for d movie
actually its not a movie - juz containing static pictures... i know u know what i mean..

thanks..

plusmiles card (with TnG function)

oxygen_ — Tue, 18 Jan 2011 15:54:49 +0800

can i use plusmiles card to pay for lrt fares..??
b4 this, juz use d 'real' TnG card..
now, d 'real' one oredi gone, only got plusmiles...

thank u