Re: Is there a max number of fields?

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19233
interpreted = N
texte = >The advantage of SQL, is that you can search at the same time in two >different fields from two different databases. > While this is true, it is also a disadvantage of SQL at times unless there's a 1:1 correspondance to data entries. (the dreaded outer-join vs. inner join issues).You can approximate it with WebCat by using embedded lookups inside the [founditems]. The lookups are very fast. You just need to specify your .db's so there's one field needed for specifying the one return field. Or you could embed a search inside a search. This could get hairy if you don't plan carefully.Good luck!Sandy Associated Messages, from the most recent to the oldest:

    
  1. Re: Is there a max number of fields? (Charles Kefauver 1998)
  2. Re: Is there a max number of fields? (Sandra L. Pitner 1998)
  3. Re: Is there a max number of fields? (Charles Kefauver 1998)
  4. Re: Is there a max number of fields? (Sandra L. Pitner 1998)
  5. Re: Is there a max number of fields? (Angel Bennett 1998)
  6. Re: Is there a max number of fields? (Charles Kefauver 1998)
  7. Re: Is there a max number of fields? (Sandra L. Pitner 1998)
  8. Re: Is there a max number of fields? (Charles Kefauver 1998)
  9. Re: Is there a max number of fields? (Charles Kefauver 1998)
  10. Re: Is there a max number of fields? (Angel Bennett 1998)
  11. Re: Is there a max number of fields? (Kenneth Grome 1998)
  12. Re: Is there a max number of fields? (PCS Technical Support 1998)
  13. Is there a max number of fields? (Charles Kefauver 1998)
>The advantage of SQL, is that you can search at the same time in two >different fields from two different databases. > While this is true, it is also a disadvantage of SQL at times unless there's a 1:1 correspondance to data entries. (the dreaded outer-join vs. inner join issues).You can approximate it with WebCat by using embedded lookups inside the [founditems]. The lookups are very fast. You just need to specify your .db's so there's one field needed for specifying the one return field. Or you could embed a search inside a search. This could get hairy if you don't plan carefully.Good luck!Sandy Sandra L. Pitner

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:

[isfile] ? (1997) randomness (1997) Three new problems, maybe a fourth (1997) [OT] Multihoming Windows 2003 Server (2005) suffix mapping for NT? (1997) Display [price] in banner ad (1998) bad idea to not use any html files, only .tpl files? (1999) Search returns all, not 20 (1997) How Many SKU's is enough? (1997) Has ANYONE gotten the [object] context to work with Java(OSX) ??? HELP! (2002) [WebDNA] WebDNA app (2013) [isfile] ? (1997) Seeking Better Display of results... (1997) Linux vs Jaguar (OSX) (2002) Press Release hit the NewsWire!!! (1997) Custom Shipping Charges (1997) Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997) Subdomain mapping for SSL (2002) Javascript/WebCatalog form population (2001) For those of you not on the WebCatalog Beta... (1997)