But they now want to stick with SQL server.

[Richard Pain]

Having thought they'd go over to mysql, they've decided to stick with
sql server. The hosting company don't allow direct connection to the
database with enterprise manager so I don't think I can get any UDFs
on there - I don't even know anything about UDFs!

They use ASPMail.

Thanks for replying,

Richard

 

[Bob Barrows [MVP]]

Having thought they'd go over to mysql, they've decided to stick with
sql server. The hosting company don't allow direct connection to the
database with enterprise manager so I don't think I can get any UDFs
on there - I don't even know anything about UDFs!

They use ASPMail.

Thanks for replying,

Richard

What are you talking about? I no longer have your original message. Please
quote a little from your original message so we will know what you are
asking for.

Bob Barrows

 

[Richard Pain]

Sorry about that - see below...


From: Richard Pain
Date Posted: 4/1/2004 3:21:00 AM



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

 

[Mark Schupp]

You would have to supply your database layout for anyone to help you with
your first question. However, if you already have a page with the desired
data then find the part that outputs the information you want and copy it
into a new page. Change it from writing out a response to appending text to
a string variable. Then you can add it to the body of the email.