Lowyat.NET: Latest topics by erictioh84

SAP job with high pay

Thu, 01 Jan 1970 07:30:00 +0800

oracle sql question

erictioh84 — Sun, 24 Feb 2008 13:34:37 +0800

Hi here i mention out my question which is i have a sql to query out record which contains data of every month from sales each day 1 row. Let's say my query got 3 rows which is for 1st, 2nd and 3rd of this month, the rest days of the month are not show.

now i wan to make 1 - 31st days of the month returning as record from the query but with those empty records set to null. is this possible ?

how to make such query ?

mexter company

erictioh84 — Fri, 22 Feb 2008 00:24:02 +0800

hi i wanted to know how mexter's doing? if i were a person who wanna learn more about programming language(c#) while not having much pressure coming from office politic and bad bosses, would mexter a good candidate for me ?

Let's compare mexter and altera, can anyone give some idea on their differences?

time in unix/oracle format

erictioh84 — Mon, 11 Feb 2008 10:39:58 +0800

i'm scratching my head on 2 type of date representation system which is date since 1970 and date since 1900, i've found out that the date since 1970 is used by java and most other scripting languages.

my problem is i have date in long type which is in the format of date since 1900 and i can do the conversion using oracle sql : select to_date('19000101000000','YYYYMMDDHH24MISS') + (3409037727/60/60/24) from dual

anybody know how to convert 3409037727 (num of sec milisec since 1900) in java or perl ? for java it only accept milisec since 1970 not 1900.

if i misunderstood the concept please explain to me thanks alot for anyone can help.

where to repair bonnet & bumper

erictioh84 — Fri, 23 Nov 2007 13:12:59 +0800

Hi penangrites, may i know what is the recommended workshop for repairing bonnet and bumper as well as reg.plate ?

multiple internet connection on single pc

erictioh84 — Wed, 21 Nov 2007 10:13:36 +0800

hi, i have 2 internet connections in my pc, 1 is streamyx line and another is maxis broadband, how to i make firefox to use streamyx line and Bit comet to use maxis broadband? or vise-versa

where to print cheapest and good photo?

erictioh84 — Wed, 21 Nov 2007 09:48:17 +0800

Hi, may i know where in penang i can find cheapest yet good quality photo printing service? i need to print at least 3000(correction: not 3000k) pcs.

mfc bezier curve

erictioh84 — Fri, 25 May 2007 00:42:20 +0800

hi, i'm able to draw bezier curve using mfc's PolyBezier() function.

now i want to let user to be able to select and drag the curve, when how do i know whether user has clicked on the curve ? any idea ?

Mini sd Card benchmarking

erictioh84 — Thu, 10 May 2007 13:55:15 +0800

Kingston
Apacer
Toshiba
SanDisk
Corsair
DNA

among above brands which one has best performance if comparing their normal 2GB mini sd (normal one not highspeed)

Hijet lubricant

erictioh84 — Tue, 17 Apr 2007 10:55:17 +0800

anyone heard of this brand of lubricant before ? any comment on it ?

Creative Gigawork 5.1 G500

erictioh84 — Sun, 08 Apr 2007 00:18:53 +0800

Hi, there has not been a thread on G500 yet, users of it let's start talking anything regarding the speaker.

I've just bought it at pc fair to pair to gather with creative audigy 2 nx usb. the sound was so wonderful, the woofer is incredible strong which i don't believe before purchase. it must be paired at least with an audigy card only can carry out the power of it.

The bass is so strong and i don't put it too near to wall but keep a 60cm gaps between so that i can feel cleaner bass from it.

Personally i bought it for music listening and movie(watching dts audio dvd) as well. sound produced from 5 satellites are not too sharp and pretty same feeling as my home hi-fi speaker AXIS brand. Bass is soft, and it's capable to handle rock to sentimental songs well.

i'm just made a right choice, those interested on G500 may ask question over here and we just together make this thread rock and informative.

Specifications
310 watts total RMS power

* Front : 36 watts RMS per speaker
(Measured @ 8 ohms @ 10% THD @ 180Hz to 20kHz, two channels driven)

* Rear : 36 watts RMS per speaker
(Measured @ 8 ohms @ 10% THD @ 180Hz to 20kHz, two channels driven)

* Center : 36 watts RMS
(Measured @ 8 ohms @ 10% THD @ 180Hz to 20kHz, one channel driven)

* Subwoofer : 130 watts RMS
(Measured @ 6 ohms @ 10% THD @ 35Hz to 180Hz, one channel driven)
620 watts total Peak Power

[addedon]April 10, 2007, 4:50 pm[/addedon]wah no other G500 users at all ?

Apacer SD card 60x and 150x

erictioh84 — Wed, 21 Mar 2007 14:56:00 +0800

http://www.cdrinfo.com/Sections/Reviews/Pr...ArticleId=15205

by referring to this link, i personally just bought 2GB 60X card brand apacer, tested the write speed is 2.7MB/s and read speed is 5MB/s only which the reading speed supposed to be 9MB/s and about 5MB/s for writing.

anyone has same card can you test it out? and verify that apacer fool their customer with false information (60x and 150X).

MFC's MDI application problem

erictioh84 — Mon, 19 Mar 2007 19:43:51 +0800

I'm coding on MFC using c++ and have the following problem:
a main frame containing menu with 2 child frame inside. whenever i click X button on child frame, my code will check whether it has been saved and then only exit inside the OnClose() function in CChildFrame class.

now if user press X of the main frame one, OnClose() function inside CChildFrame class will not be called. how should i do so that when user press X of main frame window and i'll promt a message box telling them if they haven't save their document?

n73 music edition 2GB card very slow

erictioh84 — Mon, 12 Mar 2007 10:32:26 +0800

the 2GB card of n73 ME seems very slow. the most noticeable state is when i change my sms memory to memory card instead of phone memory. i've benchmarked the card and result shows me 3.1MB/s writing and 4.5MB/s reading

my question is will it improve my phone's performance (sms, etc...) if i replace it with a faster performance card? cause i'm not sure the sms slow is because of the card or not. anyone can point it out ?

any toyota spare part shop in pg ?

erictioh84 — Tue, 06 Mar 2007 10:33:23 +0800

anyone know any toyota spare part shop in pg island ? i wan to buy cheaper spare part and install a workshop else most workshop selling very expensive.

fastest mini Sd card

erictioh84 — Sun, 25 Feb 2007 00:16:37 +0800

hi, can anyone recommend to me which brand of mini SD card got fastest writing and reading speed ?

AP price for n73

erictioh84 — Thu, 01 Feb 2007 00:06:37 +0800

hi, may i know whether price of n73 in lowyat plaza cheaper or those in garage sales. ? anyone has made research on this ?

and what AP company do you guys recommend ?

AP n73 with camera & lcd warranty ?

erictioh84 — Wed, 31 Jan 2007 23:55:59 +0800

any AP set comes with camera and lcd warranty ?

Speaker and player recommend pls.

erictioh84 — Tue, 26 Dec 2006 16:01:32 +0800

my budget is RM 700 for speaker + player , anyone can help me figure out which brand and model should i buy ?

i want clear sound, soft and solid bass. my car is toyota SEG 93', speaker shape is 6X9'

cleaning ear

erictioh84 — Sat, 18 Nov 2006 12:38:46 +0800

hi anyone know where should i go for cleaning up my ears in Penang? bcause recently i've found that i couldn't hear well from other when they talk to me...