Lowyat.NET: Latest topics by me0wSter

[WTB] HSDPA Modem

me0wSter — Tue, 10 Nov 2009 20:56:08 +0800

Hi, please let me know if you are looking to let go a HSDPA modem that will accept Maxis' broadband sim.

Cheers!

Opening terminal

me0wSter — Tue, 09 Sep 2008 09:37:58 +0800

Hmm, after googling this for a while, i've still not found a solution to this. When opening a terminal, I would like to point it to another directory.

This should be possible right? Any pointers?

Mountain Biking, ~ version 5.0 ~

me0wSter — Thu, 29 May 2008 08:21:20 +0800

Rider's and their bike Setup

me0wster

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

mushr00m

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

iman_210

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

1 PC Connecting to more than 1 Internet Source

me0wSter — Sun, 10 Feb 2008 21:00:38 +0800

I've always wondered about this.. Any reading materials?

Image bug

me0wSter — Wed, 23 Jan 2008 08:49:33 +0800

Seems that i have found a bug here when placing images.

I've taken the link from imageshack (i.e. their forum links) and place 5 for the 1st post and then another 5 for the next post and i allowed it to addon to the previous post. Then paste another set of links but this time it says "Too many images in a post". So, i've forced it to go to the next post.

But here's where it gets funny.. After selecting the "Do not combine", the 3 post overrides the 1st post (with the combination of 2nd post).

Comments?

Mountain Biking, ~ version 4.0 ~

me0wSter — Mon, 24 Dec 2007 07:36:01 +0800

- Booked -

Mountain Biking

me0wSter — Tue, 29 May 2007 13:16:07 +0800

Bikers and their bike

1. me0wster

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

2. Andy Lo

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

3. Ober

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

4. Akchang

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

5. sucka3

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

6.theodore_kh

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

7. xardazs

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

8. cHimUn5

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

9. mushr00m

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

Generating Database

me0wSter — Fri, 17 Nov 2006 23:07:12 +0800

Would anyone know how to generate data for a table? My assignment requires about 50k worth of rows in the database.

THis would be mainly in the transaction table which looks like this

CODE

CREATE TABLE TRANSACTION
( TRANSACTION_ID NUMBER(10,0),
FUEL_ID NUMBER(10,0),
PUMP_ID NUMBER(10,0),
TRASACTION_DATE DATE,
TRASACTION_TIME NUMBER(4,0),
TRANSACTION_PRICE NUMBER(5,2),
TRANSACTION_AMOUNTOFFUEL NUMBER(5,2),
TRANSACTION_PAYMENTTYPE VARCHAR2(4),
TRANSACTION_CARDTYPE VARCHAR2(10),
TRANSACTION_CARDNO NUMBER(4,0),
CONSTRAINT TRANSACTION_PK PRIMARY KEY (TRANSACTION_ID) ENABLE,
CONSTRAINT TRANSACTION_FK FOREIGN KEY (FUEL_ID)
REFERENCES FUEL (FUEL_ID) ON DELETE CASCADE ENABLE,
CONSTRAINT TRANSACTION_FK2 FOREIGN KEY (PUMP_ID)
REFERENCES PUMP (PUMP_ID) ON DELETE CASCADE ENABLE
);

Is there anyway to auto generate the transaction date, time, price, amountoffuel, paymenttype, cardNo?

Mountain Bike V2

me0wSter — Wed, 15 Nov 2006 08:27:01 +0800

Ok all, this is the new thread for us to banter.

To all MTBer, pls send me your pic and your bike specs so i can load it up here!!

PLSQL Trigger

me0wSter — Tue, 07 Nov 2006 23:55:30 +0800

Im wondering if thier any SQL experts out there which can help me. Im getting this no data found error.. The trigger is compiled ok but when i run an insert value, the error appears.

The thing i would like to do is to find the average of internal and external and dump it into totalmark.

CODE

CREATE TABLE RESULT
( STUDENT_ID VARCHAR2(6),
MODULE_ID VARCHAR2(6),
INTERNALMARK NUMBER(4,1),
EXTERNALMARK NUMBER(4,1),
TOTALMARK NUMBER(3,0)

CODE

create or replace trigger Calc_Result
before
insert on result
for each row
declare
a number(4,1);
b number(4,1);
c number(3,0);
begin
select internalmark into a from result;
select externalmark into b from result;
c:=a+b/2;
select c into :new.totalmark from dual;
end;
/

Then

CODE

INSERT INTO RESULT VALUES ('S00001','M00001',32,30,62);

Thx for your time wasted here

me0wster's windoW

me0wSter — Thu, 10 Aug 2006 16:10:24 +0800

Welcome to my window to the world. I will keep on updating as time goes by!

Photos are taken with either FinePix S5500 or A310 unless stated.

Some wild pig seen in Sawarak

Hotel in Sarawak at the Rainforest World Music Festival 2005. Cant remember whats the name of the hotel.

Our fellow friends.

Shot is Sabah; Sandakan i think

Another shot as above. Beautiful lighting!! This one totally no alteration; only cropping!!

Shortcut key for Windows

me0wSter — Sat, 22 Jul 2006 11:57:40 +0800

Shift+F10 brings up the context menu
Ctrl + Shift + Esc - Brings up the task manager
CTRL and A Selects all the items in the active window.
CTRL and C Copies the item or items to the Clipboard and can be pasted using CTRL and V.
CTRL and F Displays the Find all files dialog box.
CTRL and G Displays the Go to folder dialog box.
CTRL and N Displays the New dialog box.
CTRL and O Displays the Open dialog box.
CTRL and P Displays the Print dialog box.
CTRL and S Displays the Save dialog box.
CTRL and V Pastes the copied item or items from the Clipboard.
CTRL and X Cuts the item or items selected to the Clipboard.
CTRL and Z Undoes the last action.
CTRL and F4 Closes the active document window.
CTRL while dragging an item Copy the selected item
CTRL+SHIFT with arrow keys Highlight a block of text
CTRL+F4 Close the active document
CTRL+ESC Display the Start menu
CTRL and F6 Opens the next document window in the active application.
ALT+ENTER View the properties for the selected item
ALT+F4 Close the active item, or quit the active program
ALT+SPACEBAR Open the shortcut menu for the active window
ALT+TAB Switch between the open items
ALT+ESC Cycle through items in the order that they had been opened
F1 key Gives help on the active window or selected item.
F2 key Rename the selected item
F3 key Search for a file or a folder
F4 key Display the Address bar list in My Computer or Windows Explorer
F5 key Update the active window
F6 key Cycle through the screen elements in a window or on the desktop
F10 key Activate the menu bar in the active program
Windows Logo Display or hide the Start menu
Windows Logo+BREAK Display the System Properties dialog box
Windows Logo+D Display the desktop
Windows Logo+M Minimize all of the windows
Windows Logo+SHIFT+M Restore the minimized windows
Windows Logo+E Open My Computer
Windows Logo+F Search for a file or a folder
CTRL+Windows Logo+F Search for computers
Windows Logo+F1 Display Windows Help
Windows Logo+ L Lock the keyboard
Windows Logo+R Open the Run dialog box
Windows Logo+U Open Utility Manager
TAB Move forward through the options
SHIFT+TAB Move backward through the options
CTRL+TAB Move forward through the tabs
CTRL+SHIFT+TAB Move backward through the tabs
ALT+Underlined letter Perform the corresponding command or select the corresponding option
ENTER Perform the command for the active option or button
SPACEBAR Select or clear the check box if the active option is a check box
F1 key Display Help
F4 key Display the items in the active list
Arrow keys Select a button if the active option is a group of option buttons
BACKSPACE Open a folder one level up if a folder is selected in the Save As or Open dialog box
END Display the bottom of the active window
HOME Display the top of the active window
NUM LOCK+Asterisk sign (*) Display all of the subfolders that are under the selected folder
NUM LOCK+Plus sign (+) Display the contents of the selected folder
NUM LOCK+Minus sign (-) Collapse the selected folder
LEFT ARROW Collapse the current selection if it is expanded, or select the parent folder
RIGHT ARROW Display the current selection if it is collapsed, or select the first subfolder

CTRL+SHIFT+ESC brings out Task manager <-- from a_yu_volution
ALT + LEFT -> Back
ALT + RIGHT -> Forward <-- From V3i HoN6