ASP Email Notifications

Question

0.00/5 (No votes)

See more:

I'll appreciate any assistance on this. The scenario;

I have a database table with the following sample records;

data1------------dt2-----data3------data4--------data5------data6
Brewing Plant----2------10000------11/3/2012---1136-------person1@yahoo.com
Brewing Plant----2------10000------11/3/2012---1136-------person1@yahoo.com
Car Plant---------1------5000-------11/3/2012---568--------person1@yahoo.com
Brewing Plant----1------5000-------11/3/2012---568--------person2@yahoo.com
Car Plant---------4------20000------11/3/2012---2272------person2@yahoo.com
Brewing Plant----3------15000------11/3/2012---1704------person3@yahoo.com

This is my requirement:
I want just one notification email each sent to theses various persons with their information, e.g;

Person1 should receive an email like
Data1------------dt2---data5
Brewing Plant----4------2272
Car Plant---------1------568

while Person2 should receive an email like
Data1------------dt2---data5
Brewing Plant----1------568
Car Plant---------4------2272
and so on.

I am using classic ASP and mySQL

Thanks for your anticipated assistance.

Posted 26-Nov-12 23:41pm

Wale Bello

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

esonparedes · Answer 1 · 2012-11-27T15:26:00

SQL

SELECT data1, data16, SUM(dt2), MIN(data5)&&MAX(data5)
FROM records
ORDER BY data6 ASC
GROUP BY data6, data1

Use SUM() for adding all the same data in specific column.
And also, use MIN() & MAX() for determining the minimum and maximum data in a specific column.
ASC is for ascending order.

Hope this will help you!
Thanks and regards!