This is kinda of a classic rows to columns view?
On Feb 22, 2012, at 4:31 PM, Johan Solve wrote:
> Not pivot table output.
>
> 2012/2/22 Jonathan Guthrie <Jono@lassosoft.com>:
>> Doesn't Knop do something like this automatically?
>>
>> On 2012-02-22, at 5:07 PM, Rick Dwyer wrote:
>>
>>> 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:
>>
>> Jono
>>
>> ----------------------------
>> Jonathan Guthrie
>> jono@lassosoft.com
>> LassoSoft Inc.
>>
>> #############################################################
>> 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>
>
>
>
> --
> Mvh
> Johan S=F6lve
> ____________________________________
> Montania System AB
> Halmstad Stockholm
> http://www.montania.se
>
> Johan S=F6lve
> Mobil +46 709-51 55 70
> johan@montania.se
>
> Kristinebergsv=E4gen 17, S-302 41 Halmstad, Sweden
> Telefon +46 35-136800 | Fax +46 35-136801
> #############################################################
> 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>
#############################################################
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>
Constructing tables from output
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 cart...
Re: Constructing tables from output
Yes, you should look at to doing an SQL pivot.
here is an excellent link
http://www.artfulsoftware.com/infotree/queries.php
Look for pivot tables. It should give you what you need to construc...
Re: Constructing tables from output
Doesn't Knop do something like this automatically?
On 2012-02-22, at 5:07 PM, Rick Dwyer wrote:
> I need to have the result dynamically build an HTML table with each column being headed by the c...
Re: Constructing tables from output
kNope. Not automatically.
The difficulty of doing this with Knop or a plain old Lasso
inline is the same.
Here is an example of how to manipulate news articles under a
given year, with uniq...
Re: Constructing tables from output
Not pivot table output.
2012/2/22 Jonathan Guthrie <Jono@lassosoft.com>:
> Doesn't Knop do something like this automatically?
>
> On 2012-02-22, at 5:07 PM, Rick Dwyer wrote:
>
>> I need to ha...
Re: Constructing tables from output
Must have been a tag I saw on tagswap?
On 2012-02-22, at 6:14 PM, Steve Piercy - Web Site Builder wrote:
> kNope. Not automatically.
Jono
----------------------------
Jonathan Guthrie
j...
Re: Constructing tables from output
Not because you don't want it or the example?
On Feb 22, 2012, at 4:31 PM, Johan Solve wrote:
> Not pivot table output.
>
> 2012/2/22 Jonathan Guthrie <Jono@lassosoft.com>:
>> Doesn't Kno...
Re: Constructing tables from output
This is kinda of a classic rows to columns view?
On Feb 22, 2012, at 4:31 PM, Johan Solve wrote:
> Not pivot table output.
>
> 2012/2/22 Jonathan Guthrie <Jono@lassosoft.com>:
>> Doesn't Kn...
To find out more about this list or how to subscribe - choose the 'i' next to the list name on the right, or click here for more information about LassoTalk