Variables

[1/1] 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">   <table align="center" border="1" cellpadding="5" cellspacing="5" width="80%" bgcolor="#CCCCCC" bordercolordark="white" bordercolorlight="black"> <tr> <td>   <img src="http://drdoall.com/images/lscsoftballheader.jpg" width="379" height="93" border="0">   </td> </tr> <tr> <td>   <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.   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.   Get In On The Fun!!!   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.   Please email or call me.   See You Out There!!!   Jim Richards <a href="mailto:drdoall-verizon.net">drdoall-verizon.net</a> 813-323-8683     </td> </tr> </table>   </body> </html> }header ]