|
Posted by George Pitcher on 10/11/57 11:15
Hi guys,
I'm doing something dumb but I can't see it.
The basic premise is:
sql search of orders sorted by customer
set g_customer_id to ''
loop through resultset
if customer_id not same as last record's customer_id (g_customer_id)
get customer email details
set up message header if this is the first record for a customer
set item details
else
set item details
set g_customer_id to customer_id
endif
send email
end loop
The problem is that as a sample I have two records from one demo customer
(me) and I can only get my email to handle one record - either sending
separate records for each record or one email covering the last record only
Its as if I should have another inner loop
Any tips
MTIA
George
Navigation:
[Reply to this message]
|