Chris Moore
|
Posted: 07/14/2003, 2:23 PM |
|
I have a search where the user enters some criteria (from select boxes) and
the SQL executes. Only the 1st 200 records are displayed. If the user
selctes the Order button, I need to run the query, export the data to a CSV
file (named whatever I choose) and then email it (the exported file) to the
user at the email address they just entered on the order form. Is there an
example of this somewhere?
Thanks.
Chris
|
|
|
Robert Rodgers
|
Posted: 07/15/2003, 9:47 AM |
|
Hi Chis,
If you are using ASP
http://www.sylvancomputing.com/ccs/csvexport/Default.asp
It will help you export. Then look for info on CDONTS. There has been
quite a bit of discussion on the gotocode.com site about it latlely. I have
some code for emailing with CDONTS when a new record is added to a support
table but I have not integrated the csv export with email. I will see if
I can integrate a email method in the class. It shouldn't be too difficult.
But I am very busy with 2 projects so it won't be until late in the day.
rob
--
"Every absurdity has a champion to defend it"
Oliver Goldsmith
++++++++++++++++++++++++++++++
"Chris Moore" <chris@dblayout.com> wrote in message
news:Xns93B8A75BE5BF3cabubba@66.180.229.147...
I have a search where the user enters some criteria (from select boxes) and
the SQL executes. Only the 1st 200 records are displayed. If the user
selctes the Order button, I need to run the query, export the data to a CSV
file (named whatever I choose) and then email it (the exported file) to the
user at the email address they just entered on the order form. Is there an
example of this somewhere?
Thanks.
Chris
|
|
|
Chris Moore
|
Posted: 07/15/2003, 12:36 PM |
|
Awesome, thanks for all the help.
Chris
"Robert Rodgers" <rrodgers@sylvancomputing.com> wrote in
news:bf1b70$kjl$1@news.codecharge.com:
> Hi Chis,
>
> If you are using ASP
>
> http://www.sylvancomputing.com/ccs/csvexport/Default.asp
>
> It will help you export. Then look for info on CDONTS. There has
> been quite a bit of discussion on the gotocode.com site about it
> latlely. I have some code for emailing with CDONTS when a new record
> is added to a support table but I have not integrated the csv export
> with email. I will see if I can integrate a email method in the
> class. It shouldn't be too difficult. But I am very busy with 2
> projects so it won't be until late in the day.
>
>
> rob
>
|
|
|
|
|