Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Send Auto email in server

8 posts in General Discussion Last posting was on 2004-03-29 21:36:22.0Z
Chandresh Patel Posted on 2004-03-29 03:44:44.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
Subject: Send Auto email in server
Lines: 11
Organization: Shreeji Smart Solution
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: acc86632.ipt.aol.com
Message-ID: <40679ba8@forums-2-dub>
X-Original-Trace: 28 Mar 2004 19:44:40 -0800, acc86632.ipt.aol.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Mar 2004 19:44:41 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Mar 2004 19:44:44 -0800
X-Trace: forums-1-dub 1080531884 10.22.108.75 (28 Mar 2004 19:44:44 -0800)
X-Original-Trace: 28 Mar 2004 19:44:44 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2862
Article PK: 6333

Hi,

I am using Sybase Anywhere 9.0.1.1108

Is there any way to send email from server OR can set some time base event
so it automatically search for record and if not found the it send email to
provided email address automatically.

Thanks in Advance.


Robert Waywell Posted on 2004-03-29 13:49:55.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <40679ba8@forums-2-dub>
Subject: Re: Send Auto email in server
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 10.25.100.239
X-Original-NNTP-Posting-Host: 10.25.100.239
Message-ID: <40682983$1@forums-1-dub>
Date: 29 Mar 2004 05:49:55 -0800
X-Trace: forums-1-dub 1080568195 10.25.100.239 (29 Mar 2004 05:49:55 -0800)
X-Original-Trace: 29 Mar 2004 05:49:55 -0800, 10.25.100.239
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2865
Article PK: 6336

ASA Database Administration Guide

Automating Tasks Using Schedules and Events

ASA SQL Reference
System Procedures and Functions
System extended stored procedures
Extended stored procedures for MAPI and SMTP

xp_sendmail system procedure


--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
ug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Chandresh Patel" <bapashree@yahoo.com> wrote in message
news:40679ba8@forums-2-dub...
> Hi,
>
> I am using Sybase Anywhere 9.0.1.1108
>
> Is there any way to send email from server OR can set some time base event
> so it automatically search for record and if not found the it send email
to
> provided email address automatically.
>
> Thanks in Advance.
>
>


Chandresh Patel Posted on 2004-03-29 16:05:31.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
References: <40679ba8@forums-2-dub> <40682983$1@forums-1-dub>
Subject: Re: Send Auto email in server
Lines: 70
Organization: Shreeji Smart Solution
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: ac89410c.ipt.aol.com
Message-ID: <40684947$1@forums-2-dub>
X-Original-Trace: 29 Mar 2004 08:05:27 -0800, ac89410c.ipt.aol.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Mar 2004 08:05:28 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Mar 2004 08:05:31 -0800
X-Trace: forums-1-dub 1080576331 10.22.108.75 (29 Mar 2004 08:05:31 -0800)
X-Original-Trace: 29 Mar 2004 08:05:31 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2877
Article PK: 6344

Thank you very much......I am happy

Do you know any good example of SMTP because I am not that much powerfull in
sybase. I would appreciate if you give me an example of this and how it
starts daily at 2:00pm automatically.


Thanks in Advance.

"Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
news:40682983$1@forums-1-dub...
> ASA Database Administration Guide
>
> Automating Tasks Using Schedules and Events
>
> ASA SQL Reference
> System Procedures and Functions
> System extended stored procedures
> Extended stored procedures for MAPI and SMTP
>
> xp_sendmail system procedure
>
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
> ug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> news:40679ba8@forums-2-dub...
> > Hi,
> >
> > I am using Sybase Anywhere 9.0.1.1108
> >
> > Is there any way to send email from server OR can set some time base
event
> > so it automatically search for record and if not found the it send email
> to
> > provided email address automatically.
> >
> > Thanks in Advance.
> >
> >
>
>


Chris Keating (iAnywhere Solutions) Posted on 2004-03-29 18:09:52.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <40679ba8@forums-2-dub> <40682983$1@forums-1-dub> <40684947$1@forums-2-dub>
Subject: Re: Send Auto email in server
Lines: 122
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: keating-xp.sybase.com
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <40686670$1@forums-1-dub>
Date: 29 Mar 2004 10:09:52 -0800
X-Trace: forums-1-dub 1080583792 10.25.100.248 (29 Mar 2004 10:09:52 -0800)
X-Original-Trace: 29 Mar 2004 10:09:52 -0800, keating-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2879
Article PK: 6349

The documentation contains examples for email and for scheduled events. You
should be able to take those examples to build an event that meets your
needs. The examples references are:

1) Email example:

ASA SQL Reference
System Procedures and Functions
System extended stored procedures
Extended stored procedures for MAPI and SMTP


2) Scheduled Events Examples:

ASA SQL Reference
SQL Statements
CREATE EVENT statement

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Chandresh Patel" <bapashree@yahoo.com> wrote in message
news:40684947$1@forums-2-dub...
> Thank you very much......I am happy
>
> Do you know any good example of SMTP because I am not that much powerfull
in
> sybase. I would appreciate if you give me an example of this and how it
> starts daily at 2:00pm automatically.
>
>
> Thanks in Advance.
>
>
>
>
> "Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
> news:40682983$1@forums-1-dub...
> > ASA Database Administration Guide
> >
> > Automating Tasks Using Schedules and Events
> >
> > ASA SQL Reference
> > System Procedures and Functions
> > System extended stored procedures
> > Extended stored procedures for MAPI and SMTP
> >
> > xp_sendmail system procedure
> >
> >
> > --
> > -----------------------------------------------
> > Robert Waywell
> > Sybase Adaptive Server Anywhere Developer - Version 8
> > Sybase Certified Professional
> >
> > Sybase's iAnywhere Solutions
> >
> > Please respond ONLY to newsgroup
> >
> > EBF's and Patches: http://downloads.sybase.com
> > choose SQL Anywhere Studio >> change 'time frame' to all
> >
> > To Submit Bug Reports:
> >
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
> > ug
> >
> > SQL Anywhere Studio Supported Platforms and Support Status
> > http://my.sybase.com/detail?id=1002288
> >
> > Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> > Developer Community at www.ianywhere.com/developer
> >
> > "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> > news:40679ba8@forums-2-dub...
> > > Hi,
> > >
> > > I am using Sybase Anywhere 9.0.1.1108
> > >
> > > Is there any way to send email from server OR can set some time base
> event
> > > so it automatically search for record and if not found the it send
email
> > to
> > > provided email address automatically.
> > >
> > > Thanks in Advance.
> > >
> > >
> >
> >
>
>


Chandresh Patel Posted on 2004-03-29 18:43:11.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
References: <40679ba8@forums-2-dub> <40682983$1@forums-1-dub> <40684947$1@forums-2-dub> <40686670$1@forums-1-dub>
Subject: Re: Send Auto email in server
Lines: 143
Organization: Shreeji Smart Solution
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: ac89410c.ipt.aol.com
Message-ID: <40686e36@forums-2-dub>
X-Original-Trace: 29 Mar 2004 10:43:02 -0800, ac89410c.ipt.aol.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Mar 2004 10:43:08 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Mar 2004 10:43:11 -0800
X-Trace: forums-1-dub 1080585791 10.22.108.75 (29 Mar 2004 10:43:11 -0800)
X-Original-Trace: 29 Mar 2004 10:43:11 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2882
Article PK: 6353

Chris,

You are right but I need good example for sending mail using SMTP. This
example show mapi. I want to connect through SMTP.


Thanks in Advance.




"Chris Keating (iAnywhere Solutions)" <FightSpam_keating@iAnywhere.com>

wrote in message news:40686670$1@forums-1-dub...
> The documentation contains examples for email and for scheduled events.
You
> should be able to take those examples to build an event that meets your
> needs. The examples references are:
>
> 1) Email example:
>
> ASA SQL Reference
> System Procedures and Functions
> System extended stored procedures
> Extended stored procedures for MAPI and SMTP
>
>
> 2) Scheduled Events Examples:
>
> ASA SQL Reference
> SQL Statements
> CREATE EVENT statement
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
>
****************************************************************************
> *
> Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
> and try out the market-leading database for mobile, embedded and small to
> medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
>
****************************************************************************
> *
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
>
****************************************************************************
> *
>
> "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> news:40684947$1@forums-2-dub...
> > Thank you very much......I am happy
> >
> > Do you know any good example of SMTP because I am not that much
powerfull
> in
> > sybase. I would appreciate if you give me an example of this and how it
> > starts daily at 2:00pm automatically.
> >
> >
> > Thanks in Advance.
> >
> >
> >
> >
> > "Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
> > news:40682983$1@forums-1-dub...
> > > ASA Database Administration Guide
> > >
> > > Automating Tasks Using Schedules and Events
> > >
> > > ASA SQL Reference
> > > System Procedures and Functions
> > > System extended stored procedures
> > > Extended stored procedures for MAPI and SMTP
> > >
> > > xp_sendmail system procedure
> > >
> > >
> > > --
> > > -----------------------------------------------
> > > Robert Waywell
> > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > Sybase Certified Professional
> > >
> > > Sybase's iAnywhere Solutions
> > >
> > > Please respond ONLY to newsgroup
> > >
> > > EBF's and Patches: http://downloads.sybase.com
> > > choose SQL Anywhere Studio >> change 'time frame' to all
> > >
> > > To Submit Bug Reports:
> > >
> >
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
> > > ug
> > >
> > > SQL Anywhere Studio Supported Platforms and Support Status
> > > http://my.sybase.com/detail?id=1002288
> > >
> > > Whitepapers, TechDocs, and bug fixes are all available through the
> > iAnywhere
> > > Developer Community at www.ianywhere.com/developer
> > >
> > > "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> > > news:40679ba8@forums-2-dub...
> > > > Hi,
> > > >
> > > > I am using Sybase Anywhere 9.0.1.1108
> > > >
> > > > Is there any way to send email from server OR can set some time base
> > event
> > > > so it automatically search for record and if not found the it send
> email
> > > to
> > > > provided email address automatically.
> > > >
> > > > Thanks in Advance.
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Chris Keating (iAnywhere Solutions) Posted on 2004-03-29 19:39:59.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <40679ba8@forums-2-dub> <40682983$1@forums-1-dub> <40684947$1@forums-2-dub> <40686670$1@forums-1-dub> <40686e36@forums-2-dub>
Subject: Re: Send Auto email in server
Lines: 181
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <40687b86$1@forums-2-dub>
X-Original-Trace: 29 Mar 2004 11:39:50 -0800, keating-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Mar 2004 11:39:51 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Mar 2004 11:39:59 -0800
X-Trace: forums-1-dub 1080589199 10.22.108.75 (29 Mar 2004 11:39:59 -0800)
X-Original-Trace: 29 Mar 2004 11:39:59 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2883
Article PK: 6351

Use xp_startsmtp and xp_stopsmtp instead of xp_startmail and
xp_stopmail...-- Chris KeatingSybase Adaptive Server Anywhere Professional
Version 8
****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Chandresh Patel" <bapashree@yahoo.com> wrote in message
news:40686e36@forums-2-dub...
> Chris,
>
> You are right but I need good example for sending mail using SMTP. This
> example show mapi. I want to connect through SMTP.
>
>
> Thanks in Advance.
>
>
>
>
> "Chris Keating (iAnywhere Solutions)" <FightSpam_keating@iAnywhere.com>
> wrote in message news:40686670$1@forums-1-dub...
> > The documentation contains examples for email and for scheduled events.
> You
> > should be able to take those examples to build an event that meets your
> > needs. The examples references are:
> >
> > 1) Email example:
> >
> > ASA SQL Reference
> > System Procedures and Functions
> > System extended stored procedures
> > Extended stored procedures for MAPI and SMTP
> >
> >
> > 2) Scheduled Events Examples:
> >
> > ASA SQL Reference
> > SQL Statements
> > CREATE EVENT statement
> >
> > --
> >
> > Chris Keating
> > Sybase Adaptive Server Anywhere Professional Version 8
> >
> >
>

****************************************************************************

> > *
> > Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition
> > and try out the market-leading database for mobile, embedded and small
to
> > medium sized business environments for free!
> >
> > http://www.ianywhere.com/promos/deved/index.html
> >
> >
>
****************************************************************************
> > *
> >
> > iAnywhere Solutions http://www.iAnywhere.com
> >
> > ** Please only post to the newsgroup
> >
> > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> >
> >
>
****************************************************************************
> > *
> >
> > "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> > news:40684947$1@forums-2-dub...
> > > Thank you very much......I am happy
> > >
> > > Do you know any good example of SMTP because I am not that much
> powerfull
> > in
> > > sybase. I would appreciate if you give me an example of this and how
it
> > > starts daily at 2:00pm automatically.
> > >
> > >
> > > Thanks in Advance.
> > >
> > >
> > >
> > >
> > > "Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
> > > news:40682983$1@forums-1-dub...
> > > > ASA Database Administration Guide
> > > >
> > > > Automating Tasks Using Schedules and Events
> > > >
> > > > ASA SQL Reference
> > > > System Procedures and Functions
> > > > System extended stored procedures
> > > > Extended stored procedures for MAPI and SMTP
> > > >
> > > > xp_sendmail system procedure
> > > >
> > > >
> > > > --
> > > > -----------------------------------------------
> > > > Robert Waywell
> > > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > > Sybase Certified Professional
> > > >
> > > > Sybase's iAnywhere Solutions
> > > >
> > > > Please respond ONLY to newsgroup
> > > >
> > > > EBF's and Patches: http://downloads.sybase.com
> > > > choose SQL Anywhere Studio >> change 'time frame' to all
> > > >
> > > > To Submit Bug Reports:
> > > >
> > >
> >
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
> > > > ug
> > > >
> > > > SQL Anywhere Studio Supported Platforms and Support Status
> > > > http://my.sybase.com/detail?id=1002288
> > > >
> > > > Whitepapers, TechDocs, and bug fixes are all available through the
> > > iAnywhere
> > > > Developer Community at www.ianywhere.com/developer
> > > >
> > > > "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> > > > news:40679ba8@forums-2-dub...
> > > > > Hi,
> > > > >
> > > > > I am using Sybase Anywhere 9.0.1.1108
> > > > >
> > > > > Is there any way to send email from server OR can set some time
base
> > > event
> > > > > so it automatically search for record and if not found the it send
> > email
> > > > to
> > > > > provided email address automatically.
> > > > >
> > > > > Thanks in Advance.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Chandresh Patel Posted on 2004-03-29 21:26:09.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
References: <40679ba8@forums-2-dub> <40682983$1@forums-1-dub> <40684947$1@forums-2-dub> <40686670$1@forums-1-dub> <40686e36@forums-2-dub> <40687b86$1@forums-2-dub>
Subject: Re: Send Auto email in server
Lines: 207
Organization: Shreeji Smart Solution
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: ac89410c.ipt.aol.com
X-Original-NNTP-Posting-Host: ac89410c.ipt.aol.com
Message-ID: <40689471@forums-1-dub>
Date: 29 Mar 2004 13:26:09 -0800
X-Trace: forums-1-dub 1080595569 172.137.65.12 (29 Mar 2004 13:26:09 -0800)
X-Original-Trace: 29 Mar 2004 13:26:09 -0800, ac89410c.ipt.aol.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2884
Article PK: 6354

got it....

it works......


How can I send HTML data in this function.


Thanks in Advance.



"Chris Keating (iAnywhere Solutions)" <FightSpam_keating@iAnywhere.com>

wrote in message news:40687b86$1@forums-2-dub...
> Use xp_startsmtp and xp_stopsmtp instead of xp_startmail and
> xp_stopmail...-- Chris KeatingSybase Adaptive Server Anywhere Professional
> Version 8
>
****************************************************************************
> *
> Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
> and try out the market-leading database for mobile, embedded and small to
> medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
>
****************************************************************************
> *
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
>
****************************************************************************
> *
>
> "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> news:40686e36@forums-2-dub...
> > Chris,
> >
> > You are right but I need good example for sending mail using SMTP. This
> > example show mapi. I want to connect through SMTP.
> >
> >
> > Thanks in Advance.
> >
> >
> >
> >
> > "Chris Keating (iAnywhere Solutions)" <FightSpam_keating@iAnywhere.com>
> > wrote in message news:40686670$1@forums-1-dub...
> > > The documentation contains examples for email and for scheduled
events.
> > You
> > > should be able to take those examples to build an event that meets
your
> > > needs. The examples references are:
> > >
> > > 1) Email example:
> > >
> > > ASA SQL Reference
> > > System Procedures and Functions
> > > System extended stored procedures
> > > Extended stored procedures for MAPI and SMTP
> > >
> > >
> > > 2) Scheduled Events Examples:
> > >
> > > ASA SQL Reference
> > > SQL Statements
> > > CREATE EVENT statement
> > >
> > > --
> > >
> > > Chris Keating
> > > Sybase Adaptive Server Anywhere Professional Version 8
> > >
> > >
> >
>
****************************************************************************
>
> > > *
> > > Sign up today for your copy of the SQL Anywhere Studio 9 Developer
> Edition
> > > and try out the market-leading database for mobile, embedded and small
> to
> > > medium sized business environments for free!
> > >
> > > http://www.ianywhere.com/promos/deved/index.html
> > >
> > >
> >
>
****************************************************************************
> > > *
> > >
> > > iAnywhere Solutions http://www.iAnywhere.com
> > >
> > > ** Please only post to the newsgroup
> > >
> > > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> > >
> > >
> >
>
****************************************************************************
> > > *
> > >
> > > "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> > > news:40684947$1@forums-2-dub...
> > > > Thank you very much......I am happy
> > > >
> > > > Do you know any good example of SMTP because I am not that much
> > powerfull
> > > in
> > > > sybase. I would appreciate if you give me an example of this and how
> it
> > > > starts daily at 2:00pm automatically.
> > > >
> > > >
> > > > Thanks in Advance.
> > > >
> > > >
> > > >
> > > >
> > > > "Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
> > > > news:40682983$1@forums-1-dub...
> > > > > ASA Database Administration Guide
> > > > >
> > > > > Automating Tasks Using Schedules and Events
> > > > >
> > > > > ASA SQL Reference
> > > > > System Procedures and Functions
> > > > > System extended stored procedures
> > > > > Extended stored procedures for MAPI and SMTP
> > > > >
> > > > > xp_sendmail system procedure
> > > > >
> > > > >
> > > > > --
> > > > > -----------------------------------------------
> > > > > Robert Waywell
> > > > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > > > Sybase Certified Professional
> > > > >
> > > > > Sybase's iAnywhere Solutions
> > > > >
> > > > > Please respond ONLY to newsgroup
> > > > >
> > > > > EBF's and Patches: http://downloads.sybase.com
> > > > > choose SQL Anywhere Studio >> change 'time frame' to all
> > > > >
> > > > > To Submit Bug Reports:
> > > > >
> > > >
> > >
> >
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
> > > > > ug
> > > > >
> > > > > SQL Anywhere Studio Supported Platforms and Support Status
> > > > > http://my.sybase.com/detail?id=1002288
> > > > >
> > > > > Whitepapers, TechDocs, and bug fixes are all available through the
> > > > iAnywhere
> > > > > Developer Community at www.ianywhere.com/developer
> > > > >
> > > > > "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> > > > > news:40679ba8@forums-2-dub...
> > > > > > Hi,
> > > > > >
> > > > > > I am using Sybase Anywhere 9.0.1.1108
> > > > > >
> > > > > > Is there any way to send email from server OR can set some time
> base
> > > > event
> > > > > > so it automatically search for record and if not found the it
send
> > > email
> > > > > to
> > > > > > provided email address automatically.
> > > > > >
> > > > > > Thanks in Advance.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Chris Keating (iAnywhere Solutions) Posted on 2004-03-29 21:36:22.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <40679ba8@forums-2-dub> <40682983$1@forums-1-dub> <40684947$1@forums-2-dub> <40686670$1@forums-1-dub> <40686e36@forums-2-dub> <40687b86$1@forums-2-dub> <40689471@forums-1-dub>
Subject: Re: Send Auto email in server
Lines: 257
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <406896d1$1@forums-2-dub>
X-Original-Trace: 29 Mar 2004 13:36:17 -0800, keating-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Mar 2004 13:36:19 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Mar 2004 13:36:22 -0800
X-Trace: forums-1-dub 1080596182 10.22.108.75 (29 Mar 2004 13:36:22 -0800)
X-Original-Trace: 29 Mar 2004 13:36:22 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2885
Article PK: 6356

Best to ask this as a new thread


--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Chandresh Patel" <bapashree@yahoo.com> wrote in message
news:40689471@forums-1-dub...
> got it....
>
> it works......
>
>
> How can I send HTML data in this function.
>
>
> Thanks in Advance.
>
>
>
> "Chris Keating (iAnywhere Solutions)" <FightSpam_keating@iAnywhere.com>
> wrote in message news:40687b86$1@forums-2-dub...
> > Use xp_startsmtp and xp_stopsmtp instead of xp_startmail and
> > xp_stopmail...-- Chris KeatingSybase Adaptive Server Anywhere
Professional
> > Version 8
> >
>
****************************************************************************
> > *
> > Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition
> > and try out the market-leading database for mobile, embedded and small
to
> > medium sized business environments for free!
> >
> > http://www.ianywhere.com/promos/deved/index.html
> >
> >
>
****************************************************************************
> > *
> >
> > iAnywhere Solutions http://www.iAnywhere.com
> >
> > ** Please only post to the newsgroup
> >
> > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> >
> >
>
****************************************************************************
> > *
> >
> > "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> > news:40686e36@forums-2-dub...
> > > Chris,
> > >
> > > You are right but I need good example for sending mail using SMTP.
This
> > > example show mapi. I want to connect through SMTP.
> > >
> > >
> > > Thanks in Advance.
> > >
> > >
> > >
> > >
> > > "Chris Keating (iAnywhere Solutions)"
<FightSpam_keating@iAnywhere.com>
> > > wrote in message news:40686670$1@forums-1-dub...
> > > > The documentation contains examples for email and for scheduled
> events.
> > > You
> > > > should be able to take those examples to build an event that meets
> your
> > > > needs. The examples references are:
> > > >
> > > > 1) Email example:
> > > >
> > > > ASA SQL Reference
> > > > System Procedures and Functions
> > > > System extended stored procedures
> > > > Extended stored procedures for MAPI and SMTP
> > > >
> > > >
> > > > 2) Scheduled Events Examples:
> > > >
> > > > ASA SQL Reference
> > > > SQL Statements
> > > > CREATE EVENT statement
> > > >
> > > > --
> > > >
> > > > Chris Keating
> > > > Sybase Adaptive Server Anywhere Professional Version 8
> > > >
> > > >
> > >
> >
>
****************************************************************************
> >
> > > > *
> > > > Sign up today for your copy of the SQL Anywhere Studio 9 Developer
> > Edition
> > > > and try out the market-leading database for mobile, embedded and
small
> > to
> > > > medium sized business environments for free!
> > > >
> > > > http://www.ianywhere.com/promos/deved/index.html
> > > >
> > > >
> > >
> >
>
****************************************************************************
> > > > *
> > > >
> > > > iAnywhere Solutions http://www.iAnywhere.com
> > > >
> > > > ** Please only post to the newsgroup
> > > >
> > > > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > > > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > > > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> > > >
> > > >
> > >
> >
>
****************************************************************************
> > > > *
> > > >
> > > > "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> > > > news:40684947$1@forums-2-dub...
> > > > > Thank you very much......I am happy
> > > > >
> > > > > Do you know any good example of SMTP because I am not that much
> > > powerfull
> > > > in
> > > > > sybase. I would appreciate if you give me an example of this and
how
> > it
> > > > > starts daily at 2:00pm automatically.
> > > > >
> > > > >
> > > > > Thanks in Advance.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
> > > > > news:40682983$1@forums-1-dub...
> > > > > > ASA Database Administration Guide
> > > > > >
> > > > > > Automating Tasks Using Schedules and Events
> > > > > >
> > > > > > ASA SQL Reference
> > > > > > System Procedures and Functions
> > > > > > System extended stored procedures
> > > > > > Extended stored procedures for MAPI and SMTP
> > > > > >
> > > > > > xp_sendmail system procedure
> > > > > >
> > > > > >
> > > > > > --
> > > > > > -----------------------------------------------
> > > > > > Robert Waywell
> > > > > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > > > > Sybase Certified Professional
> > > > > >
> > > > > > Sybase's iAnywhere Solutions
> > > > > >
> > > > > > Please respond ONLY to newsgroup
> > > > > >
> > > > > > EBF's and Patches: http://downloads.sybase.com
> > > > > > choose SQL Anywhere Studio >> change 'time frame' to all
> > > > > >
> > > > > > To Submit Bug Reports:
> > > > > >
> > > > >
> > > >
> > >
> >
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
> > > > > > ug
> > > > > >
> > > > > > SQL Anywhere Studio Supported Platforms and Support Status
> > > > > > http://my.sybase.com/detail?id=1002288
> > > > > >
> > > > > > Whitepapers, TechDocs, and bug fixes are all available through
the
> > > > > iAnywhere
> > > > > > Developer Community at www.ianywhere.com/developer
> > > > > >
> > > > > > "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> > > > > > news:40679ba8@forums-2-dub...
> > > > > > > Hi,
> > > > > > >
> > > > > > > I am using Sybase Anywhere 9.0.1.1108
> > > > > > >
> > > > > > > Is there any way to send email from server OR can set some
time
> > base
> > > > > event
> > > > > > > so it automatically search for record and if not found the it
> send
> > > > email
> > > > > > to
> > > > > > > provided email address automatically.
> > > > > > >
> > > > > > > Thanks in Advance.
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>