auto email response using Lasso and FM Pro 6

[Quamzibo]

Hi, a while back I was having a problem with the format of an email.txt file that would be the body of an automatic email that would be sent out using the inline script:

[inline: email.host='smtp.bu-london.co.uk', email.to=(Field:'stpermemail'), email.subject='BU London - Update Confirmation', email.format='email.txt', email.from='[email protected]', Nothing]

[/inline]

[Quamzibo]

This inline is placed on a webpage called completed.lasso at the end of a series of html pages that collect information and store them in a FM database.

I eventually figured out one problem with the format of the email.txt file. The format goes something like this:

[inline: -search, -layout='web', -database='students', 'studentid' = (Form_Param:'studentid'), -operator='eq', -maxrecords='1']

[records]

etc etc

[/records]

[/inline]

This works, but only to an extent. See we want it to search through the database and find the information for the person who had just entered in their information. Instead, the email is sent with the information for the first record in the database. Hence, everyone gets the info for the first person in the database sent to them. We need to tell the inline to somehow look through the database and pinpoint the record of the person who was just entering their info.

Thanks for any help.

Paul

[Steve T.]

Howdy, Q! You MIGHT be able to have all new records flagged as "PENDING" or something and then have the inline search for all pending records, send appropriate e-mail messages, and then change the flag to "PROCESSED" for them all. I was going to do something like that for a system I had been working on but ended up switching to another technology. If you need to do a 1:1 kind of thing, you may have use a token or cookie to carry the ID.

Maybe somone else can offer something better, though...

--ST