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:
WebCat Documentation (was [platform] tag?) (1998)
Date search - yes or no (1997)
Exclamation point (1997)
2.1 pricing? (1998)
Searching multiple Databases (1997)
Problems getting parameters passed into email. (1997)
HELP WITH DATES (1997)
Secure Sever and showcart errors (1997)
[thisurl] or another way (2000)
Emailer port change (1997)
How do I get Google to crawl a WebCat site? (2003)
I need Typhoon Pro Tonight! (1999)
search for all (1998)
keep W* in front applescript? (1998)
Testing the WebCat Email List Members (2000)
Download Question (1997)
Occasional crashes with $remove (1997)
Webcatalog error, Plug-in for Webstar (1996)
IOD | WAS:[Show items based on login Password] (2003)
Pull Down Search (2000)