Current location: Hot Scripts Forums » Programming Languages » ASP » html page or database table to send by email


html page or database table to send by email

Reply
  #1 (permalink)  
Old 04-01-04, 03:20 AM
rpain rpain is offline
New Member
 
Join Date: Apr 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
html page or database table to send by email

OK - I have a shopping basket with data in a database. Once the person has successfully completed their order I want to be able to send them an email with the products ordered roughly in the following format:

Product Price Quantity

prod1 £6.99 1
prod2 £5.99 2

Postage £0.50

Total whatever..I'm lazy

Formatting would be a little different (just spacing out the prod table a little more.

Any ideas or links to scripts that do this?. I've been looking for a while now but have had no luck in finding a solution. I just want to send a text email (and not html).

The other thing is that on the last page but one, this shopping basket is displayed. Is there anyway I could capture the html data from that page, store it in a session variable and then generate the email after the order has been completed (so sort of like sending a mirror of that page)? In that case having a HTML formatted email would be ok.


Many thanks,

Richard Pain
Reply With Quote
  #2 (permalink)  
Old 04-02-04, 09:08 PM
af11kcc's Avatar
af11kcc af11kcc is offline
Newbie Coder
 
Join Date: Sep 2003
Location: MX
Posts: 82
Thanks: 0
Thanked 0 Times in 0 Posts
Depending upon your operating system yo can either use:
CDONTS
http://www.sitepoint.com/article/sending-email-asp
CDOSYS
http://www.sitepoint.com/article/asp...er-winxp-pro/2
Or any comercial components installed on your server:
ASPEmail
http://www.aspemail.com
JMail
http://www.dimac.net
etc....
HTH
Reply With Quote
  #3 (permalink)  
Old 04-03-04, 03:27 AM
rpain rpain is offline
New Member
 
Join Date: Apr 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Yep - I know how to use a mail component (I think it's the 'mail' component for linux I'm using). I just need some advice on how to transform either the contents of the html page or a recordset from a database to a string that can be emailed.

Thanks for the reply,

Richard
Reply With Quote
  #4 (permalink)  
Old 04-03-04, 09:45 AM
af11kcc's Avatar
af11kcc af11kcc is offline
Newbie Coder
 
Join Date: Sep 2003
Location: MX
Posts: 82
Thanks: 0
Thanked 0 Times in 0 Posts
Are you running ASP pages over Linux, ChiliSoft?

Last edited by af11kcc; 04-03-04 at 09:52 AM.
Reply With Quote
  #5 (permalink)  
Old 04-04-04, 06:31 AM
rpain rpain is offline
New Member
 
Join Date: Apr 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
database to email

Yep........
Reply With Quote
  #6 (permalink)  
Old 04-05-04, 09:04 AM
rpain rpain is offline
New Member
 
Join Date: Apr 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy client trouble...

They've now decided they'd like to stick with sql server after all which eliminates the database problems (some of the complex queries didn't transfer properly over to mysql). I can't connect to sql server with enterprise manager (the hosting company don't allow it) so I'm a bit limited with the database controls - I can't create any UDFs presumably...

Doh!

I'll try to get something together and post it when I do...but still if anyone does know a quick solution!


Richard
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP Form to update a MySQL database? Scoobler PHP 9 09-04-08 01:41 AM
Classified Ads skipper23 Perl 3 11-22-05 02:22 AM
retrieve data from database and send to email jilshi JavaScript 0 03-10-04 01:19 AM
Classified Ads skipper23 Perl 2 12-30-03 03:43 AM
Form to database to email BogoMips ASP 0 11-03-03 06:12 AM


All times are GMT -5. The time now is 04:17 PM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.