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:

Wierd quantities (2000) Request Time Out (1997) [SHOWIF] (1997) if then else. BUG? (2003) Server slowing down. (1997) emailer (1997) [WebDNA] Max upload file size (2010) Help DebugLevel Content-type: text/html (1998) TcpConnect get files on ver. 5.x BUG BUG BUG (2004) Dark Horse Comics success story (1997) File Upload and Platform (2001) RE: webcat license???? (1997) default value from Lookup (was Grant, please help me) (1997) 2 field showif/hideif's (2002) [WebDNA] [OT] Apple iPad (2010) [WebDNA] HTML [sendmail] revisited (2009) Time for a hard questions. (1997) I've had it! (1999) More on the email templates (1997) Can't Update records (1997)