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:

WebCatalog Mac and cgi-bin (WebSTAR 2.0) (1997) Claris HomePage messes up the code (1997) Problems with dbcatalog.exe (1997) [Fwd: Rotating Banners ... (was LinkExchange)] (1997) Setting up shop (1997) Dates (1996) b18 problem on NT 4.0 (1997) WCS Newbie question (1997) Can [formvariables] do this? (2000) $Quit, $CloseDatabase corrections (1997) can WC render sites out? (1997) Small problem with searching (2002) about this server and links to who (1997) automating txt downloads for conversion to webcat db (2006) Converting SQL Microtime to Date and Time (2003) Country & Ship-to address & other fields ? (1997) Fulfillment e-mail? (1998) Fun with dates (1997) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) WC Database Format (1997)