82 posts tagged with query.
Displaying 1 through 50 of 82. Subscribe:

Who do I address my query to?

So, I finally wrote a novel and I'm ready to start looking for an agent. I found this via twitter, and the agent looks like a good fit for my book. The submission guidelines at her agency say "Please mail submissions to the attention of ETHAN ELLENBERG". [more inside]
posted by notbuddha on Jun 23, 2016 - 5 answers

MS Access SQL question

I think this should be simple, but I don't use Access very often and my brain isn't working tonight. [more inside]
posted by ctmf on Mar 22, 2016 - 14 answers

Public or inexpensive whois lookup service

I have a several-thousand word set. I would like to check each word to see if a .com domain (or other TLD) name is available. The command-line whois binary throttles my scripted requests after about 10 searches. Is there a reasonably comprehensive whois service that is free or inexpensive, which I can query in scripted manner, via a command-line session?
posted by a lungful of dragon on Dec 22, 2015 - 14 answers

Querying Literary Agents: the fine points

I have a finished book and I'm about to begin querying literary agents. In some cases, the agency websites break it down by specific agents, and you're encouraged to query a specific person. Other agencies -- this one as an example -- just provide a catchall email address. So I'm puzzling over how to address my query: Dear...? Suggestions?
posted by swheatie on Oct 3, 2015 - 9 answers

Wordpress DB growing too large?

I have a wordpress site running WooCommerce. I'm getting a couple dozen notices from Webfaction each day saying that a mysql query has taken longer than a minute and has been killed. [more inside]
posted by humboldt32 on Jul 21, 2015 - 13 answers

How to query for a literary series

I've been working on a series of middle grade fantasy books. After finishing the first installment back in July, I sent out queries to literary agents. I have finished a second installment and have several questions about how to go about querying for multiple books. [more inside]
posted by dances_with_sneetches on Jan 19, 2015 - 4 answers

Merging Duplicate rows in Excel or Access

I have a table with duplicate values in one column. Some of the other columns have a value, some don't. I want to have one row for each record, with all of the colums values in one row (NOT CONCATENATED). I can use Excel or Access for this. [more inside]
posted by desjardins on Jun 19, 2014 - 21 answers

Good free (or really cheap) system to poll an audience while lecturing?

Does anyone know of a good site or software that is free or cheap that lets you: 1) Ask a poll or multiple choice question during lecture and, perhaps, in the next slide, populate a graph with the results? Again, thanks in advance for any good links here. [more inside]
posted by skepticallypleased on Jul 16, 2013 - 7 answers

MS Access Combo Box Fields behaving strangely.

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

Fixing an unreasonably slow MySQL query

Query and Explain output here. Query must be executed 4022 times, each with a different Strip_ID, while the script processes, adding 4+ minutes to what would otherwise be a ~90-second task. I have (separate) indices defined @ Parent_Table and Parent_ID, in addition to the table's primary key on an auto-incrementing ID. Adding combined indices for those two fields (in each order, just to be safe) did not change MySQL's analysis of the query or improve execution speed. [more inside]
posted by The Confessor on May 24, 2013 - 9 answers

Excel keeps unreferring my references

Excel 2010 query using data from MS Access: refreshing the query screws with my cell references. Help me make it stop. [more inside]
posted by jeather on Apr 18, 2012 - 2 answers

Better Living Through Queries

Help me help myself- Please recommend books or websites that will help me to better understand SQL. [more inside]
posted by bluejayway on Mar 1, 2012 - 11 answers

How do I get the old Google search results back?

So, it would appear that Google have changed their search algorithms. Using search queries that would have previously returned hundreds of results I am getting a handful of results which are mostly irrelevant / gibberish. Any ideas how I can go back to the "old" Google? Thanks!
posted by FuckingAwesome on Mar 1, 2012 - 14 answers

Need some pointers on creating a simple inventory database

Need help setting up a simple Access database. I'm trying to reconcile a bunch of inventory, which is all recorded in multiple Excel spreadsheets. I want to import all the Excel files into an Access database so I can match them up all at the same time. [more inside]
posted by smoothvirus on Feb 22, 2012 - 8 answers

Is there a way to visually organize database tables (and saved queries and views)?

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

Editorial Calendars, Yes or No

I am doing some freelance writing and have a program that helps organize publications, their contact information and my writing history with them. Querying editors works but has a low success rate - probably about 5% of queries result in assignments ... that is, no speculation pieces. I research the publication and tailor specific queiries to specific subjects, so editors know I'm not mass querying similar publications with the same topic. Many publications use editorial calenders to preview what they're going to feature months in advance [more inside]
posted by CollectiveMind on Oct 2, 2011 - 3 answers

How to write an SQL query in unix?

I'd like to perform an SQL query with outer joins, from text files on my PC, using only a unix emulator. Is this possible on my PC? How would I write and execute it? [more inside]
posted by RobinFiveWords on Sep 13, 2011 - 16 answers

How do I get data from multiple other entries in a database?

SQL help: I'm very new to SQL, and need to update one field with the maximum value of all entries in another field selected based on a shared value in a third field. [more inside]
posted by agentofselection on Jul 17, 2011 - 12 answers

methods or products to query objects?

What are some "end user" products (preferably open source) or methodologies that allow complex queries of objects? I want to allow both programmers and non-programmers to be able to access the data. [more inside]
posted by santogold on May 20, 2011 - 10 answers

TF2 server queries?

Is there a way to tell what specific mods a Team Fortress 2 server is running from the client console? [more inside]
posted by ofcourseican on May 2, 2011 - 1 answer

Need help with SQL statement

I need to create a query in Access that shows the percentage of a total. I can't grasp the SQL statement I need. [more inside]
posted by desjardins on Jan 26, 2011 - 7 answers

I want to query a map like a database!

I'd like to query geographical and population-based data. "$city <> 200,000" and so on and so forth. What is this called and where can I find data like this? Willing to spend some money if necessary. [more inside]
posted by unixrat on Jan 19, 2011 - 8 answers

How do I append rows to a table in Access from two related tables?

How do I append rows to a table in Access from two related tables? [more inside]
posted by desjardins on Dec 27, 2010 - 3 answers

Need help formatting an Access report from a query and SQL help

I'm having trouble formatting a report in Access that ONLY shows checkboxes that are not checked. I probably need some help on the SQL front. [more inside]
posted by desjardins on Dec 20, 2010 - 4 answers

I haven't needed SQL this ugly before

What SQL magic do I need to turn one column into several? [more inside]
posted by flabdablet on Dec 19, 2010 - 14 answers

How can I select this in SQL?

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

Automatically generating an email from a query in Access

I have a database in Access that is essentially a list of projects and associated tasks. I have a query that lists all projects due in the next 30 days. How can I automatically generate an email from this query? Ideally this would just magically send an email whenever the query is populated with a new project. [more inside]
posted by desjardins on Dec 10, 2010 - 8 answers

MySQL: How to Selectively Update a Table from a CSV List?

MySQL: How Do I Selectively Update a Table from a CSV List? [more inside]
posted by darth_tedious on Nov 18, 2010 - 8 answers

mySql query assistance, please!

mySQL query question about calculating percentages in a table. [more inside]
posted by omnipotentq on Sep 5, 2010 - 3 answers

All your data are belong to CURL

Where can I lookup the future earnings reports date of a given company by ticker. [more inside]
posted by sourbrew on Aug 1, 2010 - 5 answers

Analyzing Surname Data

I need help visually and clearly showing/analyzing surname data retrieved from 23andme.com's Relative Finder feature. [more inside]
posted by angelaas525 on Jul 9, 2010 - 4 answers

$700 on the publishing industry roulette wheel...

I have written a literary science fiction novel. I am confident that it is salable, but I am so far having difficulty finding an agent. I am considering going to the Backspace Writer's Conference but am uncertain as to whether the $700 cost would be a good investment. [more inside]
posted by 256 on May 2, 2010 - 12 answers

using a QUERY formulate in Google Spreadsheet

Hi, I searched through the archives and did not find a match. Thank you in advance. Let's say I have a spreadsheet in Google docs with two columns, names and dollar amounts. Jane Smith, $5; Joe Sixpack, $7; Jane Goodall, $4; Joe Frankin, $10, etc. I want to use – I think – the QUERY function to ADD up all the dollars that all the Joe's have, or all the dollars that the Jane's have. I have read through as much documentation as I can find and it's not giving me enough to formulate a successful query. This:
=query(A1:B20, "Select A where (A contains 'jane')", sum(B))
does not work. Any suggestions? thank you!
posted by noway on Mar 22, 2010 - 11 answers

SQL QUERY ow to achieve it? (short paths)

I am trying to create a SQL Query for Access2003 that will basically show me by employee ALL potential classes they can take and sorted together with the most recent date of a class they may have taken. Basically this is used as a worksheet to plan training for the people who may have some of the required training but not others. (see inside [more inside]
posted by wildpetals on Feb 2, 2010 - 3 answers

No Reply re: short story status! What next?

How do I query literary periodicals about "disappeared" short stories? [more inside]
posted by uans on Jan 22, 2010 - 11 answers

Uh...hang on, just give me a minute.

What is the most important scientific question of our time? [more inside]
posted by Demogorgon on Oct 12, 2009 - 44 answers

Query email format?

Should I maintain double spacing in an agent query email? Submission guidelines ask for the first 5 pages of my manuscript. How faithful should I be to the actual document? [more inside]
posted by bobbyno on Sep 17, 2009 - 4 answers

Movie producers keep asking about my article

Screenplay question. [more inside]
posted by anonymous on Sep 4, 2009 - 11 answers

How to Submit Query to Magazine?

How does one submit a professional query to a national magazine? [more inside]
posted by goalyeehah on Jul 22, 2009 - 5 answers

There's got to be a faster way to update

Please help me simplify a complicated mysql update [more inside]
posted by special-k on Mar 27, 2009 - 19 answers

How do I put a wildcard into the truepart of an IIf statement of an access query criteria?

How do I put a wildcard into the truepart of an IIf statement of an MS Access 2003 query criteria? [more inside]
posted by JeremiahBritt on Feb 11, 2009 - 9 answers

Comparing two similar but non-matching tables in Access?

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

How do I produce an inventory of my data in MySQL?

What kind of MySQL query should I use to inventory this table? Details inside... [more inside]
posted by crapmatic on Dec 10, 2008 - 5 answers

How to safely get an endorsement?

OK, I've posted on this subject before. Each time, I'm a little further along. Here is where I am right now. I've been working on a book since March. The idea upon which the book is based has been getting a lot of attention recently and has consistently been in the news for about four years. [more inside]
posted by CollectiveMind on Dec 8, 2008 - 5 answers

What are some funny "related searches"?

I'm trying to come up with humorous examples of search engines making query suggestions. For example, Google might suggest "how to cook a baby" when you search for "baby". I've seen some posted around the internet before, but can't seem to find them now. Does anyone have such links/examples? They don't have to be currently working examples.
posted by lpctstr; on Nov 29, 2008 - 15 answers

Indexing a SQL table for efficient queries

I have a MySQL table with about 100,000 items in it. Question about setting up indexes for efficient querying. [more inside]
posted by maxwelton on Oct 15, 2008 - 8 answers

Need help with a SQL query

I've got what should be an uber-simple SQL question.... [more inside]
posted by omnipotentq on Jul 7, 2008 - 8 answers

Using the word count (wd) in Gale PowerSearch

Librarians / Researchers / Gale PowerSearch users/developers! How do I use the word count limit successfully? [more inside]
posted by hobbes on May 9, 2008 - 2 answers

SQL and mail merge help needed in Access 2007

I have an Access 2007 database with client information and I need to make it do two relatively simple tasks. [more inside]
posted by desjardins on Apr 11, 2008 - 6 answers

mysql query help please

MySQL question: Given a table with a datetime column and several additional columns which may or may not be null, is there an easy way to select the most recent previous non-null value of each column given a specific date? [more inside]
posted by Nothing on Mar 13, 2008 - 10 answers

Page: 1 2