Recordset not Available for E-Mail

I've had this issue before -- correcting it required adding the Recordsets to the page calling UE, and adding the 'global' statement to the required Recordset variables. I've tried the same here, but the e-mail doesn't include the requested data.

Both the calling page and the template are attached -- thanks. .

Mike

Think order of operations.

the code order on your page is:

* Create recordsets that look up the order info

* Store the order info to the database

* Send the email containing the order info using the recordsets

Since the recordsets are created before the information is saved to the databases, they are not returning a result.

you need to reorder the code so the recordsets come after saving the information to the database and before sending the email for them to work.

A new set of eyes sure helps -- especially ridiculously simple problems like this.

A quick question -- can I "separate" all the functions into separate <?php ?> sections (recordsets, inserts, and the GetSQLValueString code) without causing problems? They get combined when behaviors are added, and it gets confusing rearranging them. . .

Thanks, Jason. . .

Yes, you can create separate code blocks for each function.

One more --

I'm now getting double e-mails; first without the data, and a second one with it. Is there a way to delay triggering the e-mail transmission until after the page loads? Is there an "after page loads" trigger available?

Thanks,

ETA: Actually I'm getting phantom empty record inserts as well. No other "Insert Record" behaviors in the associated pages. . .

use the recordset not empty trigger, there is not an after page loads trigger that you could use.

I think that cured it . .

Cool, glad to hear it is working.