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

Help me create a database to give money away

Help me design a small Access application to run a prize drawing. As I see it, the MC will open the application and click the Draw button, which will select from the available prizes for that month. Once drawn, that prize becomes unavailable. MC will then type in the winner's name and click Save, setting the form ready for the next contestant. Specs and examples follow. [more inside]
posted by kc0dxh on Jan 16, 2008 - 8 answers

Best DBA certification?

What DBA certification should I pursue? MS, Oracle, something else? [more inside]
posted by davar on Jan 15, 2008 - 3 answers

MySQL Query from 2 Tables?

How do I query data from one MySQL table, but I also need to get a single piece of data from a second table too? Should I be doing a JOIN, or a separate query? [more inside]
posted by gramcracker on Jan 7, 2008 - 9 answers

How can I get the USDA's nutrition data into excel?

How can I get data from the USDA's food database into excel? [more inside]
posted by Nish ton on Jan 5, 2008 - 8 answers

help a layman understand multi-dimensional data modelling

I'd like to know how multi-dimensional data modelling works. [more inside]
posted by goethean on Dec 26, 2007 - 2 answers

Please save me from "Excel Hell"

I need suggestions for an application (or database) to help my employer keep better track of live-trivia scorekeeping results. They are currently doing it all in various separate Excel spreadsheets, and this is (almost) 2008, so I'm sure there must be a better way. [more inside]
posted by jmnugent on Dec 24, 2007 - 3 answers

Terminology Management software solutions

Software for keeping lists of terms and definitions organized? Help me tame the glossary monster. [more inside]
posted by gemmy on Dec 20, 2007 - 4 answers

RFRFPFilter: Help me choose a Web Developer for this huge site!

I've been charged with redoing our Label Website pretty much from scratch, both back-end and front-end (yes, its a self-link but its relevant). Because this site is about classical music, there is a HUGE amount of metadata that will need to be collected, parsed and displayed (think 3700 titles * 10 tracks * performer, composer, title, length, etc for each track). Has anyone done or know of anyone who's done work on this scale on either the back-end side or the design side before that they might recommend? I have an RFP pretty much already mocked-up. I would've liked to have used someone like 37signals but it seems like they don't do work for others anymore.
posted by softlord on Dec 19, 2007 - 13 answers

How do I combine records in Filemaker?

Filemaker question: How do I combine two records into one? [more inside]
posted by parkerjackson on Dec 19, 2007 - 5 answers

Can we read the same email without tears?

Help me use email in a multi-user environment. IMAP is great, but not for more than one user at a time. [more inside]
posted by al_fresco on Dec 10, 2007 - 14 answers

access classes?

Good, inexpensive, (preferably free) online course or certification in MS Access or other database software? [more inside]
posted by shotgunbooty on Dec 6, 2007 - 1 answer

SQL help

Please help me with a giant SQL-ish mess. I need a better solution than MS Access for dealing with millions of records and building queries. [more inside]
posted by loquax on Nov 19, 2007 - 12 answers

All months, now.

Sum of data for all months, including months with no rows, in MySQL? [more inside]
posted by tmcw on Nov 15, 2007 - 7 answers

Help me create a craigslist type board for my company

I have been assigned to create a craigslist-like community board for my company's internal website. The basic idea is to have a place for 100+ employees to post classifieds, events, etc. The only problem is I have limited (no) web database knowledge or experience. Is there any kind of community board templates or software that can be easily set up?
posted by ieatwords on Nov 6, 2007 - 5 answers

Publicly available databases involving terrorism and war

After hearing this story on NPR this morning about the Harmony Database of al Qaeda correspondence, I began wondering what other public databases like this exist out there that are ripe for analysis and picking apart. I'm looking specifically for things like this related to the "War on Terrorism" and the Iraq War, but older stuff would be good too.
posted by proj on Oct 23, 2007 - 2 answers

ColdFusion SQL Injection Attack Terror

ColdFusion MX 7 and Microsoft SQL Server 2005. There's a lot of unvalidated parameters in our CFQUERYs. But, I'm told that putting the parameters in single-quotes will prevent injection attacks, because of the way ColdFusion escapes single-quotes. Is this foolproof, or do I have to go in and validate everything with CFQUERYPARAM tags?
posted by East Manitoba Regional Junior Kabaddi Champion '94 on Oct 22, 2007 - 3 answers

Help me Excel.

Please help me create an expandable excel function that can find and extract cell rows. [more inside]
posted by guruguy9 on Oct 11, 2007 - 5 answers

List of names

Need a list of the top 1000 male and female names, with variants and misspellings. [more inside]
posted by MattS on Oct 2, 2007 - 7 answers

How do you keep track of a whole world?

Help me find a (hopefully free and easy to use) tool that could be used to create and organize a Fantasy world for a Paper and Pencil Role Playing Game. Something like a hypertext database that fiction writers might use. [more inside]
posted by DetonatedManiac on Oct 1, 2007 - 7 answers

Could I design databases for a living?

Can I, should I, make a career change into database design? [more inside]
posted by argybarg on Sep 25, 2007 - 16 answers

an asp stung my database

Where can I get some noob information on how to read/write simple database tables with ASP? [more inside]
posted by yonation on Sep 25, 2007 - 4 answers

Where can I get a database of all IP addresses for free?

This is for a personal project. Is there a free IP address to country/city list I can download? Thanks for your help.
posted by parttimeninja on Sep 22, 2007 - 2 answers

Help me get data from a word doc into a spreadsheet/database, please. thank you!

Help me get Lexis-Nexis search results from an MS word document into a usable spreadsheet/database format. More inside. [more inside]
posted by krudiger on Sep 19, 2007 - 6 answers

Does taking on mysql after 10 years of Oracle make sense?

Career-wise, is it a smart move to take a mysql position after building up ten years of Oracle experience? [more inside]
posted by anonymous on Sep 18, 2007 - 6 answers

Bootleg Management with WordPress?

WordPressFilter: Can I do something like this site with WordPress? [more inside]
posted by SansPoint on Sep 16, 2007 - 8 answers

I'm not a number, I'm a postcode!

You know when you're filling out a online address form, and they ask for your postcode then find your full address? Yeah, that doesn't work for me. How do I fix this? [more inside]
posted by Orange Goblin on Sep 13, 2007 - 3 answers

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

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