ExecuteSQL results to field repetitions?

[eljefejb]

Hello,

 

Just wondering if it's possible to map each row returned by an ExecuteSQL statement into an individual repetition of a field.  I'm only selecting a single field using ExecuteSQL.  Other than scripting a loop to do the stuffing, I don't see any way to save the query results as myField[1], myField[2], myField[3], etc.

 

Any ideas?  Is it possible?

 

Thanks,

 

Jeff

[comment]

You could store the result in a (non-repeating) text field and have a repeating calculation field parse it out. Not sure what difference that would make, though.