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 Software Hey!, 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]] 1Fred 2john [/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:

    
  1. Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT] MySQL Users (Kenneth Grome 2011)
  2. Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT] (Donovan Brooke 2011)
  3. Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT] (Donovan Brooke 2011)
  4. Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT] MySQL Users (Brian Fries 2011)
  5. Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT] (Donovan Brooke 2011)
  6. Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT] MySQL Users (Govinda 2011)
  7. [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 Software Hey!, 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]] 1Fred 2john [/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:

[WebDNA] Comparing 2 MySQL tables (2009) WebCatalog 3.0.8 is on FTP... (2000) [WebDNA] [announce] CICADA Gold Products (2009) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Problems passing [SKU] with $Replace in 2.0 (1997) Help! WebCat2 bug (1997) Search on Dates (2000) [ShowIf] and empty fields (1997) Limit to Field Length in DB (1998) Botched cart numbers in webmerchant 2.1x email with webcat 3 (1998) Denying access by IP address (2000) Colors in cart (2002) Setting up shop (1997) shrink-wrapped version out yet? (1997) [WebDNA] setcookie then redirect (2013) Country & Ship-to address & other fields ? (1997) Installing WebCatalog 4.5.1 (2004) Re:Comments Convertion-part2 (1998) Running _every_ page through WebCat ? (1997) WebDNA Developer Edition - Host config problem (2003)