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

Richard Pain wrote:[color=blue]
> 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[/color]

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.

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!

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" <rjbpain@hotmail.com> wrote in message
news:ONK8%238yGEHA.2768@tk2msftngp13.phx.gbl...[color=blue]
>
> 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![/color]