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

Re: But they now want to stick with SQL server.

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.

[Richard Pain]

Re: But they now want to stick with SQL server.


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]

Re: But they now want to stick with SQL server.

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

https://www.ielearning.com

"Richard Pain" <rjbpain@hotmai l.com> wrote in message
news:ONK8%238yG EHA.2768@tk2msf tngp13.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]