if you are using v4, can you not use a rowset callback? Create it with an heredoc string and you can execute multiple lines of code per rowset row.

M.

On 6 Dec 2005, at 22:01, Christian Cypert wrote:

I'm getting myself confused on what I think is something straight forward.

Using Fusebox I have a query that returns a selection of records that I place into a Rowset in my query fuse. Now the question is how do I do the following while staying within the Fusebox framework.

With each row in the Rowset I need to do a secondary query on another table and return a set of records to display with the main query. I'm not sure how to put this into a fusebox framework.

I basically need to do the following.

Query([TableA];[TableA]Something=SomethingElse)

For ($i;1;records in selection([TableA])
        Display information from TableA
        Query([TableB];[TableB]Anything=AnythingElse)
                Display information from TableB
end for

If I use a query fuse and then go to a display fuse how can I fit the secondary query within the for loop when displaying records in the display fuse?

Hope that makes sense.

Christian Cypert
[EMAIL PROTECTED]

I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much, of course - the computer industry didn't even foresee that the century was going to end.
- Douglas Adams


_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/

_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/

Reply via email to