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.

sending email with attachment???

3 posts in General Discussion (old) Last posting was on 2007-06-09 11:30:23.0Z
Stephen Posted on 2007-06-08 16:33:29.0Z
From: "Stephen" <smarcoux@cbgi.qc.ca>
Newsgroups: sybase.public.sqlanywhere
Subject: sending email with attachment???
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: mtrlpq02-1168107546.sdsl.bell.ca
X-Original-NNTP-Posting-Host: mtrlpq02-1168107546.sdsl.bell.ca
Message-ID: <466984d9@forums-1-dub>
Date: 8 Jun 2007 09:33:29 -0700
X-Trace: forums-1-dub 1181320409 69.159.232.26 (8 Jun 2007 09:33:29 -0700)
X-Original-Trace: 8 Jun 2007 09:33:29 -0700, mtrlpq02-1168107546.sdsl.bell.ca
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:38
Article PK: 841527

i'm currently using SQL Anywhere 8

I want to send an email using smtp.

Attachments are forbidden. - this is my problem

if I upgrade to SQL 10, will I be able to send an email with attachment
using smtp?


Breck Carter [Team iAnywhere] Posted on 2007-06-09 11:28:46.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: sybase.public.sqlanywhere
Subject: Re: sending email with attachment???
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <5k3l63db5ivg5lj21abcetbskp7j923aa0@4ax.com>
References: <466984d9@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 208.253.124.99
X-Original-NNTP-Posting-Host: 208.253.124.99
Date: 9 Jun 2007 04:28:46 -0700
X-Trace: forums-1-dub 1181388526 208.253.124.99 (9 Jun 2007 04:28:46 -0700)
X-Original-Trace: 9 Jun 2007 04:28:46 -0700, 208.253.124.99
Lines: 49
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:39
Article PK: 866494

Apparently Version 10 xp_sendmail has a *sackload* of improvements
(none of which are mentioned in the "what's new" section of the Help)

xp_sendmail(
recipient = mail-address
[, subject = subject ]
[, cc_recipient = mail-address ]
[, bcc_recipient = mail-address ]
[, query = sql-query ]
[, "message" = message-body ]
[, attachname = attach-name ]
[, attach_result = attach-result ]
[, echo_error = echo-error ]
[, include_file = file-name ]
[, no_column_header = no-column-header ]
[, no_output = no-output ]
[, width = width ]
[, separator = separator-char ]
[, dbuser = user-name ]
[, dbname = db-name ]
[, type = type ]
[, include_query = include-query ]
[, content_type = content-type ]
)
...
include_file This LONG VARCHAR parameter specifies an attachment
file. The default is NULL.

On 8 Jun 2007 09:33:29 -0700, "Stephen" <smarcoux@cbgi.qc.ca> wrote:

>i'm currently using SQL Anywhere 8
>
>I want to send an email using smtp.
>
>Attachments are forbidden. - this is my problem
>
>if I upgrade to SQL 10, will I be able to send an email with attachment
>using smtp?
>
>

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Breck Carter [Team iAnywhere] Posted on 2007-06-09 11:30:23.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: sybase.public.sqlanywhere
Subject: Re: sending email with attachment???
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <jp3l631eo46pckjmcb085qskkrb5fc9itb@4ax.com>
References: <466984d9@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 208.253.124.99
X-Original-NNTP-Posting-Host: 208.253.124.99
Date: 9 Jun 2007 04:30:23 -0700
X-Trace: forums-1-dub 1181388623 208.253.124.99 (9 Jun 2007 04:30:23 -0700)
X-Original-Trace: 9 Jun 2007 04:30:23 -0700, 208.253.124.99
Lines: 30
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:40
Article PK: 866495

I take that back, it *is* mentioned in the "what's new" for Version
10...

Enhancement to xp_sendmail system procedure The xp_sendmail system
procedure now supports attachments when sending mail using SMTP, using
the new include_file parameter. In addition, xp_sendmail supports MIME
content when using SMTP mail, using the new content_type parameter.
See xp_sendmail system procedure.

On 8 Jun 2007 09:33:29 -0700, "Stephen" <smarcoux@cbgi.qc.ca> wrote:

>i'm currently using SQL Anywhere 8
>
>I want to send an email using smtp.
>
>Attachments are forbidden. - this is my problem
>
>if I upgrade to SQL 10, will I be able to send an email with attachment
>using smtp?
>
>

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com