Re: Donovans Theorem
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 54967
interpreted = N
texte = Good Luck Class!
Donovan's Theorem Donovan's Theorem
The object of this game is to return the following:
Include ONLY records which contain CATEGORY = [theCATEGORY] and/or BRAND = [theBRAND]
Exclude records with the ID = [the_ID]
Exclude records with the PRODUCT_ID = [ProdID]
Exclude all other records.
Extra credit:
Return a summary of the resulting PRODUCT_ID
[TEXT]the_DB=test.db[/TEXT] [TEXT]the_ID=7[/TEXT] [TEXT]ProdID=98765[/TEXT] [TEXT]theCATEGORY=SHOES[/TEXT] [TEXT]theBRAND=Z[/TEXT] theCATEGORY = [theCATEGORY]
theBRAND = [theBRAND]
| ID | PRODUCT_ID | CATEGORY | BRAND | NO_INVENTORY | SIZES | COLOURS | DESCRIPTIVE |
[search db=[the_DB][!] [/!]&eqCATEGORYdata=[theCATEGORY][!] [/!]&eqBRANDdata=[theBRAND][!] [/!]&nePIDdatarq=[the_ID][!] [/!]&nePRODUCT_IDdataRQ=[ProdID]] NUMFOUND: [Numfound] [founditems] | [PID] | [PRODUCT_ID] | [CATEGORY] | [BRAND] | [NO_INVENTORY] | [SIZES] | [COLOURS] | [DESCRIPTIVE] |
[/founditems] [/search]
/***************************** test.db *******************************/ PID PRODUCT_ID CATEGORY BRAND NO_INVENTORY SIZES COLOURS DESCRIPTIVE 1 12345 TSHIRTS Z 10 L RED This is a large red Z brand T-shirt 2 12345 TSHIRTS Z 10 S BLUE This is a small blue Z brand T-shirt 3 76543 SOCKS Q 10 M WHITE This is a Medium white Q brand sock 4 98765 SHOES Z 10 11 RED-WHITE This is a 11 sized Z brand red and white shoe 5 98765 SHOES Z 10 12 BLUE-WHITE This is a 12 sized Z brand blue and white shoe 6 98765 SHOES Z 10 12 GREEN-WHITE This is a 12 sized Z brand GREEN and white shoe 7 98765 SHOES Z 10 13 GREEN-WHITE This is a 13 sized Z brand GREEN and white shoe 8 98765 SHOES Z 10 26 GREEN-WHITE This is a 26 sized Z brand GREEN and white shoe 9 98765 SHOES Z 10 5 GREEN-WHITE This is a 5 sized Z brand GREEN and white shoe 10 76543 SOCKS Q 10 L WHITE This is a Large white Q brand sock 11 90871 SHOES R 10 26 RED This is a 26 sized R brand RED shoe 12 90871 SHOES R 10 10 RED This is a 10 sized R brand RED shoe 13 90871 SHOES R 10 10 BLUE This is a 10 sized R brand BLUE shoe 14 34567 SHOES S 10 10 BLUE This is a 10 sized S brand BLUE shoe 15 34567 SHOES S 10 11 BLUE This is a 11 sized S brand BLUE shoe 16 34567 SHOES S 10 10 GREEN This is a 10 sized S brand GREEN shoe ------------------------------------------------------------- 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:
Good Luck Class! Donovan's Theorem Donovan's Theorem
The object of this game is to return the following:
Include ONLY records which contain CATEGORY = [theCATEGORY] and/or BRAND = [theBRAND]
Exclude records with the ID = [the_ID]
Exclude records with the PRODUCT_ID = [ProdID]
Exclude all other records.
Extra credit:
Return a summary of the resulting PRODUCT_ID
[text]the_DB=test.db[/TEXT] [text]the_ID=7[/TEXT] [text]ProdID=98765[/TEXT] [text]theCATEGORY=SHOES[/TEXT] [text]theBRAND=Z[/TEXT] theCATEGORY = [theCATEGORY]
theBRAND = [theBRAND] | ID | PRODUCT_ID | CATEGORY | BRAND | NO_INVENTORY | SIZES | COLOURS | DESCRIPTIVE |
[search db=[the_DB][!] [/!]&eqCATEGORYdata=[theCATEGORY][!] [/!]&eqBRANDdata=[theBRAND][!] [/!]&nePIDdatarq=[the_ID][!] [/!]&nePRODUCT_IDdataRQ=[ProdID]] NUMFOUND: [Numfound] [founditems] | [PID] | [PRODUCT_ID] | [CATEGORY] | [BRAND] | [NO_INVENTORY] | [SIZES] | [COLOURS] | [DESCRIPTIVE] |
[/founditems] [/search]
/***************************** test.db *******************************/ PID PRODUCT_ID CATEGORY BRAND NO_INVENTORY SIZES COLOURS DESCRIPTIVE 1 12345 TSHIRTS Z 10 L RED This is a large red Z brand T-shirt 2 12345 TSHIRTS Z 10 S BLUE This is a small blue Z brand T-shirt 3 76543 SOCKS Q 10 M WHITE This is a Medium white Q brand sock 4 98765 SHOES Z 10 11 RED-WHITE This is a 11 sized Z brand red and white shoe 5 98765 SHOES Z 10 12 BLUE-WHITE This is a 12 sized Z brand blue and white shoe 6 98765 SHOES Z 10 12 GREEN-WHITE This is a 12 sized Z brand GREEN and white shoe 7 98765 SHOES Z 10 13 GREEN-WHITE This is a 13 sized Z brand GREEN and white shoe 8 98765 SHOES Z 10 26 GREEN-WHITE This is a 26 sized Z brand GREEN and white shoe 9 98765 SHOES Z 10 5 GREEN-WHITE This is a 5 sized Z brand GREEN and white shoe 10 76543 SOCKS Q 10 L WHITE This is a Large white Q brand sock 11 90871 SHOES R 10 26 RED This is a 26 sized R brand RED shoe 12 90871 SHOES R 10 10 RED This is a 10 sized R brand RED shoe 13 90871 SHOES R 10 10 BLUE This is a 10 sized R brand BLUE shoe 14 34567 SHOES S 10 10 BLUE This is a 10 sized S brand BLUE shoe 15 34567 SHOES S 10 11 BLUE This is a 11 sized S brand BLUE shoe 16 34567 SHOES S 10 10 GREEN This is a 10 sized S brand GREEN shoe ------------------------------------------------------------- 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/
Marc Kaiwi
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:
[WebDNA] Resolve IP to Domain (2018)
Online reference (1997)
creating a 60 fields database (1997)
SpiderBotLock! (2003)
[WebDNA] Carriage Return/Line Feed Issue (2009)
SiteEdit NewFile.html ? (1997)
New syntax feedback for 4.0 (2000)
[OT] Changing permissions on W2003 via FTP (2007)
Virtual Domains (1998)
syntax question, not in online refernce (1997)
It finally happened ... (2003)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
unix permissions theory applied to db security? Or...? (2000)
Not really WebCat- (1997)
Createfolder / writefile problem (2004)
Help! WebCat2 bug (1997)
RE: 2nd WebCatalog2 Feature Request (1996)
ErrorLog with Linux? (2000)
Calendar (1997)
sorting by date (1999)