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]]

Richard Pain wrote:

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
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[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
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[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.

--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com
"Richard Pain" <rj*****@hotmail.com> wrote in message
news:ON****************@tk2msftngp13.phx.gbl...

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
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!