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:[SEARCHdb=/DATABASE.db&waCODEdatarq=1002&CODEword=ww&group1field=CODE&wnGROUP1datarq=1003&GROUP1word=ww]You can search om a field more than once by putting it in a group byitself. In essense, you're tricking WebCat into thinking that it'ssearching two different fields when it's really searching the same fieldtwice.MichaelMichael Winston *By e-mail!: michaelw@dhorse.comInternet 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:[SEARCHdb=/DATABASE.db&waCODEdatarq=1002&CODEword=ww&group1field=CODE&wnGROUP1datarq=1003&GROUP1word=ww]You can search om a field more than once by putting it in a group byitself. In essense, you're tricking WebCat into thinking that it'ssearching two different fields when it's really searching the same fieldtwice.MichaelMichael Winston *By e-mail!: michaelw@dhorse.comInternet 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:
Help name our technology! I found it (1997)
OT: Urgent help with Windows and Javascript (2003)
orders being printed (1998)
[OT] Happy Turkey Day! (2003)
Webmerchant -> MacAuthorize ... please retry ? (1997)
File Upload (1997)
Password Generator (2004)
Almost a there but..bye bye NetCloak (1997)
Re:quit command on NT (1997)
includes (2003)
[delete] problem (1997)
vcode (2003)
[WebDNA] possible bug? (db field named [width]) (2012)
Next X hits (1996)
Help name our technology! I found it (1997)
You *can!!* overwrite username/password using an HTML form. Also, experts *please* see Q at end (2000)
WebCat and PIXO (2000)
PSC recommends what date format yr 2000??? (1997)
Timeout question .. (2003)
Use of Back and Reload Buttons on ShoppingCart page? (1997)