Re: Searching Relational Databases

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55362
interpreted = N
texte = On 1/8/04 2:56 PM, "Alex McCombie" wrote: Justin, Just curious if this worked for you or got you started? I still havent had time to really test it, but it seemed solid. Alex > On 1/8/04 2:13 PM, "Justin Carroll" > wrote: > > Added a hideif to stop the duplicate entry on the secondary array when the > listwords index = 2 and the value is greater. > > I cant get to testing this anytime soon. > > Anyone else want to? > > > > > > >> 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]] > [hideif [numfound]>[word]] > [text]busrerank=[busrerank]|[sku]|numfound]|[/text] > [/hideif] > [/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 > > 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:56 PM, "Alex McCombie" wrote: Justin, Just curious if this worked for you or got you started? I still havent had time to really test it, but it seemed solid. Alex > On 1/8/04 2:13 PM, "Justin Carroll" > wrote: > > Added a hideif to stop the duplicate entry on the secondary array when the > listwords index = 2 and the value is greater. > > I cant get to testing this anytime soon. > > Anyone else want to? > > > > > > >> 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]] > [hideif [numfound]>[word]] > [text]busrerank=[busrerank]|[sku]|numfound]|[/text] > [/hideif] > [/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 > > 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:

WebCatalog2 Feature Feedback (1996) Price Not Appearing (2000) Formulas.db / Quantity Discount problem (1998) RE: WebDNA-Talk searchable? (1997) 'Sorry WebDNA server not running.' error (2002) First Attempts (2000) founditems / writefile (2005) Searching/sorting dates (1997) Stats (2004) [WebDNA] anyone set up webdna 7 with virtual hosts on mac? (2012) Help! WebCat2 bug (1997) RE: error count with $purchase (1997) Problems getting parameters passed into email. (1997) showcart (2000) math problems (2000) Ok here is a question? (1997) [OT] On a side note.. (2003) WC 2.0 frames feature (1997) [price] maddness (2002) [LOOKUP] (1997)