Re: [WebDNA] Help with a search

This WebDNA talk-list message is from

2018


It keeps the original formatting.
numero = 114333
interpreted = N
texte = 1949 --Apple-Mail=_9F8920DF-AC6A-4259-A141-7B314979553E Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Francisco, You're not very clear on what you're trying to accomplish. Clearly, = &field2!RV is not correct syntax. Check the docs at: = http://www.webdna.us/iframe-html4.html?numero=3D69&searchword=3D&n=3Dt#bac= kground14 = Mike > On Jun 26, 2018, at 4:33 PM, Francisco Hirsch = wrote: >=20 > Several years ago I did a simple search program in a database and = outputted a list (in WebDNA 6.2). > I have since forgotten a lot of searching in WebDNA. I would = appreciate help. > The search term goes something like this: > [Search db=3Dbases/thedatabase.txt&grfield1datarq=3D0&etc] > The database has a text field2 that has several possible values, among = them DV and RV. > I have been asked to modify the search so as to exclude results that = include field2 with those values. > I guess that means I should include terms &field2!RV&field2!DV in the = search term. > But it's not working, so I suppose that I must add prefix and suffix = to field2.=20 > I have not found in the 6.2 Manual how to doit > Regards, > Francisco > -- > Lic. Francisco Hirsch > http://fiscaldemesa.com.ar >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: = support@webdna.us --Apple-Mail=_9F8920DF-AC6A-4259-A141-7B314979553E Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Francisco,

You're not very clear on what you're trying to accomplish. =  Clearly, &field2!RV is not correct syntax.  Check = the docs at:

http://www.webdna.us/iframe-html4.html?numero=3D69&searchwo= rd=3D&n=3Dt#background14


Mike



On Jun 26, 2018, at 4:33 PM, Francisco Hirsch = <listas.hirsch@gmail.com> wrote:

Several years ago I = did a simple search program in a database and outputted a list (in = WebDNA 6.2).
I have since forgotten a lot of searching in = WebDNA. I would appreciate help.
The search term = goes something like this:
[Search = db=3Dbases/thedatabase.txt&grfield1datarq=3D0&etc]
The database has a text field2 that has several possible = values, among them DV and RV.
I have been asked to = modify the search so as to exclude results that include field2 with = those values.
I guess that means I should include = terms &field2!RV&field2!DV in the search term.
But it's not working, so I suppose that I must add prefix and = suffix to field2. 
I have not found in the 6.2 = Manual how to doit
Regards,
Francisco
--
Lic. Francisco Hirsch
http://fiscaldemesa.com.ar

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --Apple-Mail=_9F8920DF-AC6A-4259-A141-7B314979553E-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Help with a search (Francisco Hirsch 2018)
  2. Re: [WebDNA] Help with a search (Francisco Hirsch 2018)
  3. Re: [WebDNA] Help with a search (Michael Davis 2018)
  4. [WebDNA] Help with a search (Francisco Hirsch 2018)
1949 --Apple-Mail=_9F8920DF-AC6A-4259-A141-7B314979553E Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Francisco, You're not very clear on what you're trying to accomplish. Clearly, = &field2!RV is not correct syntax. Check the docs at: = http://www.webdna.us/iframe-html4.html?numero=3D69&searchword=3D&n=3Dt#bac= kground14 = Mike > On Jun 26, 2018, at 4:33 PM, Francisco Hirsch = wrote: >=20 > Several years ago I did a simple search program in a database and = outputted a list (in WebDNA 6.2). > I have since forgotten a lot of searching in WebDNA. I would = appreciate help. > The search term goes something like this: > [Search db=3Dbases/thedatabase.txt&grfield1datarq=3D0&etc] > The database has a text field2 that has several possible values, among = them DV and RV. > I have been asked to modify the search so as to exclude results that = include field2 with those values. > I guess that means I should include terms &field2!RV&field2!DV in the = search term. > But it's not working, so I suppose that I must add prefix and suffix = to field2.=20 > I have not found in the 6.2 Manual how to doit > Regards, > Francisco > -- > Lic. Francisco Hirsch > http://fiscaldemesa.com.ar >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: = support@webdna.us --Apple-Mail=_9F8920DF-AC6A-4259-A141-7B314979553E Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Francisco,

You're not very clear on what you're trying to accomplish. =  Clearly, &field2!RV is not correct syntax.  Check = the docs at:

http://www.webdna.us/iframe-html4.html?numero=3D69&searchwo= rd=3D&n=3Dt#background14


Mike



On Jun 26, 2018, at 4:33 PM, Francisco Hirsch = <listas.hirsch@gmail.com> wrote:

Several years ago I = did a simple search program in a database and outputted a list (in = WebDNA 6.2).
I have since forgotten a lot of searching in = WebDNA. I would appreciate help.
The search term = goes something like this:
[Search = db=3Dbases/thedatabase.txt&grfield1datarq=3D0&etc]
The database has a text field2 that has several possible = values, among them DV and RV.
I have been asked to = modify the search so as to exclude results that include field2 with = those values.
I guess that means I should include = terms &field2!RV&field2!DV in the search term.
But it's not working, so I suppose that I must add prefix and = suffix to field2. 
I have not found in the 6.2 = Manual how to doit
Regards,
Francisco
--
Lic. Francisco Hirsch
http://fiscaldemesa.com.ar

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --Apple-Mail=_9F8920DF-AC6A-4259-A141-7B314979553E-- . Michael Davis

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:

WebCat2 Append problem (B14Macacgi) (1997) Forms Search Questions (1997) Error Lob.db records error message not name (1997) WebTrends (2002) Emailer (1997) Where's Cart Created ? (1997) Paths (1998) [WebDNA] 10.5 apache handler extension issue (2008) Email template names (1997) Dumb Question about Docs (1997) Email within tmpl ? (1997) Grouping search fields, etc. (1997) Great product and great job ! (1997) filemaker - orderfile (1997) Running a store on BOTH http and https (1998) Authorize.net questions ... (2003) Webmerchant (2000) [url] (1997) ShowIf helper? (1998) [isfile] ? (1997)