Re: 3 fields must match

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55654
interpreted = N
texte = 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: 3 fields must match ( "Dan Strong" 2004)
  2. Re: 3 fields must match ( "Dan Strong" 2004)
  3. Re: 3 fields must match ( Gary Krockover 2004)
  4. 3 fields must match ( "Dan Strong" 2004)
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/ Gary Krockover

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 with update to 2.11 (1998) Spawning Holdup? (2000) RE: protect tag not working (1998) Round up prices (2000) ShowNext Questions (2000) [regexp] will be renamed to [grep] in next release (2000) Cumulative Shipping charge calculations - your help please. (1997) PCS Frames-Default page is solution! (1997) append=T problem (1998) Future of WebDNA (was urls) (2005) [WriteFile] problems (1997) Re(2): typhoon ? (2003) [WC 2.1.30] Stack overflow. (2000) Use of Back and Reload Buttons on ShoppingCart page? (1997) Bug Report, maybe (1997) Emailer kaput? (2000) F*** you (1998) [WebDNA] OT: what is the "right" platform ? (2009) credit card authorization question (1997) [math] show=F exists? (1997)