739 posts tagged with database.
Displaying 551 through 600 of 739. Subscribe:

MS Access: Wildcard Query run amok

MS Access Question: I have two tables in a db file. One has a large list of single cell records and the other, a smaller list of records to be compared against the larger table. The issue is that I would like to use the values in the smaller table as wildcards to return like matches that are like the records in the larger table. Example follows. [more inside]
posted by lampshade on Apr 27, 2007 - 3 answers

Software to track project/client information?

What kind of software can I use to keep track of information on each client and/or project that I'm working on? [more inside]
posted by iguanapolitico on Apr 24, 2007 - 7 answers

Is There a Federal Database of Prescription Drug Users?

ParanoiaFilter: Is there a federal database listing every prescription drug each person in the US has been prescribed or has purchased? ABC News seems to think so. [more inside]
posted by Pastabagel on Apr 19, 2007 - 11 answers

SQL query to get unique addresses from a list.

Access SQL Query - I have multiple individuals each with an address. I need to make mailing labels, but if two or more people share an address, I would only like one label. [more inside]
posted by odinsdream on Apr 18, 2007 - 9 answers

Suugestions for a simple web-based database program (like Microsoft Access)?

I am part of a committee whose members are spread across the country. We are looking for an open source or inexpensive database application that can be accessed on the web. We need for it to allow a few users to edit the data (membership information for our association) and for many users to be able to view the database without editing it. Basically we want Mircosoft Access but available on the web. [more inside]
posted by losdestinos on Apr 15, 2007 - 15 answers

HedgeFundFilter and Tass-database

Which hedge funds in or near NYC invest in life sciences and biotech? [more inside]
posted by yoyo_nyc on Apr 11, 2007 - 0 answers

Many domains, one database?

What would you say is the best way to have 10 domains access one database? [more inside]
posted by iguanapolitico on Apr 2, 2007 - 14 answers

Webpage to database for a nonprogrammer?

How can a nonprogrammer make a database from a set of search query results? [more inside]
posted by Mr. Gunn on Mar 29, 2007 - 14 answers

Missing Database

Help me find a missing database. [more inside]
posted by Jandasmo on Mar 26, 2007 - 2 answers

Where can I find business address list/databases for free

I need to populate a database of a Google Maps mashup with the names and addresses of restaurants in the U.S. and Canada. Where can I find this info in digital form? [more inside]
posted by dripdripdrop on Mar 9, 2007 - 4 answers

Can I Handle a PHP/MySQL site?

An 800 item database driven site in PHP and MySQL? Am I crazy? [more inside]
posted by mysterious1der on Mar 1, 2007 - 21 answers

Best software solution for a reading list database?

What is the best way to go as far as software for making a annotated reading list/database of books is concerned? Apart from the usual details, I'd like to add tags and short notes to each entry and would like to be able to work on the file off-line. Are there any existing software solutions for such a task out there or is my best option to go with MS Access/MySQL or a similar such program? I'm on the PC/Win XP platform and looking for inexpensive/shareware/freeware options Thanks!
posted by sk381 on Feb 18, 2007 - 3 answers

How to search pending lawsuits or court cases prior to completion?

How do you search for court cases or law suits that have not yet been completed? [more inside]
posted by wile e on Feb 13, 2007 - 10 answers

FileMaker me?

FilemakerFilter: I need some database help, because I am a n00b. My FIRST robotics team is creating a database of teams at our regional event, for scouting... [more inside]
posted by weaponsgradecarp on Feb 7, 2007 - 8 answers

How to easily search/replace in MySQL database?

Is there an easy, preferably open source way of editing MySQL table contents? I was hoping for something which would let me use Excel (or OO Calc) to edit the live database. I need to search/replace many items in a poorly imported database. [more inside]
posted by Yavsy on Feb 6, 2007 - 10 answers

PIM Database?

My boss wants me to gather 5,000 or so business contacts into a searchable database, which will then be used to create email distribution lists according to particular queries. Preferably Open Source, but proprietary is also OK. Any recommendations?
posted by limon on Feb 5, 2007 - 7 answers

My Kingdom for a DBA

Databasefilter: I'm a self-taught 'DBA' (I use quotes so as to not offend those who have this knowledge through a paid education). I'm having an efficiency problem with a few of my tables, and I thought maybe one or two of you could help. [more inside]
posted by thanotopsis on Jan 31, 2007 - 20 answers

Client Server Database

This is probably impossible but... Is there an open source client-server database that I can put on a shared Windows xp server without actually installing it? In other words simply copy up a bunch of files and have it work without going through a standard windows installation involving writing to the Registry etc... Actually i dont even care if its open source as long as it is small and relatively inexpensive. thanks in advance.
posted by rhcclark on Jan 30, 2007 - 13 answers

What database should I use?

Help me avoid Microsoft. I need a simple database programme, is there a good cheap alternative to MS Access out there? Can anyone recommend OOo base? [more inside]
posted by Touchstone on Jan 28, 2007 - 25 answers

Save me two weeks of manual labor, please

I have a data set of approximately 9,000 hip-hop tracks. It's in an Excel file. I have the song title, the artist, and the album. Now I just need the year. How can I find and automatically import the year into the Excel file without manually looking up every track on Google? Is there a way to do this with MusicBrainz or a similar database?
posted by schroedinger on Jan 26, 2007 - 9 answers

How do to update rows without a cursor?

How do I update rows in a table in a SQL*Server 2005 database with data from another row in the same table? [more inside]
posted by apark on Jan 24, 2007 - 5 answers

Formatted movie data availability?

I'm working on a site that requires a movie database. Help me find formatted data! [more inside]
posted by null terminated on Jan 10, 2007 - 11 answers

I don't wanna be a cutter!

Is there an easier way to combine CSV files? There is a bit [more inside]
posted by keep it tight on Jan 9, 2007 - 9 answers

Help w/ importing flatfiles!

Flat file importing best practices? tips? ideas? [more inside]
posted by apark on Jan 2, 2007 - 20 answers

No database for the average Joe

Librarian type question: how on earth can I get access to the National Security Archive database by Proquest? I am writing some articles on the Cold War on Wikipedia and want to see some of the documents in this collection, but Proquest/Chadwyck doesn't deal with individuals. They even offer free trials, which I can't get because I'm not an individual. Am I out of luck? [more inside]
posted by zek on Dec 28, 2006 - 8 answers

What's the best approach to building a lightweight database app?

I have been asked to write a database application that will be running in a storefront situation and will allow the user to enter data on what is sold (in this case, bicycles and bicycle accessories and parts) and generate basic bookkeeping reports (i.e. end-of-day sales, quarterly sales, that sort of thing.) [more inside]
posted by evisceratordeath on Dec 20, 2006 - 8 answers

Where do they get all those wonderful data?

WhereTheHellDoTheyGetAllThatData Filter: When someone wants to start a site that requires huge amounts of data like IMDB or Pandora or Last.FM, where do they get the data? [more inside]
posted by jxpx777 on Dec 18, 2006 - 18 answers

From Mail to Filemaker?

How can I automagically parse the oddly-formatted text from the body of an email so that Filemaker can use it? [more inside]
posted by bink on Dec 17, 2006 - 12 answers

Music, sweet music, I wish I could caress and kiss and find ...

Help me find industrial-strength software to catalog an extremely large CD collection. [more inside]
posted by jbickers on Dec 15, 2006 - 6 answers

Open source media contacts/relations database suggestions?

I'm looking for a free (or nearly) solution for storing an existing list of media contacts. [more inside]
posted by Pacrand on Dec 14, 2006 - 2 answers

Selecting the MODE of a group of data in Microsoft Access

Microsoft Access. An SQL "GROUP BY" query. How do I generate the mode of the values that it's grouping, when I want averages in other multiple fields? [more inside]
posted by Jimbob on Dec 13, 2006 - 3 answers

How do I format raw data that will eventually be part of a database?

Complete database newbie. I have raw information in the form of text, numbers and photos. This stuff will eventually be fed to users on a web site. I am in the information-collection phase now. What's the best way to collect and format the data so it has the easiest possible path into a database that will serve the web site? [more inside]
posted by crosten on Dec 10, 2006 - 9 answers

School needs centralized site for lesson plans

I'd like to develop a searchable (by tags) database of leson plans for the 20 odd teachers at my school. Any ideas? [more inside]
posted by bronxteacher on Dec 7, 2006 - 4 answers

How to begin on this multi user PHP stats project?

How would you write an application in PHP that tracks multiple users, and the users' multiple sites? [more inside]
posted by gradient on Dec 5, 2006 - 7 answers

How to get mySQL to ignore "A, An, & The" when presenting alphabetized book titles

mySQLfilter: How can I ignore "A, An, & The" at the beginning of book titles when sorting results alphabetically by title? [more inside]
posted by Wild_Eep on Dec 5, 2006 - 10 answers

+book +find +help

Where should I search in order to generate a list of all/most books published (in English, for the past 20 years or so) about a particular topic? I have a feeling that using Amazon plus my local library isn't giving me comprehensive results. Is there some kind of all-libraries database? Or all books that have been issued ISBN numbers?
posted by xo on Dec 2, 2006 - 6 answers

What are some database high-performance clustering options?

I need recommendations for affordable database solutions that provide high availability and high performance, preferably in a clustered environment. [more inside]
posted by SNACKeR on Dec 2, 2006 - 6 answers

How do I get the record with the most current date by a key field?

SQL question: How do I get the record with the most current date for each person's ID? Better explanation inside. [more inside]
posted by DakotaPaul on Nov 21, 2006 - 14 answers

Please help with an Access/Database question!

Help with MS Access needed please - I'm told it should be a fairly simple query to conduct, but I don't think I'm upto the task solo. Can the hive mind help? [more inside]
posted by dance on Nov 18, 2006 - 12 answers

Mysql... why won't you accept more connections?

Mysql5... why won't you accept more connections from a set of IP addresses? [more inside]
posted by ph00dz on Nov 16, 2006 - 12 answers

Sick of allmusic.com!

MusicResourceFilter: Are there any alternatives to allmusic.com that has as comprehensive a database for band discography, biography, and ratings, with an online presence that DOESN'T suck? [more inside]
posted by blastrid on Nov 10, 2006 - 10 answers

Best customer database for a small business?

Need to figure out the best kind of database for a small but growing business. MS Access isn't cutting it anymore. Of course there's [more inside]
posted by TayBridge on Nov 5, 2006 - 32 answers

MySQL import question

What is the easiest way to get this data into a MySQL database? [more inside]
posted by rlef98 on Nov 2, 2006 - 19 answers

Using a Database for analysis of temperatures

I've got an interesting question about MS Acess. It involves using lat/long data... Anyone care to help? [more inside]
posted by dance on Nov 2, 2006 - 15 answers

SQLServer Express remote connection problems

SQLServer Express remote connection problems. Please hope me! [more inside]
posted by derbs on Nov 2, 2006 - 9 answers

mySQL table viewers?

Stupid database question: what are some quick "viewer" applications my customers can use to work with data I'm providing locally in a mySQL database? [more inside]
posted by hodyoaten on Nov 1, 2006 - 10 answers

Organizing software in an enterprise

Any good tips on managing approved software applications within an enterprise? [more inside]
posted by daHIFI on Oct 26, 2006 - 4 answers

Why no worky?

SQLServerFilter: Quick question about views and using "NOT IN". [more inside]
posted by SoulOnIce on Oct 21, 2006 - 4 answers

orthogonality isn't a SQL know-it-all after all, let's laugh at him

Help! Stumped by an SQL problem. [more inside]
posted by hangashore on Oct 21, 2006 - 21 answers

I need help with counting.

I got the job. Now I need a little help with it. Someone I briefly worked under while at this job has posed a Microsoft Access question to me. I understand a good amount of Access but this was immediately over my head. I told her that I would see what I could find out for her. [more inside]
posted by horseblind on Oct 18, 2006 - 10 answers

Page: 1 ... 8 9 10 11 12 13 14 15