In Reply to: Re: inmate search engine posted by Mart on February 21, 2002 at 01:28:01:
That's not how the data is stored. The search field has the entire record in one field with the array keys and values separated by colons with only a space between fields:Moniker: Mart System Name: brother Dan's 3 channel System Rev Date: 2001/08/21/10:10 System Rev IP: 155.218.112.2 Amp: Aragon : 8008×3 BDR : Mark IV cones Preamp: Marantz ......
Also, the keys don't match the labels on the form, eg Amp versus Amplifier. A Slow Message search for 'Speakers: Quad' might work but isn't that robust or realiable as if wouldn't work if the data was 'Speakers: Maggie 1.6, Quad'.
The actual system data is stored in a text file as this app was done before we implemented the db. Searching is supported via a patch to dump the data into a system table that is defined like a message search table. So doing this right requires rewriting the data pieces to use the db and rewriting the search routine to search sub-fields in a new table for systems.
This post is made possible by the generous support of people like you and our sponsors:
Follow Ups
- Re: inmate search engine - Rod M 05:58:10 02/21/02 (0)