searching twice on same field

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 15901
interpreted = N
texte = My search template is set up to allow a search on two fields. This works well as long as the two fields are different. However, if the same field is entered both times, the search comes up with 0 itemsThe search string passed to web catalog through the form looks like this:SearchField=Writeup&SearchAction=ws&SearchCriteria=vitamin+bible&SearchLogic=&SearchField2=Writeup&SearchAction2=wo&searchCriteria2=vitamin+hair+prostate&cart=29666141900&searchMax=3&startat=1As you can see, on the one hand I'm looking for a string, on the other any of the words will do.On the results page it is formatted as a context search as following:[search db=aliveBooksv1.db&max=[searchMax]&cart=[cart]&[SearchAction][SearchField]data[SearchLogic]=[SearchCriteria]&[SearchAction2][SearchField2]data[SearchLogic]=[SearchCriteria2]&startat=[startat]]So this particular search doesn't work. Is groupfield the only way to accomplish this? If so, what is the appropriate WebDNA command to grab the text either before it is sent from the form, or before it is processed by the context on the receiving template, in order that it might be massaged into the appropriate form?Chris Gursche EC&T Electronic Colour & Type Corp Associated Messages, from the most recent to the oldest:

    
  1. Re: searching twice on same field (Grant Hulbert 1998)
  2. searching twice on same field (Chris Gursche 1998)
My search template is set up to allow a search on two fields. This works well as long as the two fields are different. However, if the same field is entered both times, the search comes up with 0 itemsThe search string passed to web catalog through the form looks like this:SearchField=Writeup&SearchAction=ws&SearchCriteria=vitamin+bible&SearchLogic=&SearchField2=Writeup&SearchAction2=wo&searchCriteria2=vitamin+hair+prostate&cart=29666141900&searchMax=3&startat=1As you can see, on the one hand I'm looking for a string, on the other any of the words will do.On the results page it is formatted as a context search as following:[search db=aliveBooksv1.db&max=[searchMax]&cart=[cart]&[SearchAction][SearchField]data[SearchLogic]=[SearchCriteria]&[SearchAction2][SearchField2]data[SearchLogic]=[SearchCriteria2]&startat=[startat]]So this particular search doesn't work. Is groupfield the only way to accomplish this? If so, what is the appropriate WebDNA command to grab the text either before it is sent from the form, or before it is processed by the context on the receiving template, in order that it might be massaged into the appropriate form?Chris Gursche EC&T Electronic Colour & Type Corp Chris Gursche

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:

WC Database Format (1997) Search Question (2003) PC Authorize & Webmerchant (1998) FTP and [shell] (2003) [redirect] w/o showing args? (1999) [WebDNA] Triggers issue, or sendmail? (2012) I am dumb. No see [variable] (2003) (1997) Sorting when searching with grouped fields (2002) Speed Admin? (Was FlushDatabases) (1997) Text data with spaces in them... (1997) PROTECT PAGES (2002) Triggers and today's leap day? (2000) Multiple catalog databases and showcart (1997) Three new problems, maybe a fourth (1997) DDE feature in webcat (1998) Template transformed itself into a database? (1998) SERIAL NUMBER PROBLEM *AGAIN*!!! (1998) Databases inside [SHOWIF] (1998) Generating Report Totals (1997)