Lowyat.NET: Latest topics by yumish

Data Migration

yumish — Fri, 27 Jul 2007 14:57:20 +0800

Hi, is it possible to do data migration from an email platform to a web application?

I couldn't find any answer from Google.

Please enlighten me if you have any idea.

Thanks in advance.

How to reduce the electrostatic charges?

yumish — Tue, 30 Jan 2007 13:28:47 +0800

Hi,
I work in air-cond office for long hours and sleep with air-cond on sometimes. I found that I had lots of electrostatic charges recently. I always zapped when I touch metal surfaces, eg. car door, shopping trolly, monitor, door handle, etc. Quite painful sometimes. Yesterday morning, I even saw blue sparks when I uncovered my blanket after woke up!

Any way to reduce the electrostatic charges? It's annoying.

[Solved] PostgreSQL dblink

yumish — Mon, 08 Jan 2007 10:04:23 +0800

Hi,

I have installed PostgreSQL 7.3 with dblink.

I have 2 databases: 'database1' and 'database2'.

What i need is, whenever a new record is inserted into 'database1' , i want to insert the same record to 'database2' as well.

Anyone mind to share how this can be done as I couldn't find the proper documentation for dblink at PostgreSQL documentation.

Thanks!

Copy data from table to table within different DB

yumish — Thu, 04 Jan 2007 17:53:31 +0800

Hi,
I'm using PHP with PostgreSQL.

To copy data from one table to another table within the same database can use the following query:
INSERT INTO table2 SELECT * FROM table1 WHERE field1='value1';

My question is:
I have to copy data from one database's table to another database's table, and I was wondering if there is any way to do that than to have a lot of inserts one after another?

Thanks.

Foreigner work as part time in Malaysia

yumish — Thu, 14 Dec 2006 13:12:44 +0800

Hi, my friend's friend (foreigner) from overseas is having semester break soon and he wanted to come to work as part time in Malaysia for 4 months. Question is, does him need to get any permit in order to work here? Any advice? Any job out there for him?
TIA.

Trigger To Send Email

yumish — Wed, 11 Oct 2006 18:01:23 +0800

Hi,
My system currently have the send email feature using mail() from PHP. The problem is that the user need to click on 'Send Email' button to send the email. I would like to enhance it so that it could send out email on every 3 days or so. I have searched over the Internet and couldn't get any relevant example. Can you give me some idea / examples? What is the best form to trigger the system to send the email ? Do I need to write a C program or stored procedure or any other method? FYI, I'm using PostgreSQL + Linux Server.
Thanks in advance!

ASP - Handle Double Quotes (") in mailto function

yumish — Wed, 20 Sep 2006 10:32:10 +0800

Hi,
I'm using ASP to send email using the mailto function. Part of my codes are:

CODE

<%
title = "I want to add double ""quotes"" to the title"
message = "Show me how to add double quotes"
%>
<a href="mailto:?subject=<%=Replace(title, """", """)%>&body=<%=Quotes(message)%>">Email to Friends</a>

It should display in email (ms outlook) in this way:

Subject: I want to add double "quotes" to the title
Show me how to add double quotes

However, the Subject in the email is truncated and became:
Subject: I want to add double

I suspect it is because of the & in &quot. I tried to replace with ASCII (chr(34)) but it doesn't seem to work as well. Please help. Thanks.

Hard to put myself to sleep at night

yumish — Thu, 17 Aug 2006 13:38:25 +0800

I had this problem recently. I will go to bed around midnight. I tried to sleep but then I can only sleep after around 2am, then I ended up have not enough sleep for the next day. Any suggestion to solve this problem? FYI, I dun have any naps in the day. Thanks.

Help:Sum up values passed from php

yumish — Fri, 09 Jun 2006 14:34:03 +0800

CODE

<?
$a = 100;
$b = 20;

?><script>
var A = '<? print $a; ?>';
var B = '<? print $b; ?>';
var total = A+B;
alert(total);
</script><?

I need to get the total value of A plus B (120) in javascript. But I end up getting 10020 instead. Can anyone help me to solve this problem? Thanks in advance.

Need Help with Javascript

yumish — Fri, 26 May 2006 13:12:56 +0800

Hi,
Does anyone know how to remove the highlight (selected text) from the listbox using javascript?
TIA

PHP mail()

yumish — Tue, 07 Feb 2006 17:53:46 +0800

Hi, I have a question about the php mail() function.
For example:

CODE

$to = "ajdkfasff1256853@lalala.com";
$subject = "Hello";
$message = "Hi";
$from = "yumish@yahoo.com";
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'From: ' . $from . "\r\n";
mail($to, $subject, $message, $headers);

In this case, the email address of the recipient is invalid. Will the sender get an error message about that invalid recipient email address? If yes, how? Thanks.