<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- generator="FeedCreator 1.7.2" -->
<rss version="2.0">
    <channel>
        <title>Lowyat.NET: Latest topics by Ee_</title>
        <description></description>
        <link>http://forum.lowyat.net/</link>
        <lastBuildDate>Wed, 25 Nov 2009 01:25:44 +0800</lastBuildDate>
        <generator>FeedCreator 1.7.2</generator>
        <item>
            <title>Rig with RM 4,000 Budget</title>
            <link>http://forum.lowyat.net/topic/1207870</link>
            <description>Closed the old one, too confusing &lt;br /&gt;&lt;br /&gt;So far, I&amp;#39;ve come up with this&lt;br /&gt;&lt;br /&gt;&lt;s&gt;&lt;b&gt;- C2Q Q9440 2.66 MHz (670)&lt;/b&gt;&lt;/s&gt;&lt;br /&gt;&lt;b&gt;- Intel i5 750 (739)&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Asus P7P55D (538)&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Kingston DDR3 1333MHz 2x2GB (285)&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- ASUS EN9600GT 512MB D3 256BIT (355) / Palit 9800GT (320) &lt;/b&gt;&lt;br /&gt;Got HDMI, good enough for my use, I think&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Creative SB Audigy Value (115)&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Wester Digital 1TB Black (330)&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Pioneer SATA DVDRW (90)&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Cooler Master CM690 Pure (299)&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- OCZ Stealth X Stream 500W (319)&lt;/b&gt;&lt;br /&gt;Want something silent, too much ? Underpower ? Got almost 0 knowledge about PSU&lt;br /&gt;&lt;br /&gt;&lt;s&gt;&lt;b&gt;- Samsung 23.6&amp;quot; 2494HS (780)&lt;/b&gt;&lt;/s&gt;&lt;br /&gt;&lt;b&gt;- Dell ST2310 (640)&lt;/b&gt;&lt;br /&gt;Support 1080 and has a HDMI input&lt;br /&gt;	&lt;br /&gt;&lt;u&gt;&lt;b&gt;Total: RM 3,675&lt;/b&gt;&lt;/u&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Running 24/7&lt;br /&gt;- Programming, 1080p movies&lt;br /&gt;- No heavy games&lt;br /&gt;- Must be NVidia GC (for Linux)&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;Comments ? Suggestions ? &lt;!--emo&amp;:lol:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/laugh.gif' border='0' style='vertical-align:middle' alt='laugh.gif' /&gt;&lt;!--endemo--&gt;</description>
            <author>Ee_</author>
            <category>Hardware Questions &amp;amp; Answers</category>
            <pubDate>Tue, 27 Oct 2009 17:35:43 +0800</pubDate>
        </item>
        <item>
            <title>New Rig</title>
            <link>http://forum.lowyat.net/topic/978352</link>
            <description>&lt;b&gt;Old request (outdated already, no need to read):&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;!--SPOILER BEGIN--&gt;&lt;div class=&quot;spoilertop&quot; onClick=&quot;openClose('034dc2c4ac5bcbef36d4635df3479b37')&quot; style=&quot;font-weight: bold&quot;&gt;&lt;u&gt;&amp;raquo; Click to show Spoiler - click again to hide... &amp;laquo;&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;spoilermain&quot; id=&quot;034dc2c4ac5bcbef36d4635df3479b37&quot; style=&quot;display:none&quot;&gt;&lt;!--SPOILER END--&gt;&lt;br /&gt;&lt;s&gt;&lt;br /&gt;[s]- Intel Core 2 Duo E8400 [RM 623]&lt;/s&gt;&lt;br /&gt;&lt;b&gt;- AMD 720 Tri-Corex3 2.8Ghz [RM 545]&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;Changed to this one as it&amp;#39;s cheaper and faster &lt;!--emo&amp;:lol:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/laugh.gif' border='0' style='vertical-align:middle' alt='laugh.gif' /&gt;&lt;!--endemo--&gt;&lt;br /&gt;&lt;br /&gt;&lt;s&gt;- Asus P5Q SE [RM 380]&lt;/s&gt;&lt;br /&gt;&lt;b&gt;-  MSI MS7551 [RM 355]&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;s&gt;- Kingston Hyper-X KHX8500D2T1K2 CL5 (2x2GB) [RM 325]&lt;/s&gt;&lt;br /&gt;&lt;b&gt;- Kingston Hyper-X KHX8500AD2K2 CL7 DDR2 (2x2GB) [RM 265]&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;Coz it&amp;#39;s 1066Mhz ?&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- MSI N9500 GT [RM 250]&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;Coz it&amp;#39;s nVidia (better support in Linux)&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Cooler Master - Real Power RS520-ASAA [RM 370]&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;Not sure why I chose this one, I think it&amp;#39;s too much but the spec sounds so cool, is there any PSU that&amp;#39;s quiet priced under RM 350 ?&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- 1TB TeraBytes 32M WD [RM 359]&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;One hardisk is enough&lt;br /&gt;&lt;br /&gt;&lt;s&gt;- Samsung DVD Writer [RM 79]&lt;/s&gt;&lt;br /&gt;&lt;b&gt;- Pioneer DVD Writer [RM 89]&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;This one is not available at PCDepot, but I&amp;#39;m willing to look for it somewhere else.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Floppy Disk [RM 28]&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;A must &lt;!--emo&amp;:lol:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/laugh.gif' border='0' style='vertical-align:middle' alt='laugh.gif' /&gt;&lt;!--endemo--&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- 24&amp;quot; Samsung - T240 [RM 1199]&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;Sticking to this one&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Cooler Master Casing [RM 250]&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;Already found the one I like&lt;br /&gt;&lt;br /&gt;&lt;b&gt;Total: RM 3710&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;Purposes&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;- Mostly 24/7&lt;br /&gt;- Heavy downloader (RS), so downloading TV Series, Movies, all in 720p&lt;br /&gt;- Editing photos&lt;br /&gt;- Programming&lt;br /&gt;- No heavy graphic gaming&lt;br /&gt;&lt;br /&gt;&lt;b&gt;Budget: &amp;lt; RM 3900&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;I can only choose items from PCDepot, but, if it&amp;#39;s important enough, I&amp;#39;ll look for somewhere else. Here&amp;#39;s a screenshot for available mobos and GC&lt;br /&gt;&lt;br /&gt;&lt;img src='http://img120.imageshack.us/img120/2708/screenshotmcj.jpg' border='0' alt='user posted image' /&gt;&lt;br /&gt;[/s]&lt;br /&gt;Thanks for all the comments, I know I can depend on LYN people &lt;!--emo&amp;:lol:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/laugh.gif' border='0' style='vertical-align:middle' alt='laugh.gif' /&gt;&lt;!--endemo--&gt;&lt;br /&gt;&lt;br /&gt;&lt;!--SPOILER DIV--&gt;&lt;/div&gt;&lt;!--SPOILER DIV--&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;New one&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;!--SPOILER BEGIN--&gt;&lt;div class=&quot;spoilertop&quot; onClick=&quot;openClose('353092876effbe0d03742366a65756e5')&quot; style=&quot;font-weight: bold&quot;&gt;&lt;u&gt;&amp;raquo; Click to show Spoiler - click again to hide... &amp;laquo;&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;spoilermain&quot; id=&quot;353092876effbe0d03742366a65756e5&quot; style=&quot;display:none&quot;&gt;&lt;!--SPOILER END--&gt;&lt;br /&gt;So far, I&amp;#39;ve come up with this:&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- C2Q Q9440 2.66 MHz (670)&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Motherboard: ???&lt;/b&gt;&lt;br /&gt;Dunno which one, I&amp;#39;m thinking one that supports DDR3, or is it too much ?&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- RAM: ???&lt;/b&gt;&lt;br /&gt;Depends on motherboard and probably will go for a 2x2GB module&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- ASUS EN9600GT 512MB D3 256BIT (355)&lt;/b&gt;&lt;br /&gt;Got HDMI, good enough for my use &lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Creative SB Audigy Value (115)&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Wester Digital 1TB Black (330)&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Pioneer SATA DVDRW (90)&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Cooler Master CM690 Pure (299)&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- OCZ Stealth X Stream 500W (319)&lt;/b&gt;&lt;br /&gt;Want something silent, too much ? Underpower ? Got almost 0 knowledge about PSU&lt;br /&gt;&lt;br /&gt;&lt;b&gt;- Samsung 23.6&amp;quot; 2494HS (780)&lt;/b&gt;&lt;br /&gt;Support 1080 and has a HDMI input&lt;br /&gt;	&lt;br /&gt;&lt;u&gt;&lt;b&gt;Total: RM 2958&lt;/b&gt;&lt;/u&gt;&lt;br /&gt;&lt;br /&gt;Comments ? Suggestions ? Pleaase ? &lt;!--emo&amp;:lol:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/laugh.gif' border='0' style='vertical-align:middle' alt='laugh.gif' /&gt;&lt;!--endemo--&gt;&lt;br /&gt;&lt;!--SPOILER DIV--&gt;&lt;/div&gt;&lt;!--SPOILER DIV--&gt;&lt;br /&gt;&lt;br /&gt;I just got the fund, hopefully, I can buy a new rig this time, already tired looking at my laptop &lt;!--emo&amp;:lol:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/laugh.gif' border='0' style='vertical-align:middle' alt='laugh.gif' /&gt;&lt;!--endemo--&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;Purposes:&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;- Mostly 24/7&lt;br /&gt;&lt;b&gt;- Heavy downloader (RS), will start layan 1080p or 720p&lt;/b&gt;&lt;br /&gt;- Editing photos&lt;br /&gt;- Programming&lt;br /&gt;- No heavy graphic gaming&lt;br /&gt;&lt;br /&gt;&lt;b&gt;Around: RM 4,000 (But no need to spend all)&lt;/b&gt; &lt;br /&gt;&lt;br /&gt;&lt;b&gt;Notes:&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;- Prefer Intel CPU&lt;br /&gt;- Graphic card must be NVidia due to its support in Linux&lt;br /&gt;- No need for speaker, already have one&lt;br /&gt;- No need for weird casing, casual one should be ok&lt;br /&gt;- Will probably overclock the rig in the future, if needed&lt;br /&gt;- If possible, a rig that is &amp;#39;silent&amp;#39;&lt;br /&gt;- LCD Monitor must sapot 1080p</description>
            <author>Ee_</author>
            <category>Hardware Questions &amp;amp; Answers</category>
            <pubDate>Fri, 27 Mar 2009 12:21:18 +0800</pubDate>
        </item>
        <item>
            <title>Venturing into J2EE</title>
            <link>http://forum.lowyat.net/topic/918060</link>
            <description>Hi..&lt;br /&gt;&lt;br /&gt;I would like to ask opinions from anyone who got experiences in J2EE. I&amp;#39;m thinking of trying J2EE as part of my new knowledge. I myself has some knowledge in web programming especially PHP (built myself a portal engine back then). I also got some experience in Java itself as I&amp;#39;m involved in developing Java desktop application everyday using Swing (J2SE). During my study time, I&amp;#39;ve developed a simple online shop using JSP and Servlet, but consider it all gone since it has been years since the last time I use JSP.&lt;br /&gt;&lt;br /&gt;So, now the problem is I don&amp;#39;t know how to start. I&amp;#39;ve been reading some stuffs, there are things called web framework in J2EE such as Struts, JSP, JWT, and so on. The question is, which one should I take first ? Heck, I don&amp;#39;t even know which server should I use, Tomcat or Glassfish. However, I&amp;#39;m thinking of starting with JSF, Icefaces for the Ajax engine and Glassfish as the server. Reason, simply because there are from Sun and I&amp;#39;ll be using Netbeans as my primary IDE (has been using it for ages in developing my Swing apps). So, did I choose the corrent framework and server ? &lt;br /&gt;&lt;br /&gt;My goal is to create a web application that uses MySQL extensively. There will be hundreds of people logging in everyday and checking for new informations almost every minutes. Long term goal is to create some kind of a portal that will combine applications into one place. So, any advice for a newbie ?</description>
            <author>Ee_</author>
            <category>Codemasters</category>
            <pubDate>Tue, 27 Jan 2009 16:32:08 +0800</pubDate>
        </item>
        <item>
            <title>Converting VB to Java</title>
            <link>http://forum.lowyat.net/topic/897950</link>
            <description>Hi..&lt;br /&gt;&lt;br /&gt;I&amp;#39;m not really sure how to ask this, but I&amp;#39;ll try my best. So, I&amp;#39;m creating an application in Java, an app to read Mifare 1K card. We&amp;#39;ve already got a working application but it&amp;#39;s in VB 6. I also got the sample application where all the codes are visible. What I&amp;#39;m trying to do here is understanding the all the commands sent from the application to the reader. In order to do that, I tried printing out the passing values as much as I can. But then, I got stuck at some functions which load itself from a DLL. The source for the DLL, which is a class (a file with .cls) is also provided and all the hidden functions are all there. &lt;br /&gt;&lt;br /&gt;So, is it possible for me to add some Debug.Print in the cls file and then recompile it back to DLL and replace the previous DLL so that I can get the information that I needs ? If can, then, how to do it ? I tried to create a new project ActiveX DLL project and load the cls file, but I got an error saying &amp;quot;No Creatable Public Component Detected&amp;quot;. Any comments ? &lt;br /&gt;&lt;br /&gt;p/s : I&amp;#39;m totally zero in VB.</description>
            <author>Ee_</author>
            <category>Codemasters</category>
            <pubDate>Tue, 06 Jan 2009 09:52:35 +0800</pubDate>
        </item>
        <item>
            <title>Printing to Zebra S4M using ZPL 2</title>
            <link>http://forum.lowyat.net/topic/691073</link>
            <description>Hi..&lt;br /&gt;&lt;br /&gt;After a long searching in google I still can&amp;#39;t find a way to print to my S4M using ZPL II.&lt;br /&gt;&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;&lt;br /&gt;import javax.print.Doc;&lt;br /&gt;import javax.print.DocFlavor;&lt;br /&gt;import javax.print.DocPrintJob;&lt;br /&gt;import javax.print.PrintException;&lt;br /&gt;import javax.print.PrintService;&lt;br /&gt;import javax.print.PrintServiceLookup;&lt;br /&gt;import javax.print.SimpleDoc;&lt;br /&gt;import javax.print.attribute.PrintServiceAttribute;&lt;br /&gt;import javax.print.attribute.standard.PrinterName;&lt;br /&gt; &lt;br /&gt;public class SimplePrint {&lt;br /&gt; &lt;br /&gt;    public static void main&amp;#40;String&amp;#91;&amp;#93; args&amp;#41; {&lt;br /&gt;        &lt;br /&gt;        try {&lt;br /&gt;            &lt;br /&gt;            PrintService psZebra = null;&lt;br /&gt;            String sPrinterName = null;&lt;br /&gt;            PrintService&amp;#91;&amp;#93; services = PrintServiceLookup.lookupPrintServices&amp;#40;null, null&amp;#41;;&lt;br /&gt;            &lt;br /&gt;            for &amp;#40;int i = 0; i &amp;#60; services.length; i++&amp;#41; {&lt;br /&gt;                &lt;br /&gt;                PrintServiceAttribute attr = services&amp;#91;i&amp;#93;.getAttribute&amp;#40;PrinterName.class&amp;#41;;&lt;br /&gt;                sPrinterName = &amp;#40;&amp;#40;PrinterName&amp;#41; attr&amp;#41;.getValue&amp;#40;&amp;#41;;&lt;br /&gt;                &lt;br /&gt;                if &amp;#40;sPrinterName.toLowerCase&amp;#40;&amp;#41;.indexOf&amp;#40;&amp;#34;zebra&amp;#34;&amp;#41; &amp;#62;= 0&amp;#41; {&lt;br /&gt;                    psZebra = services&amp;#91;i&amp;#93;;&lt;br /&gt;                    break;&lt;br /&gt;                }&lt;br /&gt;            }&lt;br /&gt;            &lt;br /&gt;            if &amp;#40;psZebra == null&amp;#41; {&lt;br /&gt;                System.out.println&amp;#40;&amp;#34;Zebra printer is not found.&amp;#34;&amp;#41;;&lt;br /&gt;                return;&lt;br /&gt;            }&lt;br /&gt;            DocPrintJob job = psZebra.createPrintJob&amp;#40;&amp;#41;;&lt;br /&gt; &lt;br /&gt;            String s = &amp;#34;^XA^FO100,40^BY3^B3,,30^FD123ABC^XZ&amp;#34;;&lt;br /&gt; &lt;br /&gt;            byte&amp;#91;&amp;#93; by = s.getBytes&amp;#40;&amp;#41;;&lt;br /&gt;            DocFlavor flavor = DocFlavor.BYTE_ARRAY.AUTOSENSE;&lt;br /&gt;            Doc doc = new SimpleDoc&amp;#40;by, flavor, null&amp;#41;;&lt;br /&gt;            job.print&amp;#40;doc, null&amp;#41;;&lt;br /&gt;            &lt;br /&gt;        } catch &amp;#40;PrintException e&amp;#41; {&lt;br /&gt;            e.printStackTrace&amp;#40;&amp;#41;;&lt;br /&gt;        }      &lt;br /&gt;    }&lt;br /&gt;}&lt;br /&gt;&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;&lt;br /&gt;&lt;br /&gt;Using the code above, I only got the same text sent, as if the printer do not understand I&amp;#39;m sending string based on ZPL II&lt;br /&gt;&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;^XA^FO100,40^BY3^B3,,30^FD123ABC^XZ&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;&lt;br /&gt;&lt;br /&gt;I&amp;#39;m currently using Linux and JDK 1.6u5. The configurations for the Zebra are also in the default mode. I&amp;#39;ve tested string above using FTP which print out a barcode just fine. &lt;br /&gt;&lt;br /&gt;So, can anyone tell me why my printer doesn&amp;#39;t understand the ZPL code that I sent ? Thanks in advance.</description>
            <author>Ee_</author>
            <category>Codemasters</category>
            <pubDate>Wed, 07 May 2008 18:54:26 +0800</pubDate>
        </item>
        <item>
            <title>Database Design and Data Retrieval</title>
            <link>http://forum.lowyat.net/topic/491219</link>
            <description>Hi..&lt;br /&gt;&lt;br /&gt;I need opinions about my database design. I&amp;#39;m currently working on an inventory project. The system is almost finished, meaning that I&amp;#39;ve designed all the database and codes on how to get the data. Roughly, my main database design looks like this:&lt;br /&gt;&lt;br /&gt;item &amp;lt;-- review &amp;lt;-- action &amp;lt;-- in &amp;lt;-- out&lt;br /&gt;&lt;br /&gt;Table &amp;#39;in&amp;#39; refers to the table to stores the information about the delivery of the &amp;#39;item&amp;#39; including the DO, expiry date, batch number and so on. &amp;#39;out&amp;#39; is used to record the usage of the &amp;#39;items&amp;#39; such as when the &amp;#39;item&amp;#39; was taken out from the inventory. &amp;#39;action&amp;#39; stores the buying information such as price and other stuffs like PO number.&lt;br /&gt;&lt;br /&gt;After inserting around 3000 records for the old transactions (from this January to July), my system starting to take time to load the balance available in the stock for the item requested. So, I started to &amp;#39;upgrade&amp;#39; the query and ended up using MySQL subquery. The new query did the job greatly and reduced the amount taken to process the query from 10 seconds to almost 0 seconds.&lt;br /&gt;&lt;br /&gt;I&amp;#39;m getting worried about the amount transaction done everyday by the system (for the remaining months, another 6000 or more data will be added). A friend suggested to me that I should use a table where the total remaining of the item is stored in a field meaning that I will add or substract from it everytime an item was accepted or being taken out. But I don&amp;#39;t think it&amp;#39;s possible in my system since if I use that method, then, I won&amp;#39;t know the price of the items coz the remaining of the item might comes from several delivery and order which contains different price, DO and expiry date.&lt;br /&gt;&lt;br /&gt;FYI, right now to get the balance of an item, I calculate it using MySQL, roughly like this = SUM(in) - SUM(out).&lt;br /&gt;&lt;br /&gt;So, my questions is:&lt;br /&gt;&lt;br /&gt;I&amp;#39;m thinking to add another field to the &amp;#39;action&amp;#39; which is like a status that is, if the item from the purchase has been used, I would set it to &amp;#39;1&amp;#39;, if there are still remaining balance, I will set it to &amp;#39;0&amp;#39;. With this method, my query won&amp;#39;t have to calculate all data, only the data which is set to &amp;#39;0&amp;#39;. Will this work for good ? Or do I have to use calculation in my application programming, not the query ?&lt;br /&gt;&lt;br /&gt;Sorry for the long post.. if anyone has any question, I&amp;#39;d be glad to answer it. Thanks  in advance.&lt;br /&gt;&lt;br /&gt;If it helps, I&amp;#39;m using Java for this system.</description>
            <author>Ee_</author>
            <category>Codemasters</category>
            <pubDate>Fri, 20 Jul 2007 14:29:13 +0800</pubDate>
        </item>
        <item>
            <title>Tiny black dots  thing on the nose</title>
            <link>http://forum.lowyat.net/topic/435333</link>
            <description>I know there&amp;#39;s a product, something like a sticker to put on the top of the nose so that when you pull it off, the black dots will come off too. The problem is, I don&amp;#39;t know what it is called. So, anyone ? Maybe I should just use duct tape &lt;!--emo&amp;:lol:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/laugh.gif' border='0' style='vertical-align:middle' alt='laugh.gif' /&gt;&lt;!--endemo--&gt;</description>
            <author>Ee_</author>
            <category>Health &amp;amp; Fitness</category>
            <pubDate>Sun, 01 Apr 2007 11:27:10 +0800</pubDate>
        </item>
        <item>
            <title>MySQL Query</title>
            <link>http://forum.lowyat.net/topic/425565</link>
            <description>This is the table&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;&lt;br /&gt;mysql&amp;#62; desc harga;&lt;br /&gt;+-------------------+---------+------+-----+------------+----------------+&lt;br /&gt;| Field             | Type    | Null | Key | Default    | Extra          |&lt;br /&gt;+-------------------+---------+------+-----+------------+----------------+&lt;br /&gt;| id                | int&amp;#40;11&amp;#41; |      | PRI | NULL       | auto_increment |&lt;br /&gt;| id_alat           | int&amp;#40;11&amp;#41; | YES  |     | NULL       |                |&lt;br /&gt;| id_pembekal       | int&amp;#40;11&amp;#41; | YES  |     | NULL       |                |&lt;br /&gt;| harga             | double  | YES  |     | NULL       |                |&lt;br /&gt;| kuantiti_per_unit | int&amp;#40;11&amp;#41; | YES  |     | 0          |                |&lt;br /&gt;| tarikh            | date    | YES  |     | 0000-00-00 |                |&lt;br /&gt;+-------------------+---------+------+-----+------------+----------------+&lt;br /&gt;&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;&lt;br /&gt;&lt;br /&gt;This is the sample data&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;&lt;br /&gt;mysql&amp;#62; select * from harga;&lt;br /&gt;+----+---------+-------------+-------+-------------------+------------+&lt;br /&gt;| id | id_alat | id_pembekal | harga | kuantiti_per_unit | tarikh     |&lt;br /&gt;+----+---------+-------------+-------+-------------------+------------+&lt;br /&gt;|  1 |       3 |           8 |    15 |                12 | 2007-03-10 |&lt;br /&gt;| 29 |       1 |           2 |    10 |                15 | 2007-03-05 |&lt;br /&gt;| 27 |       1 |           1 |    15 |                12 | 2007-03-10 |&lt;br /&gt;| 30 |       1 |           2 |    16 |                24 | 2007-03-15 |&lt;br /&gt;+----+---------+-------------+-------+-------------------+------------+&lt;br /&gt;&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;Result&amp;#39;s requirements: &lt;/b&gt;&lt;br /&gt;- id_alat = 1&lt;br /&gt;- Every result must return only 1 row for each id_pembekal&lt;br /&gt;- I&amp;#39;m using MySQL 4.0.15a&lt;br /&gt;&lt;br /&gt;&lt;b&gt;Explanation&lt;/b&gt;&lt;br /&gt;Actually, I want to display the latest price for id_alat = 1 from each pembekal, which means I don&amp;#39;t want the old price to be displayed together with the latest price. The result should return row 30 and 27 since both of them are the latest price for their pembekal.&lt;br /&gt;&lt;br /&gt;I&amp;#39;ve tried using GROUP BY and ORDER BY and even using MAX for the `tarikh`, but it never return the correct result. So, does anyone has any idea on how to do this simple query ?  &lt;!--emo&amp;:lol:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/laugh.gif' border='0' style='vertical-align:middle' alt='laugh.gif' /&gt;&lt;!--endemo--&gt;</description>
            <author>Ee_</author>
            <category>Codemasters</category>
            <pubDate>Mon, 12 Mar 2007 16:46:11 +0800</pubDate>
        </item>
        <item>
            <title>100% CPU Load</title>
            <link>http://forum.lowyat.net/topic/415730</link>
            <description>I just bought a new WD sata2 hardisk. The thing is that every time I wanna copy from other hardisk to this new hardisk, the CPU load will go up to 100%. I got another hardisk (sata1) and there&amp;#39;s no problem with it. Btw, my motherboard only support sata1 hardisk. Is that the problem ? My mobo use Nforce chipset.</description>
            <author>Ee_</author>
            <category>Technical Support</category>
            <pubDate>Tue, 20 Feb 2007 06:50:23 +0800</pubDate>
        </item>
        <item>
            <title>Maybank2u Bill Payment</title>
            <link>http://forum.lowyat.net/topic/378389</link>
            <description>Hi.. wanna comfirm something, did Maybank ask for TAC request when using their online bill payment? Coz if not, that will be a very dangerous security hole.. can anyone comfirm this ?</description>
            <author>Ee_</author>
            <category>Internet Related</category>
            <pubDate>Wed, 06 Dec 2006 10:36:00 +0800</pubDate>
        </item>
        <item>
            <title>FlashGet v1.80 Beta</title>
            <link>http://forum.lowyat.net/topic/370377</link>
            <description>&lt;b&gt;Changelog&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;+ &lt;b&gt;BitTorrent&lt;/b&gt; files download support&lt;br /&gt;+ Compatible with Vista&lt;br /&gt;* speed up the http download&lt;br /&gt;* new interface&lt;br /&gt;* bug fixed&lt;br /&gt;&lt;br /&gt;&lt;b&gt;&lt;a href='http://www.flashget.com/en/download.htm' target='_blank'&gt;Download&lt;/a&gt;&lt;/b&gt;</description>
            <author>Ee_</author>
            <category>Latest Updates</category>
            <pubDate>Mon, 20 Nov 2006 22:03:52 +0800</pubDate>
        </item>
        <item>
            <title>Pegawai Sistem Maklumat (F41)</title>
            <link>http://forum.lowyat.net/topic/353475</link>
            <description>Anyone got any info about this job ? I just got this job at a local hospital.. did some research but was hoping to hear from anyone who already has experience or knows about it.. thanks in advance.</description>
            <author>Ee_</author>
            <category>Jobs &amp;amp; Careers</category>
            <pubDate>Fri, 13 Oct 2006 21:31:25 +0800</pubDate>
        </item>
        <item>
            <title>Send SMS from my PC</title>
            <link>http://forum.lowyat.net/topic/267061</link>
            <description>Is it possible to send sms from my PC using PHP scripts ? I don&amp;#39;t want to use SMS gateway which requires me to subscribe to their service. I just want to use my Nokia 6600 (if possible) connected using Bluetooth to send the sms. &lt;br /&gt;&lt;br /&gt;It&amp;#39;s something like this :&lt;br /&gt;User receive new msg in portal -&amp;gt; portal send sms to user -&amp;gt; send the text to my nokia 6600 -&amp;gt; send to maxis -&amp;gt; send to the user.&lt;br /&gt;&lt;br /&gt;Anyone can help ? What are the tools ? &lt;br /&gt;&lt;br /&gt;My specs :&lt;br /&gt;&lt;br /&gt;PHP 5&lt;br /&gt;Apache 2&lt;br /&gt;Windows XP&lt;br /&gt;Phone : Nokia 6600&lt;br /&gt;Telco : Maxis&lt;br /&gt;&lt;br /&gt;</description>
            <author>Ee_</author>
            <category>Codemasters</category>
            <pubDate>Thu, 23 Mar 2006 13:35:19 +0800</pubDate>
        </item>
    </channel>
</rss>
