Lowyat.NET: Latest topics by giasens

After Probation Period...

giasens — Fri, 04 Jan 2008 15:59:44 +0800

when boss still not offer confirmation letter,
will you approach your boss for it?
or just wait until he 'remembers'?

alert()'s value

giasens — Sun, 02 Dec 2007 02:08:35 +0800

CODE

alert(1||0); // You get 1
alert(0||2); // You get 2
alert(0||(2&&1)); // You get 1
alert(0||(3&&4)||2); // You get 4
source: [URL=http://jquery.com/blog/2006/02/05/width-based-layout/]jqueryblog[/URL]

1||0 = alert 1 because of 1=true?
the rest i have no idea

anyone understand this piece of code?

Booking Fee & Letter Offer

giasens — Thu, 29 Nov 2007 23:59:16 +0800

Hi, I'm in situation,
planning to buy a new house (under con),
have yet to pay my booking fee
and already applied for loan from several bank for pre-approval

so far only 1 bank verbally replied for the pre-approval being approved,

Question is,
- is there any letter issue for booking fee?
- is there a minimum amount for booking fee? (they require me to pay 10k)
- is verbal approval reliable?
- when is letter offer being issue? must it require booking receipt in order to release letter offer?

Regards,
giasens

Common Loan Questions

giasens — Thu, 22 Nov 2007 21:20:40 +0800

I'm currently searching for homeloan now,
here's my list of common questions on loan,
if there's more, please feel free to post/comment

---------------------------
1. BLR cap
2. charges & setup fee (month fee, account setup)
3. Application processing fee
4. Capital prepayment
- withdrawal of prepayment charges
- charges / notice of prepayment
- amount of prepayment (not exceed annual installment?)
- the minimum amount of outstanding loan principle that must be maintained till the end of lock-in period
5. installment calculation / tables
6. insurance
- mrta/mlta
- finance into loan amount?
- compulsory / optional?
- mrta will gone if refinance
7. locking period
- 5 years from final disbursement or first disbursement?
- normally 3% penalty
8. installment starts when
- on loan agreement
- on first disbursement
- on final disbursement
9. loan person involve
- snp 2 names, loan requires 1 or 2 names?
10. loan statement
- available online?
- printed statement? (charging fee)
11. package?
- zero moving cost? (zmc) - include what fees.
- non zero moving cost? (nzmc)

Jar Execution

giasens — Wed, 07 Nov 2007 13:56:19 +0800

i have compiled my jar - name it ABC.jar
this ABC will have access to mysql database, thus it required classpath.

here's my running jar command

CODE

D:\cron>java -classpath .;D:\cron\mysql-connector-java-3.1.14-bin.jar; -jar sfMigrate.jar

and it returns

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.successfactors.migration.ObjectMigrationCron.initConnection(Objec
tMigrationCron.java:396)
at com.successfactors.migration.ObjectMigrationCron.main(ObjectMigration
Cron.java:74)
java.lang.NullPointerException
at com.successfactors.migration.ObjectMigrationCron.main(ObjectMigration
Cron.java:75)

any idea what's wrong?

[addedon]November 7, 2007, 5:45 pm[/addedon]settled.

CODE

java -classpath .;D:\cron\mysql-connector-java-3.1.14-bin.jar;D:\cron\sfMigrate.jar;
ObjectMigrationCron

dot matrix printing font

giasens — Fri, 06 Jul 2007 12:11:18 +0800

what font you use for your dot matrix printer?
i couldn't find any suitable font.
i've this case that printing thru XP, the printing speed is fast & clear
but if print thru 98, it's ether print speed is slow & produce good printout
OR the print speed is fast & produce bad printout.

so what font you use for printing report thru dot matrix printer?
and what dpi is used?

thanks

Safari 3 Beta's up!

giasens — Tue, 12 Jun 2007 04:03:38 +0800

Safari 3 Beta download available for windows
http://www.apple.com/safari/

Jobs Demoes Leopard, annouce Safari for Windows

QUOTE

As the final bombshell, Jobs announced Safari for Windows. Safari 3, which will come with Leopard, will also be available for Windows XP and Vista. Jobs showed some benchmarks which showed that Safari on windows was faster than Internet Explorer 7 and Firefox. Safari on Windows will be available as a public beta from Apple's Safari website.
http://www.apple.com/safari/

enjoy trying out

table indexing

giasens — Fri, 11 May 2007 10:44:04 +0800

i have 2 tables, which has large amount of data

//table a [index - a_year, a_month, a_cycle (in sequence)]
a_no[PK], a_year, a_month, a_cycle, a_staffno, a_amount
//table b
b_staffno [PK], b_staffname
------------------------
my input year=2007
my input month=3
my input cycle=1
table b is staff table, each staff has 1 record,
while table a is txn table, each combination of year+month+cycle,
every month it will store every staff's no into table a.

eg,
table b {1, name1}, {2, name2}, {3, name3}
table a
{1, 2007, 1, 1, 1, 10.00}
{2, 2007, 2, 1, 1, 200.00}
{3, 2007, 3, 1, 1, 15.01}

------------------------
here's my query, to select all staffs & their txn in the respective year, month, cycle

select * from a, b
where a_year=2007
and a_month=3
and a_cycle=1
and b_staffno=a_staffno

and my question is,
should i include a_staffno in table a's index?

-info updated

unable to getfocus back on input after validation

giasens — Wed, 28 Feb 2007 10:52:28 +0800

here's my code

CODE

<input type="text" name="a" onblur="javascript:checkNum(this);" value="123456">
<input type="text" name="a" onblur="javascript:checkNum(this);" value="123456">
<input type="text" name="a" onblur="javascript:checkNum(this);" value="123456">

js:checkNum
function checkNum(obj) {
if (!isNumber(obj.value)) //return true it's number, else otherwise
{
//obj.value = ""
obj.focus();
obj.select();
[COLOR=red] //problem occurs here, i can't get it to focus back, if i tab/focus to another input box[/COLOR], but
}
}

any idea to get the focus back to the input box where the validation faild?

thx

REGEX replace string b4 & and the matching pattern

giasens — Mon, 05 Feb 2007 00:56:28 +0800

i hav a string like this

asdf\asfd\tempLetter\filename

i wanted to remove "tempLetter" and before, which results "filename" only

i've tried replaceAll("\\*tempLetter\\$", "") it doesnt work

any idea?

thx

[JAVA-XML] extract a tree node, repeat it

giasens — Fri, 02 Feb 2007 19:54:42 +0800

actually i wanted to create a mailmerge like event, from a docx file

i'm able to unpackage docx, find the file

the problem now is, navigate through the document.xml
find a tree, look for a string, and replace it, and save as document.xml

-- b (has childnodes)
a
-- c (has childnodes)

it illustrates "a" is the parent node, and "b" & "c" has its own childnodes
the question is, how to extract the "b" nodes,
repeat the nodes, so i can do string replace
and finally save it.

SAX? any idea?

thx.

Help on SQL Optimization

giasens — Tue, 30 Jan 2007 11:15:35 +0800

Table A {A_no, A_luserid }
Table B {B_no, B_luserid }
Table AB {AB_no, AB_luserid, AB_Ano, AB_Bno }

Tables records can be insert by anyone
Table AB links up Table A & B

SELECT DISTINCT A.*
FROM tableA A, SEC_tableB B, SEC_tableA2B AB
WHERE (
B.B_no=233
AND AB.AB_Bno=B.B_no
AND A.A_no=AB.AB_Ano
)OR(
A.A_luserid='user'
)

I want to query a result with 2 condition
1. where B.B_no = 233
2. and records in Table A that created by a particular user

the problem is, in the 2nd condition, it doesn't use table B & AB,
and leads to many duplicate records, eliminates by usign Distinct

is there anyway to optimize the query, when the table is usused/referenced?

TQ.

Generating MsWord MailMerge

giasens — Mon, 22 Jan 2007 14:28:31 +0800

i've tried this Java bean word processing, which only changes the bookmarks
but i need to print more pages based on the data from database

haven't try Jakarta POI tho, but i think it's only simple write/read.
and it has been abandoned =.=;

i couldn't find any free libraries/classes.
any idea?

no need to suggest me openxml/wordML, which is my last resort =.=

tq

[SQL] select field that has min date range

giasens — Thu, 04 Jan 2007 15:35:17 +0800

table A { no, effectiveDate }

sample data
{ 1, 2006/01/01 }
{ 2, 2006/06/01 }
{ 3, 2006/12/01 }

min(abs(datediff(effectivedate, now()))) this will return my min range between effective date & current date

question: how can i get the effectiveDate THAT has the minimum range between effectiveDate & currentDate?

what the sql should look like? im realy can't think of

htmlentities

giasens — Fri, 27 Oct 2006 14:18:11 +0800

in my jsp page, i hav the following javascript code
where it will set the form txtfield value

function fnRandom(var1) {
document.frm.txt1.value = var1;
}

in my java code,
i retrieve record from db which contain htmlentities.
then i suppose to printout to html like this

out.print("<a href=\"javascript:fnRandom("DB_INPUT_STR");\">runJS</a>");
-----
my problem is
when my DB_INPUT_STR contain single quote/double quote or other htmlentities, it will break my javascript.

anyidea?

[Hardware] Can't Boot Up

giasens — Wed, 04 Oct 2006 01:33:02 +0800

i can't boot up my pc, no comes out on the screen
doesn't run POST check at all, just plain black

i suspected it's my mobo failure,
so i went on and bought 2nd hand, and replace the current 1

it started up with "plik plak", sounds like short circuit,
then i quickly turn off, but no hangus smell

so, later i turn on the pc again,
but it's the still the same.
pitch black, no POST beep/check
- power LED doesnt blink
- HDD LED doesnt blink
- HSF running
- PSU fan running

any idea? it's the PSU kapuk or CPU?

[SQL] produce a matrix-like result on sql

giasens — Fri, 22 Sep 2006 15:40:17 +0800

check the attachment.

how to produce the matrix-like result as shown on the left
where the columns are "step, range, amount"

Thanks,

Apple OEM Product?

giasens — Sun, 16 Jul 2006 01:45:19 +0800

i got this from another forum

there is this company claiming that they selling Apple Ipod Nano OEM

QUOTE

The outloook of the Apple Ipod MP4 player is exactly what you see in the Picture uploaded. This is not the original Apple IPOD that you see in the market, we imported. Later we might do SKD (Assembly) in Malaysia.

question is, is that legal?
erm. does apple give out the license to do OEM of their products?

Internet Explorer 7 Beta 3

giasens — Thu, 29 Jun 2006 23:56:14 +0800

QUOTE

Internet Explorer 7 (IE7) Beta 3 has been designed to make everyday tasks easier, provide dynamic security protection and improve the development platform and manageability. End user improvements include a streamlined interface, tabbed browsing, printing advances, improved search functionality, instant feeds (RSS), dynamic security protection, and more. Visit the Internet Explorer site for more information on IE7 Beta 3.

Source: http://msfn.org/comments.php?shownews=17602

Download: IE7 Beta 3 for Windows XP SP2
Download: IE7 Beta 3 for Windows Server 2003 SP1
Download: IE7 Beta 3 x64 Edition

VB temp recordset

giasens — Wed, 19 Apr 2006 18:52:19 +0800

How to create a temp recordset, which i later add in the fields.
not generated from table.

Dim rsTemp as ADODB.recordset

i wanna create a recordset which later i can perform

rsTemp.addNew
rsTemp!field1 = "asdf"
rsTemp!field2 = "asdf"
rsTemp.update

can anyone enlighten me pls? tq.

btw, how's rollbackTrans works using remoteDataControl.

TQTQ.