[REBOL] Variables
From: drdoall:verizon at: 16-Mar-2008 10:43
I am having trouble getting the selected data to pass to header. Any help
would be appreciated.
Thanks
Jim
Rebol []
do %lib/sqlite.r
set-net [drdoall-verizon.net outgoing.verizon.net incoming.verizon.net none
none none "drdoall" "xxxxxxxxx"]
connect/direct %/c/jim/sqlite_databases/lsc_residents.db3
db: SQL "select email from residents where lname = 'Richards'"
get_data: func [line: db/1]
foreach row db [
header: make system/standard/email [
[get_data line]
reform ["To:" line]
From: drdoall-verizon.net
Subject: "Lake St. Charles Softball League"
Organization: "Lake St. Charles"
Mime-Version: 1.0
Content-Type: "text/html"; charset=ISO-8859-1
]
send/header get_data trim{
<html>
<head>
<title>No title</title>
<meta name="generator" content="Namo WebEditor v5.0(Trial)">
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<p> </p>
<table align="center" border="1" cellpadding="5" cellspacing="5" width="80%"
bgcolor="#CCCCCC" bordercolordark="white" bordercolorlight="black">
<tr>
<td>
<p align="center" style="line-height:100%; margin-top:0;
margin-bottom:0;"> </p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="center"><img src="http://drdoall.com/images/lscsoftballheader.jpg"
width="379" height="93" border="0"></p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="center"> </p>
</td>
</tr>
<tr>
<td>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="left"> </p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="left"><img src="http://drdoall.com/images/softball_field.jpg"
align="left" width="250" height="189" border="0" vspace="5" hspace="5">For
those of you who are not aware Lake St. Charles has a new
baseball
/ softball field complete with bleacher stands for spectators.
This
new asset has already seen a lot of use and gotten rave reviews
from many of our parents and children of Lake St. Charles.</p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="left"> </p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="left">I
would like to thank the Board of Supervisors for allocating the
funds for this amenity and I would also like to thank the staff
for being creative and thrifty with taxpayer funds. Dave Welling
(Property Manager) and his staff built our field of dreams for
less
than $5,000. These funds also included the addition of bleacher
stands for the soccer field as well.</p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="left"> </p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="center"><span style="font-size:20pt;"><b>Get
In On The Fun!!!</b></span></p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="center"><span style="font-size:20pt;"><b> </b></span></p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="left">I
am in the process of developing a list of residents who would
like
to particpate in a coed slow pitch softball league. If you would
like to meet some of your neighbors and enjoy some outdoor
activities
then this is for you.</p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="left"> </p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="left">Please
email or call me.</p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="left"> </p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="center"><span style="font-size:20pt;"><b>See
You Out There!!!</b></span></p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="left"><span style="font-size:20pt;"><b> </b></span></p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="left">Jim
Richards</p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="left"><a
href="mailto:drdoall-verizon.net">drdoall-verizon.net</a></p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="left">813-323-8683</p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="left"><span style="font-size:20pt;"><b> </b></span></p>
<p style="line-height:100%; margin-top:0; margin-bottom:0;"
align="left"><span style="font-size:20pt;"><b> </b></span></p>
</td>
</tr>
</table>
<p> </p>
</body>
</html>
}header
]
