Lowyat.NET: Latest topics by stfu

[WTB] Faulty Samsung Note 3

stfu — Wed, 27 Mar 2019 10:59:54 +0800

Item(s): Samsung Note 3

Price: Offer me

Warranty: N/A

Dealing method: COD only

Location: Bandar Seri Putra (Kajang) or Jalan Kilang (PJ)

Contact method/details: PM
---

Item(s) conditions: Faulty phone, but LCD must be working (need the LCD as spare part)

Visual Basic 2012 Layout & Navigation

stfu — Wed, 14 Jun 2017 10:58:09 +0800

Hi all,

I am in the process of creating a POC desktop system using VB 2012. Honestly I am quite a beginner with .NET technology, so there's a lot to catch up here. I would like to have suggestion from fellow coders on how to design the layout of a common VB 2012 program and the controls needed to develop it.

Since the system is intended for normal (basic computer knowledge) users, I would like to avoid doing system navigation & layout using normal drop-down menu (those File > New/Open/Save/Save As thingy). Instead, I prefer to develop something that is GUI-friendly (big buttons with image for navigation etc).

At the moment, I'm experimenting with MenuStrip to dynamically load the menu from database. If you guys have any easier/more feasible way, do share with me.

TIA.

Question with Regards to Offer to Purchase

stfu — Fri, 25 Sep 2015 11:34:52 +0800

Hello all,

I would like to seek opinions from fellow friends here (and would be best if you can provide your professional ones).

I engaged an agent for the purpose of buying a property. I have signed the Letter of Offer to Purchase for a property on 29 June 2015, and the seller signed the same agreement on 30 June 2015. Both signing process was witness by the same person (the agent). Booking fee of 3% was paid on 29 June 2015. Below are the clauses in the agreement.

1. 10% of the total price should be paid upon signing of S&P
2. Balance 90% to be paid within 90 days from the date of signing of S&P
3. S&P must be signed within 21 days from the date of acceptance of seller. In default of signing the S&P:
a) by buyer (provided there is no delay from the vendor/vendor's solicitor), deposit will be forfeited
b) by seller, deposit will be refunded (and will have performance cost shared between agent & buyer)
4. Stamp duty clauses
5. Handling over property clauses
6. GST clauses
7. Offer of Purchase is subject to acceptance of seller. If not agreed, deposit shall be fully refunded without any additional cost
8. The offer letter is a binding contract until S&P is signed
9. Deposit receipt clauses
10. If loan is not approved or approved less than 90%, deposit shall be fully refunded

For the info, I did not manage to secure any loan until the date of 31 Aug 2015 (21 working days after signed acceptance of buyer). The agent and seller agreed to wait for me to secure another loan (no written agreement for this). I managed to secure a loan last Monday but have yet to sign (or even see) the loan agreement. The loan approval was conveyed by phone call & WhatsApp message only.

My question is, if I would like to cancel the purchase now (25 Sept 2015) on the ground that I am no longer interested with this property, do the seller and agent have the rights to forfeit my deposit?

Thank you in advance for the input.

----------------
Added info:
- I do keep all WhatsApp conversation and e-mail for my reference

Framework for Data Entry

stfu — Thu, 03 Sep 2015 17:07:53 +0800

Hi all,

I need opinion on which framework (PHP/Java) that is suitable for creating data entry form. What I'm trying to achieve is to convert manual paper form into electronic format (imagine the form used for job application/register in JPN/etc). In addition to that, user should be able to upload supporting documents as well (PDF/DOC, less than 10MB in size). Once this is complete, I would then need to host this with any webhosting company, so need to take into consideration of whether the company supports the framework/language used or not. Also, since this is just only a few forms (less than 10), I don't think so it is feasible for me to go full-fledged on a very complicated framework. The framework suggested should be able to do minor modification on the UI (put logo, change font, etc).

I have tried to search in Google, but none seems to be helping enough. So far I have narrowed down the search to Laravel (PHP), ATK (PHP) and also ZK (Java). All comes with their pros and cons, but none really gives me the nudge yet. I would like to know opinion from fellow coders as you guys have your first hand experience in doing the actual development.

Thanks in advance.

[WTB] Seagate Backup Plus Portable Hard Drive

stfu — Fri, 24 Oct 2014 12:23:33 +0800

Item(s): Functioning Seagate Backup Plus Portable Hard Drive

Package includes: Hard Drive

Price: Offer me

Warranty: Offer me

Dealing method: Strictly COD

Location of seller: Cyberjaya (Office Hour), Jalan Ipoh/Batu Caves (After Office Hour)

Contact method/details: PM/Reply here

Age of item: As long as it is working fine

---

Item(s) conditions:

Picture:

Reason for sale: Kindly refer to the picture above (Link to Image) . I have the same kind of hard drive but my power connector (the thing on the right side of the picture) is believed to have been spoilt. I want to buy the exact hard drive model as in the picture (size from 500MB above) or if you are able to sell to me the power connector alone, that is even better.

Update: The hard drive itself is damaged, not the connector.

Eclipselink Join Query

stfu — Wed, 15 May 2013 09:51:59 +0800

Hi all,

I wanted to do a JOIN query between 2 tables using Eclipselink. I managed to do it if I use createNativeQuery method, but I need assistance on how to do this using JPQL. There are some tutorials on the web that I've looked through, but for each example given does not work. What I want to achieve is to list district names and their respective state name. Need help from fellow Java sifus here for some hint/help. Thanks in advance.

DB Structure

CODE

ref_state
----------
ID_STATE INT
STATE_CODE VARCHAR
STATE_NAME VARCHAR
STATUS INT

ref_district
------------
ID_DISTRICT INT
ID_STATE INT
DISTRICT_CODE VARCHAR
DISTRICT_NAME VARCHAR
STATUS INT

persistence.xml

CODE

<?xml version="1.0" encoding="UTF-8" ?>
<persistence xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
version="2.0" xmlns="http://java.sun.com/xml/ns/persistence">
<persistence-unit name="todos" transaction-type="RESOURCE_LOCAL">
<class>com.test.entity.State</class>
<class>com.test.entity.District</class>
<properties>
<property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver" />
<property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/testdb" />
<property name="javax.persistence.jdbc.user" value="root" />
<property name="javax.persistence.jdbc.password" value="qwerty" />

[bad html removed] EclipseLink should create the database schema automatically -->
[bad html removed] <property name="eclipselink.ddl-generation" value="create-tables" /> -->
<property name="eclipselink.ddl-generation.output-mode" value="database" />
</properties>
</persistence-unit>
</persistence>

Entity - State

CODE

package com.test.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="ref_state")
public class State {

@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(name="ID_STATE")
private int stateId;
@Column(name="STATE_CODE")
private String stateCode;
@Column(name="STATE_NAME")
private String stateName;
@Column(name="STATUS")
private int stateStatus;

-- getter/setter after this --

Entity - District

CODE

package com.test.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="ref_district")
public class District {

@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(name="ID_DISTRICT")
private int districtId;
@Column(name="ID_STATE")
private int stateId;
@Column(name="DISTRICT_CODE")
private String districtCode;
@Column(name="DISTRICT_NAME")
private String districtName;
@Column(name="STATUS")
private int districtStatus;

-- getter/setter after this --

App

CODE

package com.test.app;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import javax.persistence.Query;

import com.test.entity.District;
import com.test.entity.State;
import com.test.model.DistrictService;
import com.test.model.PersonServiceFactory;

public class OpenJPARelationTest {

private static EntityManagerFactory factory;

@SuppressWarnings("unchecked")
public static void main(String[] args) {
System.out.println("*********");
factory = Persistence.createEntityManagerFactory("todos");
EntityManager em = factory.createEntityManager();
Query q = null;
String query = "select d from District d where d.stateId = 10";
q = em.createQuery(query);
List<District> todoList = q.getResultList();
for (District todo : todoList) {
System.out.println(todo.getDistrictName());
}
System.out.println("Size: " + todoList.size());
System.out.println("*********");
}

}

Output of current code

CODE

*********
[EL Info]: 2013-05-15 09:33:23.415--ServerSession(1112466)--EclipseLink, version: Eclipse Persistence Services - 2.4.1.v20121003-ad44345
[EL Info]: connection: 2013-05-15 09:33:23.646--ServerSession(1112466)--file:/C:/stfu/Workspace/openjpa-test/bin/_todos login successful
SHAH ALAM
PETALING JAYA
SABAK BERNAM
AMPANG
HULU SELANGOR
KELANG
SEPANG
KAJANG
KUALA LANGAT
KUALA SELANGOR
SELAYANG
HULU LANGAT
GOMBAK
Size: 13
*********

[STOLEN CAR] Grey Nissan Skyline R-35

stfu — Fri, 02 Mar 2012 07:51:29 +0800

Location: Around Wangsa Maju Section 5 (office area near Wangsa Walk)

Time: Yesterday evening (1 March 2012)

Kindly notify or alert the police if you happen to find a grey-colored Nissan Skyline R-35 (reg no WQU 19). It is my boss's car and had just been robbed. Would like to request for mods to pin this. Thank you.

[STOLEN CAR] Grey Nissan Skyline R-35

stfu — Thu, 01 Mar 2012 19:07:16 +0800

Location: Around Wangsa Maju Section 5 (near Wangsa Walk)

Time: Just now (1 March 2012)

Kindly notify or alert the police if you happen to find a grey-colored Nissan Skyline R-35 (reg no WQU 19). It is my boss's car and had just been robbed. Thank you.

Closed. Please refer to here.

CADD Training Centre (M) Sdn Bhd

stfu — Mon, 22 Feb 2010 14:38:35 +0800

Hi all,

I received interview request from CADD Training Centre (M) Sdn Bhd for the position of IT Trainee. However a quick check with Google reveals that the company is also known as City Labs. This is a bit alarming as they use different name in Jobstreet and in real company website, as this is one of the tactics used by companies that say they provide training but end up asking candidates to do sales. Would like to know if any of you guys have or currently working with this company or have undergone such training with this company before. If yes, how is the environment looks like and whether I should proceed with the interview. Thanks in advance.

Update: I didn't go to the training

MySQL Convert Returns Empty Recordset

stfu — Mon, 14 Jul 2008 16:37:24 +0800

Table struct:
- id INT PRIMARY KEY, name VARCHAR(50), win VARCHAR(50), draw VARCHAR(50), lose VARCHAR(50)
- column win, draw and lose will always have numeric values. I just don't get why the db creator put VARCHAR(50) there and I don't have the authorization to change it.

SQL:
SELECT `name`, CONVERT(win, UNSIGNED) FROM table

Problem:
This SQL is run from ASP script and it works fine in localhost environment. However, once transferred to the web server the recordset will return empty data, meaning nothing will be returned at all. There is also no error produced, which giving queue that the SQL passes the recordset. Recordset status is open and not EOF for localhost, but status is open and EOF in web server. Both localhost and web server databases running MySQL 4.0.13. On localhost server is running on MyISAM, I think the same goes to web server (I can and will check if that is necessary). Is there any setting that causes this to happen?

Reset Windows Password Through Network

stfu — Wed, 06 Feb 2008 19:47:37 +0800

One of my client's servers (let's call it server A) had its passwd changed last night by a staff. Sadly the staff is kinda not very tech-savvy, he didn't even know he had accidentally changed the passwd (and he forgot the passwd). I'm at home right now and if possible, I don't want to go down just to reset the passwd. Had been finding ways to reset the passwd through LAN, because I still can access other servers (me at home > LogMeIn > server B > server A).

Tried to dump the SAM file with pwdump3 and read its content with JTR or rainbow table crack, but since I don't have the admin passwd I can't dump the SAM file. Worst is, there's only 1 admin account (administrator) and that is the account that the passwd is changed. That leaves pwdump3 and pspasswd out of question, since both tools need admin access to change passwd/generate SAM dump. Can't get SAM dump, so JTR, lophtcrack and rainbow table are also useless.

So would like to ask if anyone has any idea so that I don't have to go down at client's site tonight. Basically what I'm trying to achieve is I want to reset the passwd through network. I have LogMeIn access to the other servers, from there I can access server A. If there is still no solution until 9pm, I'll be going down just to reset it. TIA.

Btw, I'm not breaking in the server or something. I know all those 'pop in Knoppix cd' and stuffs, but those are useful if I'm physically at the server. I'm just lazy to go down there.

Person's Digital Signature

stfu — Thu, 28 Jun 2007 18:44:26 +0800

Hi,

My company is doing system for a client which allows customers to sign on a tablet and that signature will be padded to a digital form. Based on the tablet's API, the signature file is exportable but it is not reversible, meaning one cannot simply take the exported file and add the signature to another form for mischievous use. Furthermore, the signature is fixed with date and time of signing, which make the process of counterfeiting difficult. I would not say impossible, because I believe sooner or later someone will find a way to decrypt the file, but that's out of question as of now.

Now, the client is a bit concerned about whether the digital signature is applicable to be used in court cases should anything happens. In simple terms, will the digital form with the signature a valid proof or evidence should it be taken to court? I've been googling about digital signature act, but what I found is the digital certificate act which talks about public cert and private cert. However, I found this one clause that might be applicable to my scenario here.

QUOTE

"Digital Signature" is defined by the Act as a transformation of a message using an asymmetric cryptosystem such that a person having the initial message and the signer's public key can accurately determine whether the transformation was created using the private key that corresponds to the signer's public key and whether the message has been altered since the transformation was made.

taken from http://www.lawyerment.com.my/intellectual/computer2.shtml

Any of you guys ever happen to be in this situation before? The client is really concern in this matter and if my company can't prove that digital signature can be used in court, they are forced to print the form and have the customers to manually signed it. But by doing that, it'll beat the purpose of having a digital form altogether. Advice/Opinion is much appreciated.

Thanks in advance

VB6 MSCOMM and Hyperterminal

stfu — Tue, 22 May 2007 14:21:20 +0800

I have 2 COM ports connected together through RS232 serial-to-RJ45 cable. The converters and cable are tested using hyperterminal and are working perfectly. I set up 2 hyperterminals with the same baud rate etc and send one character from one port to the other, and it receives nicely. Then I send a 24-character string, also the other one receives corrently.

Then, I setup a test code using VB6 to capture data received from COM2 and to send through COM1. Both sending and listening COM use 9600,n,8,1 setting. When I use VB6 COM1 to send, hyperterminal on COM2 will pick up the string nicely. Problem is, when I set VB6 to listen to COM2, the string received is truncated into three 8-character strings. See example below for more understanding.

Hyperterminal listening:
VB6 sends AAAAAAAAAAAAAAAAAAAAAAAA
Hyperterminal receives AAAAAAAAAAAAAAAAAAAAAAAA

VB6 listening:
VB6 sends AAAAAAAAAAAAAAAAAAAAAAAA
VB6 receives
AAAAAAAA
AAAAAAAA
AAAAAAAA

Any reason for this weird behaviour? Explanation/Pointer for any explanation is fine. My code is as follows. TIA.

CODE

Select Case commReceive.CommEvent
Case comEvReceive:
sRecv = commReceive.Input
txtRecv.Text = txtRcv.Text & sRecv & vbCrLf
End Select

# Sign in VB6

stfu — Mon, 09 Apr 2007 16:15:30 +0800

CODE

#If SomeConditionHere Then

I want to know the purpose of the # sign in this code (VB6). I guess it does something with debug purpose or what, but I'm not sure. And I can't do searching with # sign in Google (or I don't know how, maybe), so I didn't get any helpful result either from Google. Can someone give the pointer to this. Thanks in advance.

SQLDMO Backup Using VB6.0

stfu — Fri, 01 Sep 2006 16:59:39 +0800

Hi all..

I'm doing this code to backup SQL Server database. The only thing I don't understand is the code fails if I define SQLDMO events to it, but works perfectly if I comment the event declaration. I'm not quite sure which part goes wrong and Google doesn't return workable/useful results either. I can live without the events, just that it's a lot nicer to be able to give the user some indication that the backup process is currently running. The error message returned is -2147221499 - [SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION. Thanks in advance.

Environment
OS - Win2k Server with SP3
DBMS - SQL Server 2000 Enterprise with SP4
Language - VB6.0 without SP

CODE

Option Explicit
Private oSQLServer As SQLDMO.SQLServer2, strMsgBox As String, strCmd As String
Private oBackup As SQLDMO.Backup2, oRestore As SQLDMO.Restore2
Dim WithEvents oBackupEvent As SQLDMO.Backup2
Dim WithEvents oRestoreEvent As SQLDMO.Restore2
Dim oFso As New Scripting.FileSystemObject

Private Sub BackupDatabase()
On Error GoTo ErrHandler
If oBackup Is Nothing Then Set oBackup = New SQLDMO.Backup2
If oBackupEvent Is Nothing Then Set oBackupEvent = oBackup <-- if I comment this line, code works fine
Me.MousePointer = vbHourglass
If Connect_SQLDB(DBServer, DBUser, DBPass) Then
If oFso.FileExists(DBFile) Then oFso.DeleteFile (DBFile)
Label1(6).Caption = "0%"
Label1(6).Refresh
With oBackup
.Database = DBName
.Files = IIf(InStr(1, DBFile, " ") > 0, "[" & DBFile & "]", DBFile)
.SQLBackup oSQLServer
End With
Call oSQLServer.Disconnect
Me.MousePointer = vbDefault
Debug.Print "Database backup process has been completed."
Else
Me.MousePointer = vbDefault
Debug.Print "Database connection cannot be made. Please check your network settings."
End If
Set oBackup = Nothing
Set oBackupEvent = Nothing
Exit Sub

ErrHandler:
Me.MousePointer = vbDefault
Debug.Print Err.Number & " - " & Err.Description
Call oSQLServer.Disconnect
Set oBackup = Nothing
Set oBackupEvent = Nothing
End Sub

Private Sub oBackupEvent_PercentComplete(ByVal Message As String, ByVal Percent As Long)
pBarBackup.Value = Percent
pBarBackup.Refresh
Label1(6).Caption = Percent & "%"
Label1(6).Refresh
End Sub