Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT]

This WebDNA talk-list message is from

2011

It keeps the original formatting. numero = 106971
interpreted = N
texte = Brian Fries wrote:> Here's one to spark your imagination, Donovan…>> I've been known to have code in one place that decides whether it's using a db or a table:>> [text]tDBPath=[if …][then]db=my.db[/then][else]table=mytable[/else][/if][/text]>> … then later use that in a search:>> [search [tDBPath]&wofielddata=…]>> … It would be nice to be able to then use listfields:>> [listfields [tDBPath]]> [fieldname]=[interpret][[fieldname]][/interpret]
> [/listfields]>>> Sure there are workarounds, but every WebDNA tag that takes a "db" parameter should alternatively take a "table" parameter so consistent coding can be used / reused.>> Brian Fries> BrainScan SoftwareHey!, I've seen that style of coding before.. somewhere? ;-)I see a point to it, don't get me wrong. I think a "fix" like this would likely come down to priorities and policy however. "It's a workable idea, but is it really needed right now?" sort of thing. Note, WSC would have to change [listdatabases...] as well.Anyway, as Brian mentioned, even with his complex style of coding, a global listfiles type of feature could be accommodated with some key naming conventions set.:----------------[text]tf_mytable=id,name[/text][table name=tb_test&fields=[tf_mytable]]1Fred2john[/table][text]tDBPath=[if …][then]db=my.db[/then][else]table=mytable[/else][/if][/text][if "[tDBPath]"^".db"][then] [listfields [tDBPath]] [fieldname]=[interpret][[fieldname]][/interpret]
 [/listfields][/then][else] [listwords words=[interpret][tf_[tDBPath]][/interpret]] [word]
 [/listwords][/else][/if]----------------You could shorten the use of this feature up with your own function [db_listfields ..]Note, I don't officially work for WSC right at this time, so these are just my *developer* opinions.Donovan-- Donovan Brooke**[Square Bracket Utopia]** Associated Messages, from the most recent to the oldest:

Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT] MySQL Users (Kenneth Grome 2011) Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT] (Donovan Brooke 2011) Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT] (Donovan Brooke 2011) Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT] MySQL Users (Brian Fries 2011) Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT] (Donovan Brooke 2011) Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT] MySQL Users (Govinda 2011) [WebDNA] Now: Listfields does not work with tables - Was: [OT] MySQL Users (Donovan Brooke 2011)

Brian Fries wrote:> Here's one to spark your imagination, Donovan…>> I've been known to have code in one place that decides whether it's using a db or a table:>> [text]tDBPath=[if …][then]db=my.db[/then][else]table=mytable[/else][/if][/text]>> … then later use that in a search:>> [search [tDBPath]&wofielddata=…]>> … It would be nice to be able to then use listfields:>> [listfields [tDBPath]]> [fieldname]=[interpret][[fieldname]][/interpret]
> [/listfields]>>> Sure there are workarounds, but every WebDNA tag that takes a "db" parameter should alternatively take a "table" parameter so consistent coding can be used / reused.>> Brian Fries> BrainScan SoftwareHey!, I've seen that style of coding before.. somewhere? ;-)I see a point to it, don't get me wrong. I think a "fix" like this would likely come down to priorities and policy however. "It's a workable idea, but is it really needed right now?" sort of thing. Note, WSC would have to change [listdatabases...] as well.Anyway, as Brian mentioned, even with his complex style of coding, a global listfiles type of feature could be accommodated with some key naming conventions set.:----------------[text]tf_mytable=id,name[/text][table name=tb_test&fields=[tf_mytable]]1Fred2john[/table][text]tDBPath=[if …][then]db=my.db[/then][else]table=mytable[/else][/if][/text][if "[tDBPath]"^".db"][then] [listfields [tDBPath]] [fieldname]=[interpret][[fieldname]][/interpret]
 [/listfields][/then][else] [listwords words=[interpret][tf_[tDBPath]][/interpret]] [word]
 [/listwords][/else][/if]----------------You could shorten the use of this feature up with your own function [db_listfields ..]Note, I don't officially work for WSC right at this time, so these are just my *developer* opinions.Donovan-- Donovan Brooke**[Square Bracket Utopia]** Donovan Brooke

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

[OT] Appropriate Signature??? (2003) The beginning (1997) Truncated numbers (2000) Emailer problems (1998) Banners (1997) Site Builder & IE Mac (2004) How to best sort in a pre-defined item-by-item order ... (2003) HELP WITH DATES (1997) WebCatalog can't find database (1997) Gil's in the lead (1999) Grant, please help me ... (1997) NT error logs (1997) CC Merchant suggestions?? (1997) Re:Emailer Set Up (1997) [Webcat 2]Next (1997) Buying sans cart (1997) A multi-processor savvy WebCatalog? (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997) Using [redirect] in the middle of a page? (1999) More on the email templates (1997)