Questions tagged [query]
159 questions
60
votes
1 answer
Does an anchor tag come before the query string or after?
I am unclear if an anchor tag should come before a query string or after.
http://www.domain.com/search?query=hello#name
or
http://www.domain.com/search#name?query=hello
Or does it matter?
whoacowboy
- 821
33
votes
21 answers
Querying a CSV file
Does anyone know of a simple tool that will open up a CSV file and let you do basic, SQLesque queries on it? Like a graphical tool of sorts, one that is easy to use.
I know I could write a small script to do an import of the CSV into a SQLite…
J. Polfer
- 2,342
22
votes
3 answers
Run an SQL Query With a Parameter from Excel 2007
I have a query in an Excel table. I followed this to do it.
But how can I add a parameter from a cell into my query?
I am looking for a way to do this:
select *
from dbo.Customers
where CustomerID = Cell.A2
The Cell.A2 does not work. But how can I…
Vaccano
- 6,806
10
votes
1 answer
understanding bind9 query log
I'm running two bind servers a activated query logging but don't know what exactly i see here and not finding anything on the web which enlightens me;
31-Oct-2017 17:56:35.464 queries: client x.x.x.x#55638: query: test.example.com IN A +
31-Oct-2017…
screenie
- 103
7
votes
1 answer
Get RSS feed from Youtube playlist in reverse order
I subscribe to a few Youtube channels and playlists via RSS. To get the RSS feed of a playlist, (e.g. Crash Course Philosophy), we get the playlists’ URL, and replace everything but the ID with a specific URL. In this case,…
user137369
- 1,080
6
votes
1 answer
Query parameters in an external connection to sql server
I want to do exactly this: http://dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/ but I want to do it in Excel 2010 and also I am querying SQL Server instead of MS Access. Is it possible?
To elaborate on what I…
Dan
- 252
5
votes
1 answer
Issues sending Latin accented characters (ã,õ,á,é,í,…) to a database table in PHP/MySQL
I am having problems making mydatabase table show Latin caracters. (ã,õ,á,é,í,…). I am using WAMP server with Apache 2.4.9 and MySQL 5.6.17.
I have a simple form that I created in HTML and I have a PHP code witch runs a query and creates the…
João Luís
- 81
5
votes
2 answers
Only return state of a service when using sc.exe query
When using the following command to return information about a service to a file :
sc.exe query MyService >> MyFileLocation\MyFile.txt
I get the following information in the file :
SERVICE_NAME: MyService
TYPE : 10 …
Niek Jonkman
- 195
- 1
- 3
- 8
5
votes
1 answer
How to combine the output of two queries in MYSQL when they have non-compatible conditions
I'm looking for some assistance in adding together the output of the two following queries. They have two incompatible conditions so I'm struggling to combine them in the one query.
Total Revenue Year to Date
How to combine the output of both…
NiallBC
- 51
- 1
4
votes
2 answers
Pass parameter from Excel to Access query
I have a Access (2010 but I've also tried Office 2003) database with a lot of tables, forms and nested queries which rely on data entered in a form, e.g. WHERE query1.year=[Forms]![Form1]![Text0];. I now want to link such a query to Excel as…
4
votes
4 answers
How to get query command on Windows 10
I have a Windows 10 computer on which I need to see what users are logged in via an SSH connection (which is the command prompt). I figured I could run query user on the machine, but the query command is not installed. Where can I get it? To…
Mark Deven
- 1,769
3
votes
0 answers
foobar2000: query if specific files exist in track's directory
In my library there are files like .lrc files (Lyrics) or album art files (various .jpg files) next to the music files:
I am trying to create a autoplaylist where I want to list tracks which have a fitting .lrc file inside the same folder (like…
Herr_Schwabullek
- 455
3
votes
3 answers
Merge multiple columns into one via a query in an access database
i need to write a query that combines multiple columns of text.
my database is a database of wallpapers on my computer (i use john's background switcher), so i can easily find them and have them categorized.
each record has 4 character fields (i…
crazybmanp
- 139
3
votes
2 answers
Foobar2000: any way to query whether a song is in a specific playlist?
In Foobar2000, I would like to make an autoplaylist that only shows songs that are not currently in another specific (manual) playlist.
Is there any way to query for this?
I imagine the query to look something like:
%rating% GREATER 3 AND NOT IN…
oKtosiTe
- 9,776
3
votes
1 answer
How do I get Excel to run a query for each row in a spreadsheet?
Is there a way to run an MS Query for each row in a spreadsheet? For example, I have a sheet that looks like this:
CustomerID
111
222
333
I have the customer's address in a database, and I'd like to annotate each row in the sheet with the…
Chris Curvey
- 1,537