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:
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)