yeah what if you had a table where it had a color on the left and a number on the right.
silver, grey, metalic, shiny, etc could be ID 1 red, pink, magenta, orange could be ID 2 you could do it that way or another way which might be kinda crazy would be if you had all the primary, secondary and maybe tertiary colors in your database and the frequency of light that they are, when you want to find a close match for a given color you could search for color matches that were within so many frequencies of the color given. might be able to combine the two... this kinda sounds too like something fuzzy logic would be good for cause fuzzy logic is good at summing up close matches and finding the most probable match and all that...i dont know much about it but you might be able to find some info on google (: i guess it depends how much time and effort you want to put into a free service though :P ----- Original Message ----- From: "parts" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, July 08, 2003 1:49 PM Subject: [RBASE-L] - Re: Off topic- vehicle ID > Try writing a look up table where if it's gray try silver.etc > ----- Original Message ----- > From: "Bill Downall" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > Sent: Tuesday, July 08, 2003 4:36 PM > Subject: [RBASE-L] - Re: Off topic- vehicle ID > > > > I don't know about matching gray with silver, or even 5's and s's, but one > > little-used feature of R:Base is its implementation of the SOUNDEX > > "sounds like" algorithm in WHERE conditions. > > > > in the concomp database, try > > > > SEL * FROM contacts WHERE contlname SOUNDS 'petersen' > > SEL * FROM contacts WHERE contlname SOUNDS 'balee' > > > > The algorith forces you to get the first consonant right, I think, but > then > > substitutes just about any vowel for vowel, and knows about lots of > > homophonic combinations, like K and C, or PH and F, and guesses on > > that basis. > > > > For the 5's and S's, you could conceivably fiddle with the colating tables > > (that affect sort order) in your cfg file. That could make ones sort like > ells, > > and zeros sort like ohs, and fives sort like esses. > > > > Bill > > > > > > On Tue, 08 Jul 2003 16:25:26 -0400, Dennis Fleming wrote: > > > > >I think this is a Father of RBase question, but I'm not sure. I recall > that > > >Wayne built some s/w for the police but I don't remember what it did. In > > >our community here I offered (pro bono) to set up a vehicle ID system so > > >when folks misbehave and public safety gets a call with a partial vehicle > > >description, they can quickly match it up. The standard search is easy. > > >What I was wondering is if anyone knows of a similar color, number, > letter > > >search. Silver would also look for gray, 5's & S's, Ohs and zeros, etc. > > >I suspect there is even a similar make/model table out there somewhere. > > >
