Friday, March 4, 2011

CrazyEngineers Forum - Computer Science & IT Engineering

CrazyEngineers Forum - Computer Science & IT Engineering


how to discard sent mail ?

Posted: 03 Mar 2011 07:28 AM PST

Is there any alternate to discard sent mail in gmail ? :(

Routing and Remote Access in Windows Server 2008 R2

Posted: 03 Mar 2011 02:53 AM PST

I recently install windows server 2008 R2 as my home server. It has two NIC card, one connected to internet, and other connected to my private network. Now I enable Routing and Remote Access Role for accessing internet from my private network. It work fine few days, but now it stop working. I can ping my home server; also I am able to use internet on server; but no internet on private network. I use CCProxy, it work fine.

I try disable and re enable service , sometimes it work some times not. I am not very faimilier to these things, so I need your help to solve this problem.

Thank You.

Implementation for tag based mail system by JOINS using MySQL Database

Posted: 03 Mar 2011 02:09 AM PST

This is the same thing we studied in our Database Management Systems. This is a practical use of JOINS. Consider this problem description:

Problem:
I want to create a database table in which, I want to have an attribute called label. It should be able to have multiple values and if I want records, where label = value, it should come for all. I hope you understand my question.

Database / Table: Mails

Description
id – Primary Key, Integer, Autoincrement.
subject – Varchar, 50
label – should be an array of labels. Each may have different lengths. (i.e. a mail may contain 2 labels, another may have 5, another may don't have any!)

Records
1, My first mail, {inbox, personal}
2, Welcome to our company, {official}
3, Mr. T has added you on this!, {friends, inbox}

Now if I give a command,
Code:

select * from Mails where label = inbox
The result should be
1, My first mail, inbox, personal
3, Mr. T has added you on this!, friends, inbox

No comments:

Post a Comment