Ooh … Begitu! I see, I see …

Icon

Setelah kelayapan di internet, cari-cari info dari sana-sini dan bongkar pasang tips (terutama programming), akhirnya baru sadar … ternyata begitu caranya … [all about tricks and tips I have found during my work as programmer.]

Shirt from Zazzle.com

Sorry for not updating for such a long time. I’ve been in long slumber on programming field. Nowadays I just wonder if I should go back to programming or change direction to a new working field.

By the way, I’ve gotten a new hobby lately … surfing design sites. Just wondering, anyone could give me a feedback on which sites to start selling design without entering any competition on the sites? I mean just selling them as products. I found Zazzle.com, however I want to know more about that site.

I just checked out one shop and it looks interesting. I think I’ll try to figure things out with sites similar like this.

MetalGear graffiti Shirt from Zazzle.com.

Anyone can suggest me any urls / blogs that are talking about that site or any similar sites? Thanks for your feedback(s) through the comment form. 🙂

Advertisements

Filed under: design, , ,

get rows of dynamic latest date(s)

…. sorry for not updating for such a long time. 😛
just got a mail from a friend recently. probably this is some idea to share:


yo, Byeol. got a problem here. I have a table (FB) where I need to store every month’s stock of any available Product:

CREATE TABLE TSTOCK (
	THEDATE			DATE NOT NULL,
	PRODUCTID		VARCHAR(30) NOT NULL,
	COST			DOUBLE PRECISION DEFAULT 0 NOT NULL,
	LASTSTOCK		DOUBLE PRECISION DEFAULT 0 NOT NULL
);
ALTER TABLE TSTOCK ADD PRIMARY KEY (THEDATE, PRODUCTID);

the problem is … how to get only the last stocks of every available Product? the last date of each product might be different, like a certain product might be not updated this month but its last date was last month, while the others last dates are within this month. so basically, what I need is calling each Product’s last date row.
thanks in advance!

– Jack

hmmm …. Jack, you meant this one?

select s.* from TSTOCK s
where s.THEDATE = (select first 1 THEDATE from TSTOCK 
	where (PRODUCTID = s.PRODUCTID)
	order by THEDATE desc)

anyone got a better idea??

Filed under: Firebird, , , ,

SMS Gateway, oh SMS Gateway …

* still cursing herself after posting a bubbling in her other blog with the same title. *

Guys … do you know where is the place to get a lot of AT Commands manuals or references? Especially for the modems, not just for mobile phones. Please help. Many thanks for your attention and help. ^^

…….. ah yes, I am a “she”. 😛

Filed under: Delphi programming, Java programming, , ,

PC Media Antivirus (PCMAV) 1.2 Final Release

Hi Indonesian Friends, sorry for the late showing up of this update. I’ve been really busy during this April, also have had to skip some online hours because of my health problems, and just managed to update the latest news about PCMAV 1.2 Final Release.

This is from Indonesian PC Media magazine edition 05/2008, the same files I got from Maseko blog (I have the magazine but my DVD drive was broken back then). The latest update of PCMAV Final Release, PC Media Antivirus (PCMAV) 1.2. I think some of you have gotten the same files from Maseko blog (maseko.com).

You can download the files from Maseko blog, you can also download them from the links I have provided here.

Latest PCMAV download:

PCMAV 1.2 (2.17 MB) | PCMAV 1.2 Update Build #4 (86.94 KB)

Make sure to extract the file PCMAV.vdb into the same directory with PCMAV 1.2.

More information can be found at the Readme.txt file, and also at maseko.com, Maseko has explained it better and I believe the information is complete there. 🙂

Term of Usage:

Always, if you want to distribute the same files, please distribute the files completely without any modification and always use them for non-profit usages only. My intention is just to share the files with all PCMAV faithful users, as I know we do need PCMAV to take care of the local viruses in Indonesia.

By downloading the files, you have understood and acknowledged the usage of these files as stated by the end-user lisence within the Readme.txt. (Make sure you will always read the Readme.txt)

PC Media Antivirus (PCMAV) 1.2 Final Release
Copyright (c) 2006-2008 Majalah PC Media, a member of Pinpoint Publications

Filed under: anti virus,