Re: Searching Relational Databases
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55642
interpreted = N
texte = I've since rendered my program to not deal with this issue anymore. I =think it will be usefull snippet for people looking for this functionality =in the future. Thanks again.Justin CarrollOn Saturday, February 27, 1943, Alex McCombie
=wrote:>On 1/8/04 2:56 PM, "Alex McCombie" >wrote:>>Justin,=20>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:>>=20>> Added a hideif to stop the duplicate entry on the secondary array when =the>> listwords index =3D 2 and the value is greater.>>=20>> I cant get to testing this anytime soon.>>=20>> Anyone else want to?>>=20>>=20>>=20>>=20>>=20>>=20>>> 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....>>=20>> BUT, assuming that you cant do that or since this is just an example =you>> could use the following complex logic.>>=20>> Search on the business.db on your criteria and return a results list =that>> just seeds your variables:>>=20>>=20>> [Text]Businessrank=3D[/text]>> [Text]Businesssku=3D[/text]>> [Text]Busrerank=3D[/text]>>=20>> [search business.db&on something]>> [founditems]>> [text]indexvar=3D[index][/text]>>=20>> [search db=3Demployee.db&eqbusiness_skudatarq=3D[sku]]>> [showif [indexvar]=3D1]>> [text]businessrank=3D[SKU]|[numfound]|[/text]>> [/showif]>>=20>> [showif [indexvar]>1]>> [text]totalvar=3D[CountWords Delimiters=3D|][businessrank][/countwords][=/text]>> =20>> [listwords words=3D[businessrank] Delimiters=3D|]>>=20>> [showif [index]\2]>> [showif [numfound]>[word]]>> [text]busrerank=3D[sku]|numfound]|[busrerank][/text]>> [/showif]>> [showif [index]=3D[totalvar]]>> [hideif [numfound]>[word]]>> [text]busrerank=3D[busrerank]|[sku]|numfound]|[/text]>> [/hideif]>> [/showif]>> [/showif]>>=20>> [/listwords]>>=20>> [listwords words=3D[busrerank] Delimiters=3D|]>> [hideif [index]\2]>> [Text]Businesssku=3D[businesssku]|[word][/text]>> [/listwords]>>=20>> [/founditems]>> [/search]>>=20>>=20>> [listwords words=3D[businesssku] Delimiters=3D|]>> [Lookup=20>> db=3Dbusiness.db&value=3D[word]&lookInField=3Dsku&=returnField=3Dbusiness_name¬Fou>> nd=3D]>>=20>> [/listwords]>>=20>>=20>>=20>>=20>>=20>> 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.>>=20>> 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.>>=20>>=20>> Anyone?>>=20>>=20>> Alex J McCombie New World Media>> Chief Information Officer Box 124>> 888/892.6379 MartVille, NY 13111>> Alex@NewWorldMedia.com http://OurClients.com>>=20>> Interface Designer WebDNA Programmer Database Designer>>=20>>=20>>>Alex J McCombie New World Media>Chief Information Officer Box 124>888/892.6379 MartVille, NY 13111>Alex@NewWorldMedia.com =20>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/>-------------------------------------------------------------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:
I've since rendered my program to not deal with this issue anymore. I =think it will be usefull snippet for people looking for this functionality =in the future. Thanks again.Justin CarrollOn Saturday, February 27, 1943, Alex McCombie =wrote:>On 1/8/04 2:56 PM, "Alex McCombie" >wrote:>>Justin,=20>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:>>=20>> Added a hideif to stop the duplicate entry on the secondary array when =the>> listwords index =3D 2 and the value is greater.>>=20>> I cant get to testing this anytime soon.>>=20>> Anyone else want to?>>=20>>=20>>=20>>=20>>=20>>=20>>> 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....>>=20>> BUT, assuming that you cant do that or since this is just an example =you>> could use the following complex logic.>>=20>> Search on the business.db on your criteria and return a results list =that>> just seeds your variables:>>=20>>=20>> [text]Businessrank=3D[/text]>> [text]Businesssku=3D[/text]>> [text]Busrerank=3D[/text]>>=20>> [search business.db&on something]>> [founditems]>> [text]indexvar=3D[index][/text]>>=20>> [search db=3Demployee.db&eqbusiness_skudatarq=3D[sku]]>> [showif [indexvar]=3D1]>> [text]businessrank=3D[SKU]|[numfound]|[/text]>> [/showif]>>=20>> [showif [indexvar]>1]>> [text]totalvar=3D[CountWords Delimiters=3D|][businessrank][/countwords][=/text]>> =20>> [listwords words=3D[businessrank] Delimiters=3D|]>>=20>> [showif [index]\2]>> [showif [numfound]>[word]]>> [text]busrerank=3D[sku]|numfound]|[busrerank][/text]>> [/showif]>> [showif [index]=3D[totalvar]]>> [hideif [numfound]>[word]]>> [text]busrerank=3D[busrerank]|[sku]|numfound]|[/text]>> [/hideif]>> [/showif]>> [/showif]>>=20>> [/listwords]>>=20>> [listwords words=3D[busrerank] Delimiters=3D|]>> [hideif [index]\2]>> [text]Businesssku=3D[businesssku]|[word][/text]>> [/listwords]>>=20>> [/founditems]>> [/search]>>=20>>=20>> [listwords words=3D[businesssku] Delimiters=3D|]>> [Lookup=20>> db=3Dbusiness.db&value=3D[word]&lookInField=3Dsku&=returnField=3Dbusiness_name¬Fou>> nd=3D]>>=20>> [/listwords]>>=20>>=20>>=20>>=20>>=20>> 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.>>=20>> 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.>>=20>>=20>> Anyone?>>=20>>=20>> Alex J McCombie New World Media>> Chief Information Officer Box 124>> 888/892.6379 MartVille, NY 13111>> Alex@NewWorldMedia.com http://OurClients.com>>=20>> Interface Designer WebDNA Programmer Database Designer>>=20>>=20>>>Alex J McCombie New World Media>Chief Information Officer Box 124>888/892.6379 MartVille, NY 13111>Alex@NewWorldMedia.com =20>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/>-------------------------------------------------------------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/
Justin Carroll
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:
RE: Displaying Location (1997)
Email Problem (1997)
Upgrading old WebCat Database Files (1997)
sort problems....bug or brain fart? (1997)
Help! WebCat2 bug (1997)
Initiating NewCart (1997)
How to best sort in a pre-defined item-by-item order ... (2003)
2.0 Info (1997)
Blowback and budgets. - OT (2000)
RE: Is there a 'does not contain' comparison? (1999)
WebCat B13 Mac CGI -- Frames question (1997)
YACBQ.....(Yet another checkbox question) (2000)
2nd WebCatalog2 Feature Request (1996)
[TaxableTotal] - not working with AOL and IE (1997)
A little syntax help (1997)
Sorry I didn't pay attention-but ??? (1997)
Roundup function? (1997)
absolute paths for databases? (1997)
Sorting problem (1997)
Security Levels... Possible? (2000)