I have to parse the vin number so I can pull make,model,body style and year. I think I can do this fairly quickly. I'm writing a power search utility using Google's mapping for the front end, then I'll let the investigators pick a radius for the search. Here's an example of how this will work - last fall we had some sex pervert trying to abduct kids from an elementary school. The officers got a vehicle description for make, model and year. If we had had this tool we would have been able to plug those parameters in and pull all matches within a selected radius, then check for matches in the sex offender database. The first priority though, is to get the garbage out of the mvr table.
JH -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Russell Sent: Friday, April 25, 2008 3:20 PM To: ProFox Email List Subject: Re: VIN Decoder On Fri, Apr 25, 2008 at 2:40 PM, John Harvey <[EMAIL PROTECTED]> wrote: > Yeah, I found a bunch of links too. Problem is, our local county clerk > isn't > doing the job and the MVR table is crap. Ford is Frd, Ford, For, etc. > > I've got 1.5 million records to unscrew. > ----------------------------------------------------------------- So you just need to get mfg straight or do you need make / model and have them consistent to a Dropdown list level? -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@shelbynet.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
