Lookup table and send email

-1

BEGIN 
DECLARE content LONG VARCHAR;
set content='select * from shipper';
CALL xp_startsmtp( smtp_sender = 'mfkpie8@163.com', smtp_server='smtp.163.com', smtp_port='25',
timeout=240, smtp_auth_username='mfkpie8', smtp_auth_password='password');
CALL xp_sendmail( recipient='131t@qq.com',
      subject='ssssssss',"message"=content,query='select * from shipper');
call xp_stopmail();
end

question: But did not receive my email, just received ‘select * from shipper',Don't have any data

smtp email

asked 21 Nov '13, 04:42

mfkpie8
288●66●71●76
accept rate: 12%

edited 21 Nov '13, 04:42

flat view

2 Answers:

active answers oldest answers newest answers popular answers

This is expected behaviour - confine the docs on the query parameter:

query
This LONG VARCHAR is provided for Transact-SQL compatibility. It is not used by SQL Anywhere. The default is NULL.

So I guess you will have to either

output your query result to a file (via the UNLOAD statement) and attach that file to your mail or
output your query result to a variable and add that variable's contents to the "message" parameter.

The cited doc page shows some samples on the usage.

permanent link

answered 21 Nov '13, 05:06

Volker Barth
40.5k●365●556●827
accept rate: 34%

edited 21 Nov '13, 05:07

Can you help me to modify under my SQL

(21 Nov '13, 05:24) mfkpie8

flat view

0	Try This: CALL xp_sendmail( recipient='Sales Group', subject='New Pricing', include_file = 'C:\DOCS\PRICES.DOC' ); permanent link answered 21 Nov '13, 05:17 Adiel 1●3●3●5 accept rate: 0% flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

email ×13
smtp ×10

question asked: 21 Nov '13, 04:42

question was seen: 2,431 times

last updated: 21 Nov '13, 05:24

SAP SQL Anywhere

Lookup table and send email

Follow this question

Related questions