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 inBOOKS, 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 undercategory, 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 OfLi YangSent: Thursday, April 10, 2003 1:58 PMTo: WebDNA TalkSubject: Search and list the titles of bookI 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. Intest.db has many other products as vedio, movie, pen, ... which theirCATEGORY 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:
If books isn't empty under CATEGORY, and it is the same for each, as inBOOKS, 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 undercategory, 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 OfLi YangSent: Thursday, April 10, 2003 1:58 PMTo: WebDNA TalkSubject: Search and list the titles of bookI 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. Intest.db has many other products as vedio, movie, pen, ... which theirCATEGORY 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)