Good, inexpensive, (preferably free) online course or certification in MS Access or other database software? [more inside]
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]
Sum of data for all months, including months with no rows, in MySQL? [more inside]
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?
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.
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?
Please help me create an expandable excel function that can find and extract cell rows. [more inside]
Need a list of the top 1000 male and female names, with variants and misspellings. [more inside]
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]
Can I, should I, make a career change into database design? [more inside]
Where can I get some noob information on how to read/write simple database tables with ASP? [more inside]
This is for a personal project. Is there a free IP address to country/city list I can download? Thanks for your help.
Help me get Lexis-Nexis search results from an MS word document into a usable spreadsheet/database format. More inside. [more inside]
Career-wise, is it a smart move to take a mysql position after building up ten years of Oracle experience? [more inside]
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]
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?
What is the prefered way to represent status changes over time in a relational database? [more inside]
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]
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]
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]
DATETIME, TIMESTAMP, TIME, DATE. Which should I use for general-purpose date storage in a recent MySQL version? [more inside]
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]
How do I make sure a page loads with a fresh copy and not from the users cache? [more inside]
Looking for a free downloadable database of schools in the US. [more inside]
How can a business organise 1000+ mp3s? [more inside]
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]
What do I do to get out of this ticket and/or how do I renew my driver's license? [more inside]
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]
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?
How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]
My non-profit needs a better method of tracking our donors, what database programs are out there for us? [more inside]
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]
Need some help with MS SQL text replacement. [more inside]
How do I forecast costs for database development? [more inside]
What's the best way (using the internet, and/or books) to learn how to query SQL databases with Ruby?
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]
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?
MySQL, why won't you replicate properly? [more inside]
Please help me figure out how to learn the basics of db/app development IBM Lotus Notes 7. [more inside]
How do I find out how many domestic Combined Cycle power plants there are? [more inside]
How can I make Microsoft Access 2002 crank out organized web pages that conform to my design ideas? [more inside]
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]
Where can I find a data source containing names and disambiguations of most well-known (living and dead) people? [more inside]
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]
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]
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]
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]
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]
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]