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.dbid
phone_aphone_bphone_crecord17024532345record22083455433record32124359999[/!][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]GKAt 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:
Something like?[!]phone.dbidphone_aphone_bphone_crecord17024532345record22083455433record32124359999[/!][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]GKAt 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)