Re: 3 fields must match
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55656
interpreted = N
texte = Just thought I'd share this because I thought it was cool/fascinating... the reason why I needed to know how to find the phonenumbers was because I have a client who insists that I make their clients login to the website (where their personal info is displayed upon log-in) USING ONLY THEIR PHONE NUMBER (!) I have told the client repeatedly that this is a bad idea, it's not very secure, and that it's easy to 'break into' the site and steal peoples' data... he keeps insisting that I do it anyway because that's what he wants, period. So, using Gary's fix for my brain-death, I wrote a quick script (on my dev-box of course) that generated 10000 random 10-digit numbers (to simulate phone numbers of course) and then hit a copy of my client's existing .db (5000+ records) and 'scored' 3 times. Consider that the randome 'phone numbers' created were largely 'nonsense' phone numbers (014-000-3546, etc.) -- imagine if I had tried actual phone numbers... Sure, 3 out of 10,000 is statistically inconsequential, but hey, that's 3 actual people's data, 3 potential cases of identity theftand 3 potential lawsuits... Client now sees it my way. :) -Dan ------------------------------------------------------------ http://www.StrongGraphicDesign.com http://www.SearchBoise.com ------------------------------------------------------------ On Fri, 23 Jan 2004 14:16:37 -0800 "Dan Strong"
wrote: >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/ ------------------------------------------------------------- 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:
Just thought I'd share this because I thought it was cool/fascinating... the reason why I needed to know how to find the phonenumbers was because I have a client who insists that I make their clients login to the website (where their personal info is displayed upon log-in) USING ONLY THEIR PHONE NUMBER (!) I have told the client repeatedly that this is a bad idea, it's not very secure, and that it's easy to 'break into' the site and steal peoples' data... he keeps insisting that I do it anyway because that's what he wants, period. So, using Gary's fix for my brain-death, I wrote a quick script (on my dev-box of course) that generated 10000 random 10-digit numbers (to simulate phone numbers of course) and then hit a copy of my client's existing .db (5000+ records) and 'scored' 3 times. Consider that the randome 'phone numbers' created were largely 'nonsense' phone numbers (014-000-3546, etc.) -- imagine if I had tried actual phone numbers... Sure, 3 out of 10,000 is statistically inconsequential, but hey, that's 3 actual people's data, 3 potential cases of identity theftand 3 potential lawsuits... Client now sees it my way. :) -Dan ------------------------------------------------------------ http://www.StrongGraphicDesign.com http://www.SearchBoise.com ------------------------------------------------------------ On Fri, 23 Jan 2004 14:16:37 -0800 "Dan Strong" wrote: >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/ ------------------------------------------------------------- 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:
Erotic Sites (1997)
Cookies and webcat (1997)
[WebDNA] Date weirdness (2014)
Emailer port change (1997)
Have no fear of WebCatalog Builder..... (2000)
New Command prefs ... (1997)
date pref (1999)
a small clarification (2002)
Location of Browser Info.txt file (1997)
Web Browser %Numbers - A must read for web developers (2003)
japanese characters (1997)
Searching,Brain Dead! (1999)
Make sure I understand this??? (1997)
textA (1998)
sorting question... (2001)
OT (stupid redirect/refresh question) (2002)
WebCat2: multiple currency support (1997)
Show Databases in admin (2000)
Limit on nested [ShowIf]'s? (1997)
WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997)