[jspidy]

im using cfmail to send a confirmation email after a user as completed the registration form the problem iam haveing is sending the message to the person who has created the account.
It just sends the message to everyone in my database the code iam using is as follows

<!-- sql select statement for userdetial start -->
<cfquery name="mail_call_send" datasource="register" password="19mp9x4" username="administrator">
SELECT *
FROM reguser</cfquery>
<!-- sql select statement for userdetial end -->

<!-- sql select statement for carregdetails starts -->
<cfquery name="mail_call_send_1" datasource="register" password="19mp9x4" username="administrator">
SELECT *
FROM usercar</cfquery>



<!--Confirmation Email start -->
<cfmail query="mail_call_send"
from="jasonspidy@hotmail.com"
to="#mail_call_send.Email#"
subject="Your Registration Detials">
<!-- find a way to fetch the email just added to the database through the registration form -->

Please help its doin my head in
cheers jay

[Amadeus]

In your queries, you are selecting all users in the database...you need to select only the one that was just added. I assume that you have some sort of primary key attached to each user, a value that is unique to that user (people often use a number or combination of other fields for this purpose). You can use that identifier to grab the correct user, making you query something like

SELECT * FROM reguser WHERE youridcolumn = userid

The actual userid you can obtain in a myriad of ways...return it to variable after you insert the record, use the count of all records in the table (assuming that your values are ordered), place a special query to get the last inserted record (this will vary depending on what database you are using...some dbs support the last function...so you can just grab the email from the last record, but it is more universal to order your records by primary key and take the max value, or especially a timestamp - assuming that you are timestampint the records).