Re: Search Question
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 51383
interpreted = N
texte = Hm, well this is straight out of the docs and totally untested, but this might be it:[search db=cares.db&wnWHEELSdatarq=Packages]wn = word not equal to - this should exclude any records containing "Package", regardless of its position in the stringThis might narrow it down:[search db=cares.db&wnWHEELSdatarq=Packages&WHEELSword=sw]sw = start of word - this should only pick out records with "Package" at the beginning of the stringToo busy to test here, let us know how it works. :-)>Doh! Thanks Daryl,>>Perhaps I need to explain a little better.>>I need to look for wheels that don't have "Packages" in the name. We >have several types of wheel "models" that start with the work >"Packages", but the rest of the field has different words in it. The >root problem is a poorly constructed database, but it's what I have >to work with until I can re-organize it.>Is there a context for something like "Doesn't start with"?>>Tom>>>Would this not do it?>>>[search >>db=cars.db&eqMAKEdatarq=Honda&eqMODELdatarq=Accord&neYEARdatarq=2004]>>>------------------------------------------------------------->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/-- Daryl MitchellE-Business Specialist, PrintWest / PW Group Ltd.Saskatoon, SK CANADATel: (306) 665-3557Toll-free: (800) 291-9935Fax: (306) 653-1255E-Mail: d.mitchell@pwgroup.caWeb: http://www.pwgroup.ca/-------------------------------------------------------------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:
Hm, well this is straight out of the docs and totally untested, but this might be it:[search db=cares.db&wnWHEELSdatarq=Packages]wn = word not equal to - this should exclude any records containing "Package", regardless of its position in the stringThis might narrow it down:[search db=cares.db&wnWHEELSdatarq=Packages&WHEELSword=sw]sw = start of word - this should only pick out records with "Package" at the beginning of the stringToo busy to test here, let us know how it works. :-)>Doh! Thanks Daryl,>>Perhaps I need to explain a little better.>>I need to look for wheels that don't have "Packages" in the name. We >have several types of wheel "models" that start with the work >"Packages", but the rest of the field has different words in it. The >root problem is a poorly constructed database, but it's what I have >to work with until I can re-organize it.>Is there a context for something like "Doesn't start with"?>>Tom>>>Would this not do it?>>>[search >>db=cars.db&eqMAKEdatarq=Honda&eqMODELdatarq=Accord&neYEARdatarq=2004]>>>------------------------------------------------------------->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/-- Daryl MitchellE-Business Specialist, PrintWest / PW Group Ltd.Saskatoon, SK CANADATel: (306) 665-3557Toll-free: (800) 291-9935Fax: (306) 653-1255E-Mail: d.mitchell@pwgroup.caWeb: http://www.pwgroup.ca/-------------------------------------------------------------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/
Daryl Mitchell
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:
Denying access by IP address (2000)
Need relative path explanation (1997)
Smart caching problems with 2.1b3? (1997)
So when do we get something similar? (1998)
[Announce]: Web server security and password protection (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Central Reservation System? (2003)
DomainList (2005)
processing .html pages (2001)
How to best sort in a pre-defined item-by-item order ... (2003)
Not really WebCat- (1997)
Email SMTP Error 411 (2006)
merchant accts. (1997)
[shell]? (2000)
changing order number (1998)
PSC recommends what date format yr 2000??? (1997)
Allow-Deny: Solved with [Getchars] (1998)
[isfile] ? (1997)
Strange search... (2000)
WebDNA - fun to compare (2005)