How can I implement bi-directional synchronized table changes in a mySQL database and Microsoft Access?
[more inside]
posted by mic stand
on Apr 19, 2006 -
6 answers
SQL WTH: various examples given on websites and in a small stack of books don't work.
[more inside]
posted by Tuwa
on Apr 15, 2006 -
9 answers
Which database certifications would be most useful, from the point of view of employability?
[more inside]
posted by nanojath
on Apr 12, 2006 -
5 answers
I have an Excel Spreadsheet (using Excel 2003). Rather than creating formulas to answer ad hoc questions that I have, I would like to be able to quickly type in a SQL querty against the data in the spreadsheet. So, I could scroll down to the bottom of the sheet to see how many rows I have, OR I could type" select count(*) from data_table" instead. I prefer the latter. Any suggestions?
[more inside]
posted by apark
on Apr 7, 2006 -
6 answers
Has anyone ever managed to use iTunes and COM to access the iTunes database and modify MP3 meta-data tags? I need to change the genre for every track by a certain artist and since I have a list of over 800 artists, it is not something I can do by hand.
[more inside]
posted by mr_silver
on Apr 7, 2006 -
13 answers
We're outgrowing our 10 year old Progress database. We need some recommendations.
[more inside]
posted by Brainy
on Mar 27, 2006 -
13 answers
I want to interact with my music library over a network and be able to add notes, links, etc. to each item. Looking for static or dynamic approaches . . .
[more inside]
posted by fourcheesemac
on Mar 25, 2006 -
4 answers
I have an SQL query that totals the number of students per grade. How do I get a grand total of the number of students?
[more inside]
posted by DakotaPaul
on Mar 17, 2006 -
6 answers
How can I import selected fields from one database into another database?
[more inside]
posted by fvox13
on Mar 16, 2006 -
6 answers
What classical music databases exist? I'm
not looking for lists or even data. I am looking for relational database DDL that describes/implements a structure sufficient to describe/model classical music.
Or, if you don't know of such a database, classical aficionados, give me advice on how to implement such a database.
[more inside]
posted by orthogonality
on Feb 22, 2006 -
14 answers
I'm looking for a software tool that will ingest a large XML file, and allow me to write sql-like queries against it for both summary reporting, as well as detailed reports.
[more inside]
posted by nomisxid
on Feb 15, 2006 -
31 answers
Can anyone point me to a good documentation/samples for building an app using mod_python and cheetah? (and mySQL/DBUtils etc)?
[more inside]
posted by karen
on Feb 14, 2006 -
2 answers
I'm making a contact database for the first time in Filemaker. I've got a field where I'm entering useful tags. I want to make a front end for this system in the form of a tag cloud. Since I'm so new to Filemaker, I don't know if this is useful or possible -- all I know is Google's never heard of such a thing.
[more inside]
posted by electric_counterpoint
on Feb 2, 2006 -
3 answers
I want to build a comparative index of translations for a specific book of poems. How should I do this?
[more inside]
posted by selfnoise
on Jan 27, 2006 -
11 answers
Basic Microsoft Excel question. How do I join two databases together when they share elements but are not coextensively equal? (More)
[more inside]
posted by Mr. Justice
on Jan 22, 2006 -
8 answers
Needed: a good clipart graphic representing a database (shape of a cylinder) for a quick powerpoint presentation. There has to be something decent in the public domain. Any links? Thanks!
posted by queue_strategy
on Jan 21, 2006 -
8 answers
What considerations should I use in determining file format and size with a digital database that will be available online?
[more inside]
posted by stormygrey
on Jan 5, 2006 -
9 answers
How can I manage my databases that are exploding in size? Can I run SQL Server on my laptop?
[more inside]
posted by benjh
on Dec 9, 2005 -
9 answers
I'm about to set up a database (pet science project) that has about 200 million records consisting of about 50 mostly-numeric fields. Is mysql up to this task? If not, what is? And since many fields are null, how can it be optimized to consume the least possible disk space? I'm worried about bloat eating up my 100 GB drive.
posted by shannymara
on Dec 6, 2005 -
9 answers
MySQL Hell: I've spent most of my vacation trying to figure out why MySQL has gone nuts. It's part of a Movable Type install with tons of posts, comments, and log entries, and it's always run smoothly before. The problem is that it'll bomb on random queries, seemingly every minute or two, since status queries always show uptime in tens of seconds. Repairing the larger tables and restarting the server has done nothing, and no major changes have been made. What's wrong? Is this a *nix issue, a MySQL issue, or an MT issue? And how do I go about telling the difference, or fixing any of them?
[more inside]
posted by paul_smatatoes
on Nov 28, 2005 -
32 answers
I need to get MySQL working with Visual Studio 2005. I come from the PHP world, and while I know C, C# is a new language to me.
[more inside]
posted by SpecialK
on Nov 25, 2005 -
14 answers
I was recently hired as a work study at school to work on a project and I'm having some trouble deciding how to organize the information...
[more inside]
posted by Kosh
on Nov 19, 2005 -
8 answers
How do I import data into a table in an Access database in such a way that the new table will retain all of the relationships currently extant in the database? Is there a way to make a new table and overwrite the old table (say the table is called 'users') and preserve the relationships?
posted by zephyrbill
on Nov 3, 2005 -
6 answers
We're looking for a way to keep track of employees, clients, suppliers. Ideally, I'd be able to link to reference files (images, PDFs, spreadsheets) on the hard drive, print compact lists of entries, labels for contacts, and so on.
[more inside]
posted by evil holiday magic
on Oct 15, 2005 -
6 answers
My website is hosted by Dreamhost. It primarily consists of a Movable Type weblog that I keep for family and friends. A few others have weblogs on my MT installation. I use the Berkely DB option and MT 2.661 (for licensing reasons). Suddenly today I am unable to login. Comments result in an odd error. When I attempt to recover my password, I get an 'invalid username' error. To me, it appears the database has become corrupt. HELP! Can the database be saved? Does anyone have experience with a similar blogtastrophe?
posted by jdroth
on Oct 11, 2005 -
14 answers
I want to create an online document database containing text, video, audio, and image files searchable by category (Such as War > Vietnam > Napalm Footage), keywords (Such as grainy, color, etc.) and, for text, a full-text search. And I'd like to be able to define a number of other custom fields (such as Source, Date, etc.), with the ability to search as many or as few fields as I'd like. And I would also like the ability to browse by category.
Anything out there that meets these standards, preferably using PHP and MySQL?
posted by punishinglemur
on Oct 4, 2005 -
11 answers
I have a MySQL database that contains two fields - name and e-mail - for a bunch of records. Separately I have a FileMaker 7 database that contains the same fields - name and e-mail -
and contains other fields, like "notes".
My question: can the FileMaker database, after polling the MySQL database, show name and e-mail as read-only; and then show the other fields as editable? i.e. if I make a change to the MySQL database, can I get it to show up in FM?
[more inside]
posted by mark7570
on Sep 30, 2005 -
2 answers
Is there any program that runs natively on OS X that would allow me to work with a Microsoft Access database? Or am I doomed to run SoftPC?
[more inside]
posted by lesingesavant
on Sep 28, 2005 -
5 answers
The
FEC is extremely useful in figuring out who is giving money to politicians. Is there a similar database of which corporations are being awarded contracts from the government?
posted by phrontist
on Sep 25, 2005 -
1 answer
So, I'm writing this book, and I need some software advice for making a computerized version of my mental rolodex. (DIT)
[more inside]
posted by kungfujoe
on Sep 9, 2005 -
5 answers
Can someone please help me understand how a database for a site like 43 Things (www.43things.com) works? There are users, tags for categories, user comments (for categories), and comments that can be associated with other comments. I understand that you would need a user table, a comments table, and a tags table but how do you create a schema for a site like this that works effectively? What kind of table structure is needed and how do the tables interrelate?
posted by jlstitt
on Sep 7, 2005 -
11 answers
Routers: This may seem rather silly to some folks, but I need a little help in figuring out what my network problem is. (I tried to google around, but i am not even sure what the term is that I should be searching for) The problem is, I am hosting my own web-server and MySQL DB for development purposes, and I have a domain name that points to it. When I am outside my own network I can hit my URL just fine. But when I inside my network, it always try to go to the routers configuration page. Any ideas as how to make sure the router is forwarding the ports correctly INSIDE my network?
posted by countzen
on Sep 7, 2005 -
7 answers
Database 101... I have two tables, with one common field, an ID number. One table has many more records than the other. How can I tell which records in the 'big' table are also in the 'small' table?
[more inside]
posted by clgregor
on Sep 2, 2005 -
5 answers
I need to create a phone number directory on CD. I could just create an alphabetical directory with anchors in html, but I would love have a search function with dynamic pages. Is there a straightforward way to do this on CD?
posted by spartacusroosevelt
on Aug 14, 2005 -
3 answers
I'm looking for information about home prices that have recently sold. Specifically, I'd like to find some sort of database that can make it easy for me to get comparables for any given property. Even more ideally, if it could compare a resource of available properties, and flag when their comparable value is under the market, that would be fantastic. Any thoughts on this, or how I could put this together?
posted by wflanagan
on Aug 7, 2005 -
12 answers
I'm planning on creating a web-based program allowing employees of the auditorium where I work to sign up for shifts online. What programming language and database system should I use?
[more inside]
posted by joshuaconner
on Jul 31, 2005 -
14 answers
I am running in a graphics environment (pagemaker) and would like to extract the information to a database. Does anyone know of a program that can export this to a format that excel or access can use.
posted by aisleofview
on Jul 26, 2005 -
3 answers
