Re: Is this possible in simple search? question?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17244
interpreted = N
texte = At 7:31 AM -0800 4/24/98, Gary Richter is rumored to have typed: > I am trying to create a search and can't seem to figure out how to do this > or even is it is possible. > > I have a field that I call code. I will show you two records in that field > that contain part numbers. > > record 1, field code 1001 1002 1003 > record 2, feild code 1002 1010 1020 1021 > > The field is filled with part numbers that relate to another file. They > get there and have the spaces between each 4 digit part number, that part > is confirmed and used in other searches. The code field could have as few > as one part number to as many as eight. > > What I am trying to figure out is how to do a show me this but not that on > the code field. IE: Show me all the records where the code field contains > 1002, but don't show me the records that contain 1003. I have a series of > check boxes that display on a template twice. The first group is show me > which works loading the checkboxes with the wocodedata=. The second group > is don't show me loading a group of checkboxes with ( I tried both) > necodedatarq= or wncodedatarq=. But since it first finds 1002 it shows me > all of those but it does not honor my request to not show me the 1003. I > assume this is because the record 1, field code contains both 1002 and > 1003. > > I can count the characters out and do a series of hideif's if this is the > only way around this on the display search template, I think. I made this > field be exactly 4 digits long because I do a count characters elsewhere in > my site and break them out into groups of 4. But I was trying to do it the > simple way with the various search options in webcat. > > Suggestions on things I should try?If I understand correctly, this should work: [SEARCH db=/DATABASE.db&waCODEdatarq=1002&CODEword=ww&group1field=CODE&wnGROUP1datarq=10 03&GROUP1word=ww]You can search om a field more than once by putting it in a group by itself. In essense, you're tricking WebCat into thinking that it's searching two different fields when it's really searching the same field twice.MichaelMichael Winston *By e-mail!: michaelw@dhorse.com Internet Coordinator *By web!: http://www.dhorse.com/ Dark Horse Comics, Inc. *By fax!: 503/654/9440
Associated Messages, from the most recent to the oldest:
At 7:31 AM -0800 4/24/98, Gary Richter is rumored to have typed: > I am trying to create a search and can't seem to figure out how to do this > or even is it is possible. > > I have a field that I call code. I will show you two records in that field > that contain part numbers. > > record 1, field code 1001 1002 1003 > record 2, feild code 1002 1010 1020 1021 > > The field is filled with part numbers that relate to another file. They > get there and have the spaces between each 4 digit part number, that part > is confirmed and used in other searches. The code field could have as few > as one part number to as many as eight. > > What I am trying to figure out is how to do a show me this but not that on > the code field. IE: Show me all the records where the code field contains > 1002, but don't show me the records that contain 1003. I have a series of > check boxes that display on a template twice. The first group is show me > which works loading the checkboxes with the wocodedata=. The second group > is don't show me loading a group of checkboxes with ( I tried both) > necodedatarq= or wncodedatarq=. But since it first finds 1002 it shows me > all of those but it does not honor my request to not show me the 1003. I > assume this is because the record 1, field code contains both 1002 and > 1003. > > I can count the characters out and do a series of hideif's if this is the > only way around this on the display search template, I think. I made this > field be exactly 4 digits long because I do a count characters elsewhere in > my site and break them out into groups of 4. But I was trying to do it the > simple way with the various search options in webcat. > > Suggestions on things I should try?If I understand correctly, this should work: [SEARCH db=/DATABASE.db&waCODEdatarq=1002&CODEword=ww&group1field=CODE&wnGROUP1datarq=10 03&GROUP1word=ww]You can search om a field more than once by putting it in a group by itself. In essense, you're tricking WebCat into thinking that it's searching two different fields when it's really searching the same field twice.MichaelMichael Winston *By e-mail!: michaelw@dhorse.com Internet Coordinator *By web!: http://www.dhorse.com/ Dark Horse Comics, Inc. *By fax!: 503/654/9440
Michael Winston
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:
Problem 2 of 2 (was: Shipping Confusion) (2000)
WebCatalog can't find database (1997)
printing twice? and fix (1997)
Configuring E-mail (1997)
Help! WebCat2 bug (1997)
RAM variables (1997)
how do I delete 1 of 2 identical records? (2003)
Databases going to sleep (1998)
Not really WebCat (1997)
WebTen and WebCat (1997)
Summing fields (1997)
Limiting user access to .tmpl files (1997)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
WebCatb15 Mac CGI -- [purchase] (1997)
PCS Emailer's role ? (1997)
Different Email recipients? (1998)
Triggers (1999)
DrWatson Error! (1999)
why do I get authorization requests, even though (1999)
Mac Vs WindowsNT (1997)