Foundset to Html

Classic Servoy
1

Hi . I’m wanting to output the filtered foundset to html so I can copy if display in html-area or copy via clipboard to an Email, or Excel etc.

Using GetDataSetByQuery does it in one step… i.e.: sql_result = ‘’ + vDataSet.getAsHTML();
How would I do this with a filtered found set.
Do I have to loop through the foundset and build it manually?
Thanks
Mark

2

Mark Crichton:
Do I have to loop through the foundset and build it manually?

The JSFoundset object doesn’t have a HTML formatter function like the JSDataSet has so the answer is yes.
You might want to look at the following thread: viewtopic.php?f=22&t=18252#p98284

Hope this helps.

3

sql_result = ‘’ + databaseManager.convertToDataSet(foundset).getAsHTML()

4

…or you convert it to a JSDataSet. :shock:

Nice one David!

5

:)

and nice speed write-up. never enough speed testing going on.

6

Many Thanks David
Added the fields I wanted and works a treat. :mrgreen:

7

Hi Robert
Thanks for your response. I’ve had a look at the link. Excellent code comparisons. Learning Velocity is probably the next step I need to take.