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

Jul 19 '05 #1

Subscribe Reply

1110

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.

Jul 19 '05 #2

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!

Jul 19 '05 #3

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*****@hotmai l.com> wrote in message
news:ON******** ********@tk2msf tngp13.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!

Jul 19 '05 #4

Similar topics

9579

Want 1 to many relationship when child table has no primary key

by: Bob C. | last post by:

I want to create a 1-many relationship. Parent table has a primary key, child table has no primary key. The child table does have an index with all four fields of the parent's PK. How can I do this? Thanks, Bob C.

Microsoft SQL Server

3069

want to get bounced mail in different address

by: Atanu | last post by:

Im using System.Web.Mail to send emails to the users. Now i want to receive the bounced mails in a different email id from that of the from(sender) id. Im doing something like this... MailMessage mail=new MailMessage(); mail.Headers.Add("Return-Path","id@domain.com"); but the bounced mails are coming back to from id. Initially i thought smtp server is overwritng return-path informations with

.NET Framework

5240

help changing DIV content - want to put a javascript into the DIV

by: rpesq | last post by:

Hi, I Need help changing the content of a DIV. I sincerely researched the issue and have not found a solution except to scrap the idea and stick with the iframe code that I had been using. My purpose here is to avoid iframes. I know how to change the DIV content to other basic html statements, such as basic IMG's or Lists, but I want to put a Javascript into the DIV, and have not found a way to do it.

Javascript

2092

DSN-less connection - Trusted_Connection=no doesn't stick

by: Roald Oines | last post by:

I've implemented Doug Steele's code ( http://members.rogers.com/douglas.j.steele/DSNLessLinks.html ) to create a dsn-less connection to a SQL Server database from Access 2003 under XP Pro. I was given a userid and password for the database I'm connecting to, so I put them in the connection string and changed Trusted_Connection from yes to no. However, when I close the database and reopen, I get a logon failure, the SQL Server logon box,...

Microsoft Access / VBA

9819

.style.display = "None" won't stick

by: Sue | last post by:

Help! I have an asp table with an embedded table. The asp tablerow that contains this table has a static ID assigned of "FilterRow2" (see snippets of code below). When I click on the button to set the tablerow style property to "None", the row (And embedded table) briefly disappear, but then bounce right back into sight. Any ideas on why it's doing this and how to make the style.display = "None" stick?

ASP.NET

1505

I WANT to do a Partial File Upload

by: jhanzl | last post by:

All - I am looking into a way of uploading just the first portion of a large (> 100M) .csv (text) file to the server. Ultimately what I want to do is read the first line of the .csv file, which has the column headers for the file for field mapping to a server-side database WITHOUT actually having to upload the entire file to the server. The files are simply too large to have to wait for the upload to complete before proceeding to the...

ASP.NET

3319

I want a Python Puppy !

by: Claudio Grondi | last post by:

I have just discovered the existance of Puppy Linux which is a complete operating system with a suite of GUI apps, only about 50 - 60M booting directly off the CDROM ( http://www.puppylinux.org ). This approach appears to me very Pythonic, so it were a nice thing to have a full featured Puppy Linux Live CD prepared for Python programming. Have someone already breed a Python Puppy and is so kind to share a copy of it with me?

Python

3604

running python from a memory stick?

by: John Salerno | last post by:

Is there a way to 'install' and use Python on a memory stick, just as you would on any computer? I use Windows, and I know the installation does things with the registry, so probably I couldn't use the executable file to install it. But is it possible to do it some other way, such as how you might build it yourself on Linux (although I don't know how to do that yet) and then just write and run scripts normally straight from your memory...

Python

1963

Visual Studio 2005 on USB Stick

by: hufaunder | last post by:

I often find myself in the situation where at a customers site I have to do some quick debugging or program changes. Obvioiusly, I do not want to install VS2005 on their system. Is there a ways to install VS2005 on a big and fast USB stick, plug it into a computer without VS2005 and start using it there? If not are there any alternatives. Thanks

.NET Framework

8432

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8343

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8855

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8758

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8545

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8633

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5653

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

2762

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1986

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP