719 posts tagged with database.
Displaying 501 through 550 of 719. Subscribe:

Really basic MS Access question

Forgive me for asking such an embarrassingly basic MS Access question. I have two voter lists. Each one has a list of voters, and each voter has a unique identifying number as well as some other fields. There are some voters who appear on both lists (having identical voter numbers on both lists) and some voters who appear on only one. I am only concerned with the voters who appear on both lists: how do I import some fields from one list to the other so that the unique identifying number for each voter is matched by that voter's data from the other list?
posted by Mr. Justice on Sep 9, 2007 - 7 answers

What is the prefered way to represent status changes over time in a relational database?

What is the prefered way to represent status changes over time in a relational database? [more inside]
posted by kimota on Sep 4, 2007 - 17 answers

What is the easiest way to index pre-existing bibliographies?

Bibliographic software newbie question: given an enormous backlog of hand-written bibliographies, what's my best bet for producing a database and integrating it with a book manuscript? I'd like to be able to push a button and change citation styles. No arduous data-entry, please. [more inside]
posted by anotherpanacea on Sep 2, 2007 - 10 answers

Datawarehouse 101

I am changing jobs in a couple of months, and need to know more about database design, and more specifically datawarehouse and datamart for reporting systems. [more inside]
posted by jontyjago on Aug 28, 2007 - 2 answers

MYSQL form woes

MYSQL question: I want to develop simple input form for our internal office MYSQL. We need to attach files to our product information. I'm using OO, but it doesn't deal with BLOBs what other software could I use to create forms to our database? [more inside]
posted by Yavsy on Aug 20, 2007 - 6 answers

I just want a good time...

DATETIME, TIMESTAMP, TIME, DATE. Which should I use for general-purpose date storage in a recent MySQL version? [more inside]
posted by tmcw on Aug 20, 2007 - 16 answers

SQL Combinations

Any SQL / math ninja's on the green fancy a quick challenge..? So I've got this table containing number pairs, right, and I need to compute all the possible combinations. [more inside]
posted by whoojemaflip on Aug 15, 2007 - 25 answers

Ahhh, now thats refreshing!

How do I make sure a page loads with a fresh copy and not from the users cache? [more inside]
posted by LoopyG on Aug 9, 2007 - 7 answers

Database of schools in the US.

Looking for a free downloadable database of schools in the US. [more inside]
posted by Mr_Zero on Aug 7, 2007 - 6 answers

The current system is a mess.

How can a business organise 1000+ mp3s? [more inside]
posted by popcassady on Jul 23, 2007 - 10 answers

Good programs for sharing contacts and calendar info in a small company?

What are good programs for sharing contact and calendar information in a small office? The most attractive piece of software I've found so far is "ACT!" [more inside]
posted by redteam on Jul 12, 2007 - 11 answers

national driver's licence database hell

What do I do to get out of this ticket and/or how do I renew my driver's license? [more inside]
posted by Huplescat on Jul 10, 2007 - 7 answers

Other frameworks akin to Ruby on Rails?

What are the best database-driven Web application development frameworks out there right now? More specifically, please orient me to toolsets you know of that are similar to Ruby on Rails. [more inside]
posted by killdevil on Jul 6, 2007 - 17 answers

Access, Web-Style?

Rather continue to work with Microsoft Access, I'd love to move a few old databases I continue to maintain into a www database app, if one exists. I'd like something that feels Access-like, with the ability to structure queries and forms as Access does. I'd happily accept a script package that I can easily install and maintain on my own web server, or a full service. Is there such an Access corollary, either free or available for purchase?
posted by boombot on Jul 2, 2007 - 10 answers

Help me merge Excel with Access:

How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]
posted by 2bucksplus on Jul 2, 2007 - 3 answers

donor database programs for non-profits?

My non-profit needs a better method of tracking our donors, what database programs are out there for us? [more inside]
posted by nerdcore on Jun 29, 2007 - 11 answers

Help moving broken Movable Type database to WordPress?

I have a personal blog running under Movable Type. I want to move to WordPress. I've exported the existing entries to a text file, so that's good. However, a couple years ago my previous MT install tanked (similar to this). I cannot access it. I have several years worth of posts that are stuck in a database that I can't get to. I've been gradually moving these by hand to my existing MT install, but that's a pain in the ass. Is there some automated way to crawl/scrape the existing HTML files in order to retrieve these "lost" entries? Some way to break back into a corrupt MT database? Some way to repair it? (The install is BerkelyDB-based.) [more inside]
posted by jdroth on Jun 29, 2007 - 11 answers

SQL to update multi-values?

Need some help with MS SQL text replacement. [more inside]
posted by Four Flavors on Jun 18, 2007 - 15 answers

How do I forecast costs for database development?

How do I forecast costs for database development? [more inside]
posted by Roach on Jun 12, 2007 - 19 answers

How to query SQL with Ruby?

What's the best way (using the internet, and/or books) to learn how to query SQL databases with Ruby?
posted by anonymous on Jun 10, 2007 - 3 answers

Need help developing a small relational db

Help me properly set up a very small relational db. This is a teensy bit over my head, so mainly I want to establish that I'm not going terribly wrong before I get too far into this. [more inside]
posted by desjardins on Jun 6, 2007 - 5 answers

Custom This Day In History website?

I need to put a "This day in history" online for my organization's (custom) dates and history. Is there a website / piece of software out there that does that?
posted by duncantuna on Jun 1, 2007 - 3 answers

MySQL SLAVE, obey your MASTER!

MySQL, why won't you replicate properly? [more inside]
posted by ph00dz on May 29, 2007 - 6 answers


Please help me figure out how to learn the basics of db/app development IBM Lotus Notes 7. [more inside]
posted by Alterscape on May 21, 2007 - 4 answers

Power Industry Research

How do I find out how many domestic Combined Cycle power plants there are? [more inside]
posted by BigSky on May 18, 2007 - 6 answers

How do I get MS Access to create organized web pages?

How can I make Microsoft Access 2002 crank out organized web pages that conform to my design ideas? [more inside]
posted by Servo5678 on May 14, 2007 - 2 answers

Where can I buy an $800 Linux Server?

I need to buy a server for around $800 ($1000 as an absolute maximum). It will be hosting a website with a (PostGres) database that will start at around 4GB and grow slowly (so would like at least 2GB of RAM). It must be able run Linux, preferably Ubuntu or Debian. [more inside]
posted by phrontist on May 10, 2007 - 9 answers

Database of famous persons' names + disambiguations - where?

Where can I find a data source containing names and disambiguations of most well-known (living and dead) people? [more inside]
posted by masymas on May 8, 2007 - 3 answers


Law Filter: A friend of mine who is a lawyer once helped us find cases of precedent from an online court database. I am now looking for that database to see if there have been any similar cases to a problem that I am currently researching. This is for the State of Colorado I should add. [more inside]
posted by occidental on May 3, 2007 - 8 answers

Help me prioritize the people I bug for money

Excel-filter: I have a spreadsheet with a list of donations made over the past year. Unfortunately, when an individual has donated multiple times within a year there is a new row for each donation. Fortunately, that individual is assigned the same unique identifier. How do I make it so that each individual has one row with total donations for the year? [more inside]
posted by ewiar on May 1, 2007 - 6 answers

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

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