Re: 3 fields must match
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55655
interpreted = N
texte = Ahh, that did it... I wasn't aware you could 'daisy-chain' search criteria like that (eqWHATEVER1datarq=123&eqWHATEVER2datarq=456eqWHATEVER3datarq=7890), which now, in hindsight, seems kinda dopey of me ;) Thanks, Gary. -Dan On Fri, 23 Jan 2004 15:42:50 -0600 Gary Krockover
wrote: >Something like? > >[!] >phone.db >idphone_aphone_bphone_c >record17024532345 >record22083455433 >record32124359999 >[/!] >[text show=f]phonenumber=7024532345[/text] >[text show=f]phonea=[getchars start=1&end=3][phonenumber][/getchars][/text] >[text show=f]phoneb=[getchars start=4&end=6][phonenumber][/getchars][/text] >[text show=f]phonec=[getchars start=7&end=10][phonenumber][/getchars][/text] > >[search db=phone.db&eqphone_adatarq=[phonea]&eqphone_bdatarq=[phoneb]&eqphone_cdatarq=[phonec]] >FOUND: [numfound] >[founditems] >Your phone number is: ([phone_a]) [phone_b]-[phone_c] >[/founditems] >[/search] > >GK > >At 03:30 PM 1/23/2004, you wrote: >>Saw a bit of discussion in the archives on this, but couldn't reproduce success with what I >>found... >> >>my.db has 4 relevant fields: >>---------------------- >>idphone_aphone_bphone_c >>record17024532345 >>record22083455433 >>record32124359999 >>etc. >>---------------------- >> >>How do I return record if ALL 3 fields match? Input is straight 10 digit for now (i.e. >>7024532345), but assume that I'll [grep] or [getchars] or whatever to make this work...that isn't >>the issue. >> >>I know I can just add another field to the .db and combine the other 3 fields (and that's >>probably what I'm going to do...), but I'd like to know how to make it work as is before I give >>up and just add the xtra field. >> >>Thanks, >> >>-Dan > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------ http://www.StrongGraphicDesign.com http://www.SearchBoise.com ------------------------------------------------------------ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Ahh, that did it... I wasn't aware you could 'daisy-chain' search criteria like that (eqWHATEVER1datarq=123&eqWHATEVER2datarq=456eqWHATEVER3datarq=7890), which now, in hindsight, seems kinda dopey of me ;) Thanks, Gary. -Dan On Fri, 23 Jan 2004 15:42:50 -0600 Gary Krockover wrote: >Something like? > >[!] >phone.db >idphone_aphone_bphone_c >record17024532345 >record22083455433 >record32124359999 >[/!] >[text show=f]phonenumber=7024532345[/text] >[text show=f]phonea=[getchars start=1&end=3][phonenumber][/getchars][/text] >[text show=f]phoneb=[getchars start=4&end=6][phonenumber][/getchars][/text] >[text show=f]phonec=[getchars start=7&end=10][phonenumber][/getchars][/text] > >[search db=phone.db&eqphone_adatarq=[phonea]&eqphone_bdatarq=[phoneb]&eqphone_cdatarq=[phonec]] >FOUND: [numfound] >[founditems] >Your phone number is: ([phone_a]) [phone_b]-[phone_c] >[/founditems] >[/search] > >GK > >At 03:30 PM 1/23/2004, you wrote: >>Saw a bit of discussion in the archives on this, but couldn't reproduce success with what I >>found... >> >>my.db has 4 relevant fields: >>---------------------- >>idphone_aphone_bphone_c >>record17024532345 >>record22083455433 >>record32124359999 >>etc. >>---------------------- >> >>How do I return record if ALL 3 fields match? Input is straight 10 digit for now (i.e. >>7024532345), but assume that I'll [grep] or [getchars] or whatever to make this work...that isn't >>the issue. >> >>I know I can just add another field to the .db and combine the other 3 fields (and that's >>probably what I'm going to do...), but I'd like to know how to make it work as is before I give >>up and just add the xtra field. >> >>Thanks, >> >>-Dan > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------ http://www.StrongGraphicDesign.com http://www.SearchBoise.com ------------------------------------------------------------ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"Dan Strong"
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:
Bad Cookie / Internet Option / Internet Explorer (2004)
Three new problems, maybe a fourth (1997)
Blog solution (2006)
Wanted: Broader string manipulation functions (1997)
DON'T use old cart file! (1997)
Plugin or CGI or both (1997)
Authenticate (1997)
Is there an easier way? (1998)
Here we go again...WebDNA - SQL- Clustering (2006)
Webcatalog/NT dbserver crashing. (2000)
looking for developers with solutions (2000)
Append is limiting the Number of Characters written to db (fwd) (1998)
Join us at MacWorld! (1998)
WebCat2b13MacPlugIn - [include] (1997)
Trouble with Category search (2000)
Webstar Search and WebDNA (2000)
Problem with pull down menu (1998)
PhotoMill -> PhotoMaster (1997)
Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)
Another Flash Question (2000)