Lowyat.NET: Latest topics by hamiru

simplifying database design

hamiru — Thu, 17 Nov 2011 04:21:28 +0800

hello,
i'm in need of suggestions to simplify the following tables:-

Explanation:
- there are 50 products (and counting) in the PRODUCT table
- every product will undergo a series of tests to calculate a score for each test
- for an example, product ID P001 will be tested for 100 times, and each test will generate a score. all the scores will be stored in PRODUCT_TEST table

By this, table PRODUCT_TEST will become very humongous (50 products multiplying with 100 tests) to store all the data. So i'm welcoming any suggestion on how to make the tables more simplified and organized.
My friend suggests of creating a table for each product named such as table TEST_P001, TEST_P002, TEST_P003 and so on. however i'm not sure whether this is the better solution

get a MIMO or not?

hamiru — Sun, 22 Aug 2010 22:24:29 +0800

hello, just need a quick answer for these questions:-

1) any difference between using N MIMO and a regular N router+modem in term of signal range?

2) is Belkin F5D8636 is also an N MIMO router+modem as F5D8635 or F5D8633?

thanks in advance

rdbss.sys BSOD

hamiru — Thu, 05 Nov 2009 19:29:54 +0800

Hi all,
Forgive me if there's any thread exists on this matter, but I've searched it with no luck

Recently, everytime I shutdown my Dell Vostro 1220, this problem comes up.

It started when it suddenly can't shutdown properly (1 hour passed and still showing 'Windows is shutting down' message), so I have to shut down in a hard way.

Since then, whenever I'm using the internet, sometimes it will get 'cut-off'. My router is running fine, but my wireless module can't connect to my router so the only way is to reboot. And that's where this bloody 'rdbss.sys BSOD' appears.

By the way, I'm running dual boot XP/Vista currently. Recently I've uninstalled Kaspersky (as it blocked my internet connection) and use AVG Free.

Any help are appreciated.

ORA-01858 error

hamiru — Sun, 06 Sep 2009 21:58:22 +0800

Hello all,

I've been searching a solution for this error, but most of the times I don't understand what they've suggested.

So here I'm posting a partial of the codes, along with its error output. I attach the full SQL codes too in case you want to try executing them.

I'm using Oracle by the way, and this is the infamous PetStore exercise for students studying at my place.

» Click to show Spoiler - click again to hide... «

CODE

CREATE TABLE Sale
(
SaleID INTEGER,
SaleDate DATE,
EmployeeID INTEGER
DEFAULT 0,
CustomerID INTEGER
DEFAULT 0,
SalesTax NUMBER(38,4)
DEFAULT 0,
CONSTRAINT pk_Sale PRIMARY KEY (SaleID));

CODE

insert into Sale values(4,'14-Aug-2004',3,18,14.62);
insert into Sale values(5,'31-Oct-2004',2,21,6.86);
insert into Sale values(6,'15-Sep-2004',5,44,9.82);
insert into Sale values(7,'10-Feb-2004',4,42,12.31);
insert into Sale values(8,'10-Mar-2004',1,15,17.58);
insert into Sale values(9,'10-Feb-2004',3,16,2.81);
insert into Sale values(10,'1-Nov-2004',8,53,7.83);
insert into Sale values(11,'24-Dec-2004',8,60,3.67);
insert into Sale values(12,'15-Aug-2004',2,53,1.19);
insert into Sale values(13,'30-Jan-2004',7,49,14.81);
insert into Sale values(14,'18-Sep-2004',2,9,3.56);
insert into Sale values(15,'20-Jul-2004',9,39,1.13);
insert into Sale values(16,'18-Sep-2004',8,62,12.96);
insert into Sale values(17,'12-Feb-2004',4,71,16.31);
insert into Sale values(18,'21-Dec-2004',5,35,14.95);
insert into Sale values(19,'14-Feb-2004',7,14,15.72);
insert into Sale values(20,'9-Mar-2004',5,2,12.96);
insert into Sale values(21,'23-Apr-2004',2,61,20.14);
insert into Sale values(22,'27-Nov-2004',2,16,9.67);
insert into Sale values(23,'8-Jul-2004',6,27,10.53);

error output

QUOTE

SQL> insert into Sale values(4,'14-Aug-2004',3,18,14.62);
insert into Sale values(4,'14-Aug-2004',3,18,14.62)
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected

SQL> insert into Sale values(5,'31-Oct-2004',2,21,6.86);
insert into Sale values(5,'31-Oct-2004',2,21,6.86)
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected

SQL> insert into Sale values(6,'15-Sep-2004',5,44,9.82);

1 row created.

SQL> insert into Sale values(7,'10-Feb-2004',4,42,12.31);

1 row created.

SQL> insert into Sale values(8,'10-Mar-2004',1,15,17.58);
insert into Sale values(8,'10-Mar-2004',1,15,17.58)
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected

SQL> insert into Sale values(9,'10-Feb-2004',3,16,2.81);

1 row created.

SQL> insert into Sale values(10,'1-Nov-2004',8,53,7.83);

1 row created.

SQL> insert into Sale values(11,'24-Dec-2004',8,60,3.67);
insert into Sale values(11,'24-Dec-2004',8,60,3.67)
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected

SQL> insert into Sale values(12,'15-Aug-2004',2,53,1.19);
insert into Sale values(12,'15-Aug-2004',2,53,1.19)
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected

SQL> insert into Sale values(13,'30-Jan-2004',7,49,14.81);

1 row created.

SQL> insert into Sale values(14,'18-Sep-2004',2,9,3.56);

1 row created.

SQL> insert into Sale values(15,'20-Jul-2004',9,39,1.13);

1 row created.

SQL> insert into Sale values(16,'18-Sep-2004',8,62,12.96);

1 row created.

SQL> insert into Sale values(17,'12-Feb-2004',4,71,16.31);

1 row created.

SQL> insert into Sale values(18,'21-Dec-2004',5,35,14.95);
insert into Sale values(18,'21-Dec-2004',5,35,14.95)
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected

SQL> insert into Sale values(19,'14-Feb-2004',7,14,15.72);

1 row created.

SQL> insert into Sale values(20,'9-Mar-2004',5,2,12.96);
insert into Sale values(20,'9-Mar-2004',5,2,12.96)
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected

SQL> insert into Sale values(21,'23-Apr-2004',2,61,20.14);

1 row created.

SQL> insert into Sale values(22,'27-Nov-2004',2,16,9.67);

1 row created.

SQL> insert into Sale values(23,'8-Jul-2004',6,27,10.53);

1 row created.

As you can see, some of the Insert queries are successful, while some of them don't, resulting in 'ORA-01858: a non-numeric character was found where a numeric was expected.'

Also, I need to know what exactly using to_date is, since a lot of people suggest it. I'm guessing to_date is applied for a single query, so changing the above queries to have a to_date function is definitely a time-consuming task.

Thanks in advance.

Motorcyclist hit my side mirror

hamiru — Wed, 11 Mar 2009 11:00:18 +0800

Hello all,
Recently a bloody idiot motorcyclist hit my right side mirror, but instead his side mirror is smashed (I could see the debris on the road) while mine has a minor scratches
This incident happened when he tried to overtake a line of cars, while me and a lorry in front of me (of course, the view is blocked) coming on the opposite way
The lorry suddenly going left a bit, like trying to avoid something, and out of the blue, the motorcyclist speeding (yes, he's going fast!) on my lane, overtaking a line of cars, and hit my side mirror
Although he (should) realize his smashed side mirror, he instead sped away

I'm sure I am innocent totally, but should I make a report to the police station? The road isn't double-lined, but he shouldn't overtake whenever there's any incoming vehicle

Here's a rough (and ugly) drawing I made

Upgrading...again

hamiru — Tue, 06 Jan 2009 16:12:50 +0800

Thinking of upgrading my rig, so I don't have spent frequently every year on particular hardware. So I made a survey and here, the selection I made plus calculation

SELECTION 1
Processor: Phenom AM2+ X4 9950 = RM620
Motherboard: Asus M3N-HT DELUXE = RM650
Graphic card: GigaByte 9800GTX+ x 2 (SLI) = RM1538

Total = RM2808

SELECTION 2
Processor: Core 2 Quad Q9550 = RM1170
Motherboard: DFI LT X48-T2RS = RM899
Graphic card: Sapphire HD4870 = RM865

Total = RM2934

Please give your best opinion or suggestion. My budget is around RM3000, but if possible, can be maxed to RM4000. Currently my rig's spec is:

Intel Core 2 Duo E8200
Asus P5KC
Asus EN8600GT
Corsair XMS2 2GB kit
Cooler Master iGreen 500W
1TB, 200GB, 80GB hard disks
Pioneer DVDRW Dual Layer with Lightscribe

[WTA]Getting a 2nd Hand SUV

hamiru — Mon, 03 Nov 2008 03:01:18 +0800

Hello guys

I've been thinking of getting a second hand SUV
But I have no experience on finding a good SUV to be maintained and driven for a long term

So what you guys think of Nissan Terrano?

I actually has asked one of Nissan sale officer, but his words are not that specific that I figured he talked generally about buying second hand vehicles (like high FC, high maintenance, other minor problems, etc...).

Still, I encouraging you guys to suggest other SUV, if there is any, that is better than Terrano. Maybe an Isuzu then?

And the budget is around RM30,000 because initially that is the figure for the '00 Nissan Terrano I found in Mudah.com

So, help me please

Problem after installing Megaupload Toolbar

hamiru — Thu, 03 Jan 2008 11:56:48 +0800

hello all
currently facing a big problem

right after installing Megaupload Toolbar, i can't access many webpages i usually surf
it will pop the message "Problem loading page: The connection has timed out"
that includes Yahoo Mail, MSN, Mozilla Firefox site, the Megaupload site itself, and many of torrent sites
also, i am unable to load video from Youtube

i already uninstalling it, but still can't solve the problem

good ADSL modem, Router, or ADSL+Router

hamiru — Wed, 19 Dec 2007 21:36:47 +0800

hi guys,
sorry if i posted in wrong section

recently my ADSL and router had been struck by lightning
and later, i bought an Aztech DSL605EW
but it won't serve me as i want it to be like my previous modem and router (in short, too problematic)

so i might as well to buy better ADSL modem and router, or ADSL+Router

can recommend me a set of them that's good for P2P, and easy to configure?
or should i get a set that's as same as my previous one?

multiboot

hamiru — Tue, 30 Oct 2007 22:10:18 +0800

hi there,
recently i am thinking of creating multiboot disk of win98se, winxp home, and vista home basic
is it possible? and, how many disk space should i prepare?
my pc initially has winxp home installed

and, i have a program called acronis, but i'm kinda lost and new to it

'File does not begin with %PDF'

hamiru — Thu, 18 Oct 2007 10:56:35 +0800

sorry if there's a thread for the similar problem

whenever i tried opening .pdf link in LYN main page, it'll launch acrobat and the error above will pop out

before this, i'm using adobe CS2 and it worked fine, but the problem arise after upgrading to adobe CS3

java

hamiru — Mon, 25 Jun 2007 15:38:47 +0800

hi all,

i have a java text field and a java button, let say it accepts a valid value range, like 0 to 100
if i input value within range allowed and the button is clicked, an info message will appear
whether i input value lower than 0 or higher than 100, it will display warning message

but how to display warning message, if there is no input made, and the button is clicked?

Java Problem [part 2]

hamiru — Sun, 10 Jun 2007 23:30:45 +0800

Java Problem (part 1) SOLVED
cannot find symbol (method)

Hi guys,

this is my source codes

» Click to show Spoiler - click again to hide... «

and i think the problem lies in this section

» Click to show Spoiler - click again to hide... «

because the error returned

CODE

C:\FYP\projek.java:66: cannot find symbol
symbol : method jcbanimals(java.lang.String)
location: class projek
if(e.getSource().equals(jcbanimals("TIGER")))
^
1 error

Tool completed with exit code 1

anyway, i do think this may a silly mistake, but i'd tried many things to correct this, but failed

please help, thanks

Oracle DB with Java

hamiru — Fri, 25 May 2007 03:21:37 +0800