<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head profile="http://internetalchemy.org/2003/02/profile"> <link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" /> <link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" /> <meta name="dc.title" content="Function: mime_part - Virtuoso Functions Guide" /> <meta name="dc.subject" content="Function: mime_part - Virtuoso Functions Guide" /> <meta name="dc.creator" content="OpenLink Software Documentation Team ; " /> <meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" /> <link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" /> <link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" /> <link rel="parent" href="functions.html" title="Chapter Contents" /> <link rel="prev" href="appendixa.html" title="Appendix" /> <link rel="next" href="functions.html#.html" title="" /> <link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" /> <link rel="stylesheet" type="text/css" href="doc.css" /> <link rel="stylesheet" type="text/css" href="/doc/translation.css" /> <title>Function: mime_part - Virtuoso Functions Guide</title> <meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" /> <meta name="author" content="OpenLink Software Documentation Team ; " /> <meta name="copyright" content="OpenLink Software, 1999 - 2009" /> <meta name="keywords" content="" /> <meta name="GENERATOR" content="OpenLink XSLT Team" /> </head> <body> <div id="header"> <a name="fn_mime_part" /> <img src="../images/misc/logo.jpg" alt="" /> <h1>22. Virtuoso Functions Guide - mime_part</h1> </div> <div id="navbartop"> <div> <a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="fn_mime_body.html" title="mime_body">Prev</a> | <a class="link" href="fn_mime_tree.html" title="mime_tree">Next</a> </div> </div> <div id="currenttoc"> <form method="post" action="/doc/adv_search.vspx"> <div class="search">Keyword Search: <br /> <input type="text" name="q" /> <input type="submit" name="go" value="Go" /> </div> </form> <div> <a href="http://www.openlinksw.com/">www.openlinksw.com</a> </div> <div> <a href="http://docs.openlinksw.com/">docs.openlinksw.com</a> </div> <br /> <div> <a href="index.html">Book Home</a> </div> <br /> <div> <a href="contents.html">Contents</a> </div> <div> <a href="preface.html">Preface</a> </div> <br /> <div> <a class="selected" href="functions.html">Virtuoso Functions Guide</a> </div> <br /> <div> <a href="functions.html#admin">Administration</a> </div> <div> <a href="functions.html#aggr">Aggregate Functions</a> </div> <div> <a href="functions.html#array">Array Manipulation</a> </div> <div> <a href="functions.html#bpel">BPEL APIs</a> </div> <div> <a href="functions.html#backup">Backup</a> </div> <div> <a href="functions.html#compression">Compression</a> </div> <div> <a href="functions.html#cursors">Cursor</a> </div> <div> <a href="functions.html#time">Date & Time Manipulation</a> </div> <div> <a href="functions.html#debug">Debug</a> </div> <div> <a href="functions.html#dict">Dictionary Manipulation</a> </div> <div> <a href="functions.html#encoding">Encoding & Decoding</a> </div> <div> <a href="functions.html#file">File Manipulation</a> </div> <div> <a href="functions.html#ft">Free Text</a> </div> <div> <a href="functions.html#hash">Hashing / Cryptographic</a> </div> <div> <a href="functions.html#ldap">LDAP</a> </div> <div> <a href="functions.html#localization">Locale</a> </div> <div> <a class="selected" href="functions.html#mail">Mail</a> </div> <div class="selected"> <div> <a href="fn_mime_body.html">mime_body</a> </div> <div> <a class="selected" href="fn_mime_part.html">mime_part</a> </div> <div> <a href="fn_mime_tree.html">mime_tree</a> </div> <div> <a href="fn_nntp_auth_get.html">nntp_auth_get</a> </div> <div> <a href="fn_nntp_auth_post.html">nntp_auth_post</a> </div> <div> <a href="fn_nntp_get.html">nntp_get</a> </div> <div> <a href="fn_nntp_post.html">nntp_post</a> </div> <div> <a href="fn_pem_certificates_to_array.html">pem_certificates_to_...</a> </div> <div> <a href="fn_pop3_get.html">pop3_get</a> </div> <div> <a href="fn_smime_decrypt.html">smime_decrypt</a> </div> <div> <a href="fn_smime_encrypt.html">smime_encrypt</a> </div> <div> <a href="fn_smime_sign.html">smime_sign</a> </div> <div> <a href="fn_smime_verify.html">smime_verify</a> </div> <div> <a href="fn_smtp_send.html">smtp_send</a> </div> <div> <a href="fn_uuvalidate.html">uuvalidate</a> </div> </div> <div> <a href="functions.html#misc">Miscellaneous</a> </div> <div> <a href="functions.html#number">Number</a> </div> <div> <a href="functions.html#phrz">Phrases</a> </div> <div> <a href="functions.html#rdf">RDF data</a> </div> <div> <a href="functions.html#rmt">Remote SQL Data Source</a> </div> <div> <a href="functions.html#repl">Replication</a> </div> <div> <a href="functions.html#soap">SOAP</a> </div> <div> <a href="functions.html#sql">SQL</a> </div> <div> <a href="functions.html#string">String</a> </div> <div> <a href="functions.html#txn">Transaction</a> </div> <div> <a href="functions.html#type">Type Mapping</a> </div> <div> <a href="functions.html#uddi">UDDI</a> </div> <div> <a href="functions.html#udt">User Defined Types & The CLR</a> </div> <div> <a href="functions.html#vad">VAD</a> </div> <div> <a href="functions.html#jvmpl">Virtuoso Java PL API</a> </div> <div> <a href="functions.html#bif">Virtuoso Server Extension Interface (VSEI)</a> </div> <div> <a href="functions.html#ws">Web & Internet</a> </div> <div> <a href="functions.html#xml">XML</a> </div> <div> <a href="functions.html#XPATH">XPATH & XQUERY</a> </div> <br /> <div> <a href="functionidx.html">Functions Index</a> </div> <br /> </div> <div id="text"> <h2>mime_part</h2> <div class="refpurpose">used to compose a MIME message body part.</div> <div class="funcsynopsis"> <span class="funcdef">any <span class="function">mime_part</span> </span> (<span class="paramdef">in <span class="parameter">content_type</span> varchar</span>, <span class="paramdef">in <span class="parameter">content_disposition</span> varchar</span>, <span class="paramdef">in <span class="parameter">transfer_encoding</span> varchar</span>, <span class="paramdef">in <span class="parameter">data</span> varchar</span>); </div> <div class="refsect1"> <div class="refsect1title">Description</div> <p>This function is used to make a MIME part that can be used with the <span class="computeroutput">mime_body()</span> function.</p> </div> <div class="refsect1"> <div class="refsect1title">Parameters</div> <div class="refsect2"> <span class="refsect2title">content_type – </span> This parameter is used to specify the media type and subtype of data in the body of a message and to fully specify the native representation of such data. This header embodies much of the power of MIME. The IETF can add new official content types. Additionally, private content-type values can be defined by anyone. Such private content types have values of "x-something" or "X-something", where "something" can take on any value.</div> <div class="refsect2"> <span class="refsect2title">content_disposition – </span> This parameter provides information about how to present a body part. When a body part is to be treated as an attached file, the Content-Disposition header should include a file name parameter.</div> <div class="refsect2"> <span class="refsect2title">transfer_encoding – </span> The encoding method to use, such as base64.</div> <div class="refsect2"> <span class="refsect2title">data – </span> The content of the message.</div> </div> <div class="refsect1"> <div class="refsect1title">Return Types</div> <p>The function returns a MIME part for use with the <span class="computeroutput">mime_body()</span> function.</p> </div> <div class="refsect1"> <div class="refsect1title">Examples</div> <a name="ex_mime_part" /> <div class="example"> <div class="exampletitle">Creating a MIME message body</div> <p>This example will show the output in ISQL of producing a two part MIME message using the mime_body() and mime_part() functions.</p> <div> <pre class="screen"> SQL> select MIME_BODY (vector (MIME_PART (null,null,null,'this is a first'), MIME_PART (null,null,'base64','this is a second'))); callret VARCHAR _______________________________________________________________________________ Date: Tue, 25 Jun 2002 11:13:05 GMT Content-Type: multipart/mixed; boundary="----43c7f8b88e14a87dc3f2d840db93c731" Mime-Version: 1.0 X-Mailer: Virtuoso This is a multi-part message in MIME format. ------43c7f8b88e14a87dc3f2d840db93c731 Content-Type: text/plain Content-Transfer-Encoding: 8bit this is a first ------43c7f8b88e14a87dc3f2d840db93c731 Content-Type: text/plain Content-Transfer-Encoding: base64 dGhpcyBpcyBhIHNlY29uZA== ------43c7f8b88e14a87dc3f2d840db93c731-- 1 Rows. -- 21 msec. </pre> </div> </div> </div> <div class="refsect1"> <div class="refsect1title">See Also</div> <p> <a href="fn_mime_part.html">mime_part()</a> </p> <p> <a href="fn_mime_body.html">mime_body()</a> </p> </div> </div> <div id="footer"> <div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div> <div id="validation"> <a href="http://validator.w3.org/check/referer"> <img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" /> </a> <a href="http://jigsaw.w3.org/css-validator/"> <img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" /> </a> </div> </div> </body> </html>