cfmail query error

[fusionaire]

I cannot figure out why this doesn't work, any help would be GRAND.<br><br>HERE IS THE CODE:<br><br>&lt;cfinsert datasource=&quot;#session.dsn#&quot;<br> tablename=&quot;writecustomers&quot;<br> formfields=&quot;name, address, city, state, zip, country, phone, fax, email, needed, type, comment, contact_by&quot;&gt;<br> <br> <br>&lt;cfquery datasource=&quot;#session.dsn#&quot; name=&quot;WriteCustomers&quot;&gt;<br>SELECT *<br>FROM writecustomers<br>&lt;/cfquery&gt;<br> <br> <br> &lt;CFMAIL query=&quot;WriteCustomers&quot;<br> FROM =&quot;#FORM.email#&quot;<br> TO=&quot;<A HREF="mailto:info@pontifixx.com">info@pontifixx.com</A>&quot;<br> SUBJECT=&quot;Test&quot;&gt;<br> <br> &lt;/cfmail&gt;<br>

 

[SnakeHollywood]

You have not stated where the error is.<br>Is is in the CFinsert, the cfquery or the cfmail tag.<br><br>you also have not stated what the error is.<br><br>Mind reading is only fictional yaknow <br><br> <p>Russ Michaels<br><a href=mailto:russ@satachi.com>russ@satachi.com</a><br><a href=

http://www.satachi.com>Satachi

Internet Development</a><br>For my personal book recommendations visit

http://www.satachi.com/books.html<br>

<br>

 

[achai]

i think <br>FROM =&quot;#FORM.email#&quot; is wrong.<br>should be<br>from=&quot;#fieldname#&quot;

 

[celley]

from=&quot;#writecustomers.email#&quot;<br><br>and not FORM.email