Re: Search and list the titles of book

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 49409
interpreted = N
texte = If books isn't empty under CATEGORY, and it is the same for each, as in BOOKS, then just do this:[search db=test.db&eqcategorydatarq=BOOKS&etc.......(sorting)] [founditems] TITLE: [title] [/founditems] [/search]If BOOKS have several categories, and everything but books is empty under category, then just do:[search db=test.db&necategorydatarq=[blank]&etc....(sorting)] [founditems] TITLE: [title] [/founditems] [/search]GK-----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Li Yang Sent: Thursday, April 10, 2003 1:58 PM To: WebDNA Talk Subject: Search and list the titles of book I am trying to search from a test.db, which contence fields as SKU, TITLE, CATEGORY, AUTHOR, ... so on. I want to list all the Title of books only. In test.db has many other products as vedio, movie, pen, ... which their CATEGORY field is emtpy for those. So i need search if CATEGORY not empty, list all the books.thanks for all the help... ------------------------------------------------------------- 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: Search and list the titles of book (Li Yang 2003)
  2. Re: Search and list the titles of book (Dan Strong 2003)
  3. Re: Search and list the titles of book (Gary Krockover 2003)
  4. Search and list the titles of book (Li Yang 2003)
If books isn't empty under CATEGORY, and it is the same for each, as in BOOKS, then just do this:[search db=test.db&eqcategorydatarq=BOOKS&etc.......(sorting)] [founditems] TITLE: [title] [/founditems] [/search]If BOOKS have several categories, and everything but books is empty under category, then just do:[search db=test.db&necategorydatarq=[blank]&etc....(sorting)] [founditems] TITLE: [title] [/founditems] [/search]GK-----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Li Yang Sent: Thursday, April 10, 2003 1:58 PM To: WebDNA Talk Subject: Search and list the titles of book I am trying to search from a test.db, which contence fields as SKU, TITLE, CATEGORY, AUTHOR, ... so on. I want to list all the Title of books only. In test.db has many other products as vedio, movie, pen, ... which their CATEGORY field is emtpy for those. So i need search if CATEGORY not empty, list all the books.thanks for all the help... ------------------------------------------------------------- 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/ Gary Krockover

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 port change (1997) Search Context Strips URL chrs.? (1999) Problem about [CART] number (1998) Re: (1998) Re:[input] context (1999) different ship dates and shopping carts -- how to? (1997) Question about replacing words (1998) Security (1999) SiteGuard Admin Feature ? (1997) how does multiple [cart] commands work? (2007) frames & carts (1997) Multiple cart additions (1997) Need WebDNA that crashes server for testing (2000) Listfiles (2004) email [title] (1997) How big can WebCat go? (1999) [Search] on Remote Database (2000) AE aware WebCatalog.acgi? (1997) WebDNA tags in WebMerchant email templates ... (1997) WebCatb15 Mac CGI -- [purchase] (1997)