Re: Search syntax question

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 20794
interpreted = N
texte = You can't search the same field of a database in more than one way in the same search (in each example. it looks like you're trying to search the hiseq field several different ways).The solution is to use groups:group1field=hiseq&group2field=hiseq&bwgroup1data=250&rngroup2data=280+286...etc.Each group contains the same field, but WebCat is capable of searching each group as a separate entity.-Dave At 11:01 AM 11/2/98, Gil Poulsen wrote: >Question: These searches are not working, and seem to be acting as if they are >and type searches rather than or type, yet none of the fields have rq >aoppended to them. However, they all return 0 results. Am I doing something >wrong in the coding here? > >VALUE=category.hi.tmpl$search?bwhiseqdata=250&rnhiseqdata=280+286&hiseqtype=nu >m&db=../scholars.db&startAt=1&max=25&cart=[cart]>Asia >& Africa > >VALUE=category.hi.tmpl$search?bwhiseqdata=220&rnhiseqdata=225+227&rnhiseqdata= >232+242&bwhiseqdata=275&hiseqtype=num&db=../scholars.db&startAt=1&max=25&cart=[c >art]>Modern History > >VALUE=category.hi.tmpl$search?eqhiseqdata=216&eqhiseqdata=231&hiseqtype=num&db >=../scholars.db&startAt=1&max=25&cart=[cart]>Jewish >History/The Holocaust > >-- >Gil Poulsen, Webmaster > >************************************************************** >* AltiM@c * Phone: (908) 222-9001 * >* 111 Mali Drive * FAX: (908) 222-9002 * >* North Plainfield, NJ * e-mail: help@altimac.com * >* 07062-2355 * WWW: http://www.altimac.com * >************************************************************** o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+ Associated Messages, from the most recent to the oldest:

    
  1. Re: Search syntax question (Gil Poulsen 1998)
  2. Re: Search syntax question (Dave MacLeay 1998)
  3. Search syntax question (Gil Poulsen 1998)
You can't search the same field of a database in more than one way in the same search (in each example. it looks like you're trying to search the hiseq field several different ways).The solution is to use groups:group1field=hiseq&group2field=hiseq&bwgroup1data=250&rngroup2data=280+286...etc.Each group contains the same field, but WebCat is capable of searching each group as a separate entity.-Dave At 11:01 AM 11/2/98, Gil Poulsen wrote: >Question: These searches are not working, and seem to be acting as if they are >and type searches rather than or type, yet none of the fields have rq >aoppended to them. However, they all return 0 results. Am I doing something >wrong in the coding here? > >VALUE=category.hi.tmpl$search?bwhiseqdata=250&rnhiseqdata=280+286&hiseqtype=nu >m&db=../scholars.db&startAt=1&max=25&cart=[cart]>Asia >& Africa > >VALUE=category.hi.tmpl$search?bwhiseqdata=220&rnhiseqdata=225+227&rnhiseqdata= >232+242&bwhiseqdata=275&hiseqtype=num&db=../scholars.db&startAt=1&max=25&cart=[c >art]>Modern History > >VALUE=category.hi.tmpl$search?eqhiseqdata=216&eqhiseqdata=231&hiseqtype=num&db >=../scholars.db&startAt=1&max=25&cart=[cart]>Jewish >History/The Holocaust > >-- >Gil Poulsen, Webmaster > >************************************************************** >* AltiM@c * Phone: (908) 222-9001 * >* 111 Mali Drive * FAX: (908) 222-9002 * >* North Plainfield, NJ * e-mail: help@altimac.com * >* 07062-2355 * WWW: http://www.altimac.com * >************************************************************** o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+ Dave MacLeay

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:

I'm tired of all this! (2000) executive server side java within webDNA (1997) trouble updating records in database (1998) Shared conversion under WebTen (1998) RE: Can a database get stomped by simultaneous access? (1997) shipcost (1997) CAPTCHA system in webDNA (2005) [WebDNA] TLS 1.2 and [tcpconnect] (2018) Customizing WebDelivery.html (1998) Re1000001: Setting up shop (1997) Nesting [RAW] (1998) Web Catalog 2 demo (1997) syntax question, not in online refernce (1997) Big Databases (1997) Possible solution to malformed pages in NN (2000) Mac: [ListFiles] bug alert (1997) Re:What file? (1997) Frames and WebCat (1997) PLEASE REMOVE MY EMAIL ADDRESS (1997) Public beta 3 of WebCatalog 4.0 is now available (2000)