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:
Emailer [cart] file names (1997)
Exclamation point (1997)
WebDNA EMail Preference (2005)
WebDNA EMail Preference (2005)
Can't Update records (1997)
RequiredFields notes ... (1997)
Calendar Program (2004)
replace problem (1999)
Emailer Problem (1998)
Here we go again... (2006)
Intermitent problem using [referrer] (1997)
Problems with [Search] param - Mac Plugin b15 (1997)
Navigator 4.01 (1997)
USPS change to SSL tcpconnect (2007)
WebCat on Intel Core 2 macs anyone? (2007)
404 Error and Web * V (2003)
WebCatalog2 Feature Feedback (1996)
WebDNA on Red Hat Enterprise Linux 4 x64 (2006)
Comments in db? (1997)
WebCatalog.acgi quitting with error Type 2 (1998)