Re: Searching Relational Databases

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55322
interpreted = N
texte = On 1/8/04 2:13 PM, "Justin Carroll" wrote: > We're using version 4.0.2 rc2 Thanks. Of course in this scenario this could be solved by adding a field to the business.db that contains a updated total employee count that would be modified by the add/delete in the employee system.... BUT, assuming that you cant do that or since this is just an example you could use the following complex logic. Search on the business.db on your criteria and return a results list that just seeds your variables: [Text]Businessrank=[/text] [Text]Businesssku=[/text] [Text]Busrerank=[/text] [search business.db&on something] [founditems] [text]indexvar=[index][/text] [search db=employee.db&eqbusiness_skudatarq=[sku]] [showif [indexvar]=1] [text]businessrank=[SKU]|[numfound]|[/text] [/showif] [showif [indexvar]>1] [text]totalvar=[CountWords Delimiters=|][businessrank][/countwords][/text] [listwords words=[businessrank] Delimiters=|] [showif [index]\2] [showif [numfound]>[word]] [text]busrerank=[sku]|numfound]|[busrerank][/text] [/showif] [showif [index]=[totalvar]] [text]busrerank=[busrerank]|[sku]|numfound]|[/text] [/showif] [/showif] [/listwords] [listwords words=[busrerank] Delimiters=|] [hideif [index]\2] [Text]Businesssku=[businesssku]|[word][/text] [/listwords] [/founditems] [/search] [listwords words=[businesssku] Delimiters=|] [Lookup db=business.db&value=[word]&lookInField=sku&returnField=business_name¬Fou nd=] [/listwords] I believe this is fairly solid. It should give you a variable with the skus to the business.db sorted from largest to smallest which you could then use to do the lookups in order. Like I said, this is UNTESTED, but I believe the logic is fairly sound, give or take a syntax error here or there... I just threw it together to get us started. Anyone? Alex J McCombie New World Media Chief Information Officer Box 124 888/892.6379 MartVille, NY 13111 Alex@NewWorldMedia.com http://OurClients.com Interface Designer WebDNA Programmer Database Designer ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Searching Relational Databases ( Justin Carroll 2004)
  2. Re: Searching Relational Databases ( Justin Carroll 2004)
  3. Re: Searching Relational Databases ( Alex McCombie 2004)
  4. Re: Searching Relational Databases ( Alex McCombie 2004)
  5. Re: Searching Relational Databases ( Alex McCombie 2004)
  6. Re: Searching Relational Databases ( Alex McCombie 2004)
  7. Re: Searching Relational Databases ( Marc Kaiwi 2004)
  8. Re: Searching Relational Databases ( Justin Carroll 2004)
  9. Re: Searching Relational Databases ( Alex McCombie 2004)
  10. Re: Searching Relational Databases ( Marc Kaiwi 2004)
  11. Re: Searching Relational Databases ( Marc Kaiwi 2004)
  12. Searching Relational Databases ( Justin Carroll 2004)
On 1/8/04 2:13 PM, "Justin Carroll" wrote: > We're using version 4.0.2 rc2 Thanks. Of course in this scenario this could be solved by adding a field to the business.db that contains a updated total employee count that would be modified by the add/delete in the employee system.... BUT, assuming that you cant do that or since this is just an example you could use the following complex logic. Search on the business.db on your criteria and return a results list that just seeds your variables: [text]Businessrank=[/text] [text]Businesssku=[/text] [text]Busrerank=[/text] [search business.db&on something] [founditems] [text]indexvar=[index][/text] [search db=employee.db&eqbusiness_skudatarq=[sku]] [showif [indexvar]=1] [text]businessrank=[SKU]|[numfound]|[/text] [/showif] [showif [indexvar]>1] [text]totalvar=[CountWords Delimiters=|][businessrank][/countwords][/text] [listwords words=[businessrank] Delimiters=|] [showif [index]\2] [showif [numfound]>[word]] [text]busrerank=[sku]|numfound]|[busrerank][/text] [/showif] [showif [index]=[totalvar]] [text]busrerank=[busrerank]|[sku]|numfound]|[/text] [/showif] [/showif] [/listwords] [listwords words=[busrerank] Delimiters=|] [hideif [index]\2] [text]Businesssku=[businesssku]|[word][/text] [/listwords] [/founditems] [/search] [listwords words=[businesssku] Delimiters=|] [Lookup db=business.db&value=[word]&lookInField=sku&returnField=business_name¬Fou nd=] [/listwords] I believe this is fairly solid. It should give you a variable with the skus to the business.db sorted from largest to smallest which you could then use to do the lookups in order. Like I said, this is UNTESTED, but I believe the logic is fairly sound, give or take a syntax error here or there... I just threw it together to get us started. Anyone? Alex J McCombie New World Media Chief Information Officer Box 124 888/892.6379 MartVille, NY 13111 Alex@NewWorldMedia.com http://OurClients.com Interface Designer WebDNA Programmer Database Designer ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Alex McCombie

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:

listfiles-looking for slick solution (1997) New Plug-in and Type 11 errors (1997) Re:[off] Promotions Co? (1997) [WebDNA] DNA hosting and/or Image server Hosting. (2011) Running _every_ page through WebCat ? (1997) AppleScript/.db (was:FTP to WebStar) (2001) Can a database get stomped by simultaneous access? (1997) [WebDNA] Successful, working WebDNA7/CentOS install? (2013) Who is doing sign-ups-got it (1998) [OT] - Messed up me user permissions - help ! (2004) Forumulas.db & Variables (2002) Q: for those who use Cookies for sessions? (2004) [foundItems] context question --returns some fields but n (2000) WebCat2 several catalogs? (1997) Emailer setup (1997) Configuring E-mail (1997) [shell] (2003) Dividers (2003) PIXO support (1997) emailer settings and control questions (1997)