Hello all.

I return results from a SQL statement through lasso via the following:

SELECT cartypes.cartypes_name, car.name FROM car LEFT JOIN cartypes ON
car.cartypes_id=cartypes.id where cartypes.brand_id="ford";

It output the results:


sedan tempo
sedan escort
sedan LTD
sedan mustang
convertible mustang
pickup f-150
pickup f-250
pickup f-350


I need to have the result dynamically build an HTML table with each
column being headed by the cartypes_name field returned and each car
name under it like this:


sedan convertible pickup
-----------------------------------------------
tempo mustang f-150
escort f-250
LTD f-350
mustang

So if the query were to find more cartypes, more columns would be
constructed dynamically.

Any info is appreciated as I'm sure I'm missing something obvious.

--Rick

#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso
Lasso@lists.lassosoft.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>