The search engine basically works. As of right now, it only finds items. If you try and search for a price or UPC or something, I can guarantee it'll fail. Search for text, and you can search for multiple items by separaing them with a space, and the list that pops up will list all the items in the order you typed them. Booleans don't work, so don't try :)

Watching increasing prices is kinda fun...search for "fac", you see multiple purchases of the same item, going up in increments of a couple cents over the past couple years. I'm gonna go play some more!

OH -- a couple things:
--please let me know if there's any other info you'd like reported. There's the capacity to include pretty much every bit of info off every receipt.

--other searches, like by date, UPC code, price, etc., are forthcoming. All I need to do is reprogram the search script to look at different fields, so *crossing fingers* they should be along soon. They'll also be clickable - do a search for "soil", get the results, click on a UPC code, ZOOM, you get a new search of all purchases of that one UPC. Very handy, huh?

--since UPC info (and other info) is incomplete in the database, I intend to write another script to make adding new receipts easy, and to clean up existing receipts. Since it's a lot of access to a complex database, I'll be password protecting that script, but I intend to let Aunt Beru and anyone else interested to have access, because I haven't got the time to do everything all by myself (which is why there wasn't a search function to begin with - I had originally intended on having one).

--as always, report bugs, etc., and if they aren't "features", I'll fix them. There are even limitations to my extreme powers, but I'll try to acoomodate as best I can.

• RE: Receipt search Engine - Dally-ance (0)
• RE: Receipt search Engine - Derek D Sysop (0)
• RE: Receipt search Engine - Derek the Almighty 09/19/2000 19:07:08 MDT (1)