I'm putting together an Access database (woe is me), which includes some "multiple choice" fields, that contain a defined list of options. I've got some code that puts together a query, and generates a report. The way these fields are displayed in this report is inconsistent, and I'm trying to figure out why.
[more inside]
posted by Jimbob
on Jun 9, 2013 -
1 answer
I would like advice on creating a dynamic graphing website to display clinical data on a intranet website to better aide clinicians. What my superiors are seeking is a "Data Mall." My programming/server-admin. experience is minimal, but my Linux-hobbyist mentality
hates the MS Access solution that is being built.
[more inside]
posted by rosswald
on Jan 16, 2013 -
4 answers
I'm a bit of a SQL novice but learning at a decent clip. I'm using SQL (Aqua Data Studio, if that matters to you) to update a couple of fields in an Oracle database table. I'd like to do this across a range of one of the fields. One field is a numeric field (trans_id - a transaction id) that I need to increase by 1 -- I think have that part licked. The next field is alphanumeric (calendar_name - represents the name of a week) and also needs to be incremented by one. The doozy (for me) is the alphanumeric field. Who's the guru?
[more inside]
posted by brokeaspoke
on Feb 4, 2012 -
11 answers
I have a wonderful (Oracle) SQL database and I use Navicat Lite to crunch around in it. My problem is that I'm staring at lists of 50+ tables, 60+ saved queries, 10+ views, etc. Is there anything I can do to somehow organise things in a visually pleasing and/or functional way?
[more inside]
posted by iamkimiam
on Feb 2, 2012 -
4 answers
Hey all. I need to learn the basic principles of SQL and Oracle databases. I'm looking for web resources and books. Got any favorites? What's out there?
Thanks in advance.
posted by Stagger Lee
on Dec 5, 2011 -
12 answers
[Python/database filter] I wrote a script in python for a class and I want to challenge myself now to make it attached to a database...
[more inside]
posted by handbanana
on Aug 26, 2011 -
8 answers
I've been working with SQL and RDBMSes for a number of years, but my most recent job involved no DB work at all. Understandably, I'm a bit rusty. So I'd like to get a good book to help me brush up, and also to learn a bit more about RDBMS technology. What would you recommend?
[more inside]
posted by Sloop John B
on May 3, 2011 -
3 answers
I'm using Navicat Lite to connect to my Oracle research database (Mac OSX). Much of my data is in IPA (International Phonetic Alphabet). These are unicode symbols. Is there a way to display the IPA/Unicode in Navicat? Or some other GUI? Or is there some addon/code/plugin/whatever that will show me the symbols?
[more inside]
posted by iamkimiam
on Mar 8, 2011 -
2 answers
I have a MS Access 2000 table with approx 300,000 records. I need help with constructing a query.
[more inside]
posted by selton
on Feb 13, 2011 -
3 answers
I have a list of about 350 words that I'm putting into a database that I'm building from scratch. For each word in the list, I'd like to include its American English dictionary definition (preferably American Heritage Dictionary), UrbanDictionary entry, and Wikipedia page link (I realize that entries may not exist for some columns for many of these words). Is there some way to streamline or data-mine this process, so I don't have to look up each word individually in 3 separate sources x350+, not to mention all the copying and pasting?
[more inside]
posted by iamkimiam
on Feb 11, 2011 -
10 answers
SQLfilter: Help me solve a problem that's driving me crazy. I'm working with someone else's data, and I've got a seemingly insurmountable select problem that no amount of googling has helped me with so far.
[more inside]
posted by Mr. Bad Example
on Dec 17, 2010 -
11 answers
What are the current best options for providing a front end for users to search and enter data to a SQL database?
[more inside]
posted by tabulem
on Oct 15, 2010 -
8 answers
How can I export data from a SQL database into a CSV file and add a new column at the same time?
[more inside]
posted by jfricke
on Sep 8, 2010 -
8 answers
Is there somewhere you can go to upload some tables (or import CSV files) and run SQL commands on it?
[more inside]
posted by metametababe
on Jun 7, 2010 -
8 answers
SQL - How to get an accurate count of the rows potentially affected by an UPDATE statement, or best practices for performing updates?
[more inside]
posted by odinsdream
on Feb 9, 2010 -
18 answers
In the Seattle/Snohomish area. Which schools provide good training in beginning SQL, or database design, or IT project management?
[more inside]
posted by valannc
on Oct 31, 2009 -
3 answers
SQL query help. Given the (fictional but equivalent) table disk_status = computer_id:int, disk_id:int, datetime:datetime, temperature:float, rpm:int, I need to provide a table of disk status for a given computer_id, without knowing in advance how many disks there are. So if there were two disks for a particular computer, the result would have the header: datetime, disk_1_temperature, disk_1_rpm, disk_2_temperature, disk_2_rpm, disk_2_rpm
[more inside]
posted by Nothing
on Apr 16, 2009 -
25 answers
I have been asked to make a proposal to upsize an Access database to allow for a few more concurrent users (currently 10) and ideally improve the overall performance of the system. Am I getting in over my head?
[more inside]
posted by cbrody
on Mar 10, 2009 -
11 answers
Microsoft Access query problem - Comparing two similar tables that don't match up well. It's lists of classes in a collection of locations from two consecutive years, and what I need is to show the class fees side by side for any class that happened in the same location both years.
[more inside]
posted by dnash
on Feb 5, 2009 -
13 answers
My developer and I want to create a database schema that allows us to search through hundreds of tags applied to thousands of records. So far our benchmarks suck. Are we expecting too much?
[more inside]
posted by hayvac
on Feb 4, 2009 -
17 answers
Can anyone give me advice on dealing with checkboxes in PHP, to hand off to SQL.
[more inside]
posted by opsin
on Jan 30, 2009 -
8 answers
Database Olympics: File Maker Pro vs. MySQL! Help us pick a database system (
Anko or
Firebrand). Which do you think is superior to run a print publication database?
[more inside]
posted by spakto
on Aug 19, 2008 -
6 answers
I'd like to reconstitute a years-defunct wiki I used to collaborate on. I've contacted the principals, & our searches for the database backup have come up empty so far. Without having the original database, the simplest path appears to be taking the html & transforming it into, say, an sql dump. So - how do I do that? Are there any MediaWiki, database, or Perl trails to follow?
posted by Pronoiac
on Aug 6, 2008 -
10 answers
I need to import a database into MS SQL but I do not want to end up with a transaction log as large as the database. What's the best way to do the import?
[more inside]
posted by odinsdream
on May 29, 2008 -
4 answers
Which version of PHP should I start to learn, and how? I know HTML and CSS, and intend to build with Drupal (or similar) and its many extensions.
[more inside]
posted by prophetsearcher
on May 4, 2008 -
12 answers
MySQL sorting issue. When I have "first name" and "last name" columns, and I'm sorting primarily by "last name." Some entries have only a "first name," and rather than have those end up at either the start or end of the sort, I'd like it to pretend the "first name" IS the "last name" and sort accordingly. Is there a way to do this with the SQL SELECT statement or should I just edit the data?
[more inside]
posted by dnash
on May 2, 2008 -
8 answers
SQL Filter: What query can I use to count the number of times a word appears in a text field?
[more inside]
posted by Wild_Eep
on Feb 21, 2008 -
6 answers
Some colleagues and I will soon be leaving our current employer and starting a new company. How can I best replicate our current relational database/SQL abilities from scratch?
[more inside]
posted by raz5
on Jan 23, 2008 -
11 answers
What DBA certification should I pursue? MS, Oracle, something else?
[more inside]
posted by davar
on Jan 15, 2008 -
3 answers
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
Sum of data for all months, including months with no rows, in MySQL?
[more inside]
posted by tmcw
on Nov 15, 2007 -
7 answers
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
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
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
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
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
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
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
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
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
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
