OK, just wanted to make sure this wasn't anything to do with audio. Well, not really.

OK, so I'm working on compiling a database of all my CD's, something that will be a flat file. That part is done. Disc name, artist, year, track titles, notes and genre, all neatly done. Thanks to Gracenote for having nearly ALL of my stuff there. Over 300 discs. Please keep in mind I'm NOT a DJ.

I get at least 10 calls a week asking "Hey, do you have this song..." Mainly, they want to burn copies of songs I have for their purposes, which I refuse. On occasion, I get requests for songs to be played at events.

So, to cut down on the phone calls, I created the database in Excel and have converted that to a tab-delimited file.

I found a CGI, but it sucks. It wants to index the web site, which is clearly something that doesn't need to be done, but it has to index the web site to create files I don't need that won't be used after the fact anyways. Unfortunately, it has results in the format I desired.

So, let's say someone puts in for their search, let's say someone popular, such as Eminem. If they put in Eminem into the search, it brings back all records with Eminem in the record. Let's say they put in "party", it would return all records with party in them. It would return the entire record listing.

I don't want to deal with anything other than Perl scripts and don't want to deal with a buttload of poorly documented external CGI's to make it work. I don't mind having to configure it, that's fine, I virtually host 7 domains on my server anyways so everything requires tweaking anyways. Free would be good too, as the commercial or pay stuff tends to be more unstable and buggy than the free stuff anyways.

Anyone have any pointers? CGI Resource sucks for this one, and Rilax and RiSearch blow chunks(that's what I was trying). Any other suggestions? Google, Yahoo and AltaVista with their pointers to other CGI collection sites are not helping either. I don't want to manipulate a database, I have already created the database. I just want to query it and return results. If I add to the master database, it will be re-uploaded to the site.

That enough off-topic as far as audio and lighting?

Thanks in advance.

Have you done any coding in PHP? I've done a couple things in it, mostly just 'tweaking' other people's code. I'll take a look into parsing a tab-delimeted file. Any chance of turning into a comma-delimeted?
Most scripts, though, want to work with a MySQL backend. Any chance of dumping your data into that? It would make your life a lot easier. Unless of course you're not running MySQL (like me) on your server.

--EDIT--
Check this link: http://px.sklar.com/code.html?id=907
It's a PHP script that can parse CSV file.

Nope, no coding in PHP, but it is installed on my Linux server. I'd much prefer to run a Perl script rather than PHP.

Convering the file to a comma-delimited is not an option since some titles have commas in them. Tab is fine, but to suposedly work with the stupid CGI I was working on, I converted tab to "::". Only takes 10 seconds for 7K+ records, so no big deal.

Not running any sorf of SQL, especially not MS-SQL. I don't really have great need for databases being online. I also like being able to quickly gather information my way, process it and dump it to where I need it.

The code you directed me to looks like I can easily take my tab-delimited file that is now "::" delimted and convert the script to use "::" as the sepparator.

I've bookmarked it. Not sure if I'll use it though. Thanks. Maybe that site has something else that might be more useful. Definately worth checking out.

I know of a javascript one that would work....only problem is i think you would have to manually entere every song

Ugh, not Javascript. That would require visitors to downgrade their security levels. I'm somewhat opposed to imposing requirements upon visitors outside of "hey, pick a browser, the rest is going to work". I'll be adding an international font and a few pages will require that, but outside that "necessary evil", no plug-ins required.

Ugh, manually have to enter it, eh? Hmm, maybe manually enter one, then edit the file to include the rest. That would be fairly simple, assuming it does the whole thing in clear text.

Point me at it and let me see. It can't hurt. It's not like this search function is live yet or anything. I'm using the down time to write my CD playing policy (No CDR's, pretty much). My clients tend to be rather less than ethical and respectful of copyright. Gotta support the working artists!

PHP, SQL??? yea, u guys go megabyte those gigabytes or w/e

Chris, click on the blue box for an example.
If this link is taken down i'll e-mail it to you.

http://javaboutique.internet.com/CatalogView/

I've bookmarked it and will check it later as time permits.

I had one heck of a weekend. I assembled 5 SCSI devices into what is supposed to be a 4-space external chassis. Hey, why let that unused bottom space get lost? Anyhow, stuffed my 2 ProTools drives in there on one SCSI bus, and then a DVD, 24X CD and a ZIP into the top 3 slots on a second SCSI bus. I still have wattage left on the power supply for the chassis so I don't have any power related issues to deal with.

I still have my BDC down and out. I need a new power supply but hard to find AT power supplies. So, I've given up on that and now need to find a logic board and CPU, and then move parts around. Ugh, what a freakin' mess!

My web server almost fried. I found first the power supply fan was out, then when I cracked the case open, the CPU fan was not working as well. Had to steal a CPU fan from another computer and rig a 3-pin fan into the power supply which is getting its power from a chassis fan connector on the main board. Lots of little mods everywhere. Scary thing is I have no idea how long those fans had been non-functional. That's why I strongly recommend frequent thorough inspections of all machines. Need to replace that CPU fan and get that machine back into production.

Back to that applet:
My only concern is the limitation of 10,000 records, as I'm already up to 7200+ right now. I'm in the middle of a project of transfering 12 cassettes that are not available on CD into ProTools so I can then do some noise removal and burn to CD's. Might have a few extra CD's that pop up that I might need to do as well. Plus, I have about 10-15 other CD's I haven't catalogged yet, plus 4 new CD's coming in any day now.

I guess I could split up the database into "category" databases, but I'm sure that will cause problems as people don't agree with the category I have assigned.

Time to get back to work! Thanks for the assistance there.

If it helps any I once put 8 fans in a system.

It was a few years ago at my job, but I think we had like 3 15,000 rpm drives in there with a damaged heat sink on the processor. It actually worked for a while untill we just replaced that system all together

My main/gaming computer has plenty of fans in it.

2 front case fans, 2 rear case fans, 1 PSU Fan, 1 CPU Fan, another fan/ducting system to help pass cool air over the cards. 7 fans should do it.

At some point I'm going to upgrade to a P4 system, so I'll end up with a new video card with a fan on it I'm sure.