All Results From Query To Email?

[Guest Matthew]

Given that I dont know how many results will be obtained from a select query, how can I formulate my email module so that it will call upon all rows and columns found from within the query module? The _Row_Column method will mean I have to enter in too many records to make sure I get everything, or if I dont, then some information would be missing.

 

I would like to have in the message body: $RV[dbase query] *

 

Instead of: message body:

 

$RV[dbase query_1_1] $RV[dbase query_1_2]

$RV[dbase query_2_1] $RV[dbase query_2_2]

$RV[dbase query_3_1] ...etc

*

*

*

etc

[SupportTeam]

If an RV does not exist it will be replaced by a blank....(ie: it will be deleted)

 

So the easiest thing would be to list all the possible RVs that could be populated and the ones that will be available will be replaced with their values, and the ones that are not will just be deleted...

 

This is currently the only way of specifying DB Query results, there is no RV which would be replaced by all the results...