Questions tagged [query]
The query tag has no usage guidance.
160
questions
59
votes
1
answer
41k
views
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?
- 811
33
votes
21
answers
48k
views
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 ...
- 2,342
22
votes
3
answers
159k
views
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 ...
- 6,726
9
votes
1
answer
18k
views
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#...
- 93
7
votes
1
answer
3k
views
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 ...
- 1,072
6
votes
1
answer
48k
views
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 ...
- 252
5
votes
2
answers
5k
views
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:...
- 195
5
votes
1
answer
17k
views
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 ...
- 81
4
votes
4
answers
13k
views
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 ...
- 1,660
4
votes
2
answers
10k
views
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 ...
4
votes
1
answer
68
views
How to combine the output of two querys 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 ...
- 41
3
votes
3
answers
103k
views
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 ...
- 139
3
votes
2
answers
4k
views
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 ...
- 9,596
3
votes
1
answer
6k
views
Convert DateTime with Decimal Time Longer Than 3 digits?
I'm trying to import some data from CSV into MS SQL 2008 Server. I'm using PowerShell's Invoke-SQL, and an SQL script that utilizes BULK INSERT.
CSV fields get imported as VarChars and I'm trying to ...
- 113k
3
votes
1
answer
2k
views
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 ...
- 1,437
3
votes
0
answers
3k
views
What is the priority order mechanism of dns client configuration in windows?
I wonder what is the order of dns query in windows?
for example, suppose I have two dns server configured with different DNS Index.
to quote what is DNS Index
A lower number for the DNSIndex ...
- 481
3
votes
0
answers
415
views
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 ...
- 455
2
votes
1
answer
7k
views
How do you create a SQL query in Excel 2007 with a dynamic date range?
I am trying to create a reporting spreadsheet that can print reports for a given time period. The query below works, but when I try to use a ? parameter in place of the date, I get an error after ...
- 21
2
votes
4
answers
5k
views
Querying against Active Directory
I'm the "script guy" at my work, which is a blessing and a curse... I've been tasked with generating a script of:
Can you create a script to pull all users that have a proxy address
that is not ...
- 4,343
2
votes
2
answers
28k
views
Pass a cell contents as a parameter to an excel query in Excel 2007
I have tried really hard to solve this issue but I think I am going to need a little help. I can program in different languages but I don't have any experience with Excel, VBA or the queries you can ...
- 121
2
votes
1
answer
2k
views
Outer join with union in Excel 2010 using Power Query
I've got two tables (two worksheets of the same workbook in Excel 2010):
The result should look like this:
My SQL code works well:
SELECT table_2.ID, table_1.value_1, table_2.value_2 FROM table_1 ...
- 131
2
votes
2
answers
3k
views
Where is a Web Query stored in an excel file?
I have a Web Query looking at a site for data, and it gets the table selection wrong. Viewing source of the linked to web page I am able to identify the correct table.
In an Excel Web Query you are ...
- 3,470
2
votes
1
answer
74
views
How to execute remote mysql query after granting permission?
I am trying to execute mysql query from another ubuntu system.
I have granted permission to user using GRANT from 192.168.64.9
GRANT ALL ON . to 'user'@'192.168.64.11' WITH GRANT OPTION;
and then ...
2
votes
1
answer
6k
views
Embed microsoft query in excel with multiple parameters from spreadsheet
I am trying to embed a microsoft query within an excel spreadsheet, that passes several parameters from the spreadsheet to the query. I would like the microsoft excel query function to find a few ...
- 21
2
votes
0
answers
164
views
How to paste multiple entries to a query?
How to do you paste multiple entries to a query in design view? I can only paste one value at a time, and I need to add multiple values.
Is there a way of doing an Advanced Filter in Microsoft ...
- 21
2
votes
1
answer
221
views
How to pick rows in MS SQL based on column values?
I want to pick SourceId & Currency based on Count value. Problem is within a set I've to ignore all data where Count = 0 if there is any value greater than 0 but if all the counts are 0 within a ...
- 21
2
votes
1
answer
513
views
CSV filename bug concerning dots in Microsoft Query (via Office Excel 2013)?
After hours of struggling it looks like I've found a bug regarding csv file processing by Microsoft Query via Office Excel 2013.
I'm trying to generate a Chart from csv data. Every hour a new record ...
- 31
2
votes
2
answers
1k
views
Matching similar records in a database with Group By
I have a database in which there are company names each matched with the company post code. However there are duplicates since the company names are written multiple ways, like this:
Company Name ...
- 21
1
vote
1
answer
530
views
Query dpkg for All Packages Installed/Removed from Default Image
Is there any way to query dpkg to tell what packages have been added/removed since the base install of a system?
I am running Debian 5.
- 4,039
1
vote
2
answers
5k
views
Can I run a low priority query on MySQL?
I have a MySQL table with 3GB data and the ALTER TABLE to create a new field lasts about 15 minutes in pre-production.
The software can both do read- and write-queries with the new field or without ...
- 603
1
vote
1
answer
64k
views
Access Query for Positive Checkboxes
I have a table which contains personal information of our staff, at the end of the table there are checkboxes for general training (medical, military, health and safety) etc.
Say for example i wanted ...
- 19
1
vote
1
answer
2k
views
Microsoft Access: Query to delete duplicate data but keep most recent
To my surprise, I've been having trouble finding an answer to this question for my specific case.
I have a table with ID and date and I would like to keep only one ID, and that is the most recent one.
...
1
vote
1
answer
2k
views
excluding certain file extensions in Windows search
I'm trying to search for a certain file extension, .pro. I have tried the following searches in the search bars: type:.pro and *.pro, however, both of these queries yield files with the extension ....
- 843
1
vote
1
answer
4k
views
Automating Access 2007 Queries (changing one criteria)
So, I have 6 queries and I want to run them all once at the end of each month. (I know a bit about SQL but they're simply built using Access's design view). So, in the next few days, perhaps I'll ...
- 321
1
vote
2
answers
7k
views
Access 2007 create report from query
Where is my Query??? I'm using Access 2007, until this version I would create a query then create a report based in that query, using create-blank report. If I use the report wizard it does give me ...
- 59
1
vote
1
answer
168
views
How to find matching yaml files based on content
I have a bunch of files that contain yaml. Some files are yaml-only, some have yaml front-matter. I would like to be able to query the list of files to return a list that match certain criteria. In ...
- 113
1
vote
2
answers
2k
views
Select statement using 'EXISTS' and 'IN' operator
I hit an issue to get data using 'IN' operator from another database. I need help fixing this please.
My query looks like this:
SELECT i.EXTERNAL_CODE, tc.SITE_NAME, tr.TRANSACTION_DT
FROM ...
- 653
1
vote
1
answer
781
views
Is "fsutil behavior query mftzone" for all partitions in Windows 8.1 64-bit?
I have 2 HDDs and 5 partitions in them, and I can't find this question answered on DuckDuckGo, Google nor Microsoft; the command doesn't allow to specify a drive letter, so I suppose is for all ...
- 21
1
vote
1
answer
105
views
Monitoring blocked requests in varnish
I set up a blacklist in varnish where a bunch of IPs that I suspect for malicious intentions are blocked.
I'm trying now to see if there's a way to monitor if any of these IPs made any request and if ...
- 11
1
vote
1
answer
342
views
How come this query shows the same address for non-authoritative answers and authoritative answers?
So, if i query slash16.org:
nslookup -type=ns slash16.org
Non-authoritative answer:
slash16.org nameserver = ns-686.awsdns-21.net.
slash16.org nameserver = ns-1989.awsdns-56.co.uk.
slash16.org ...
- 25
1
vote
2
answers
267
views
Excel: show list of values based on query in range
I have a table like this:
a | tomato
b | pear
c | tomato
d | pear
I would like to create a formula that lets me select which rows contain tomato and which ones contain pear. ...
- 11
1
vote
1
answer
7k
views
How to get data from web using Cell values to assemble URL to pull from? Getting Data from web using cell references
How to get data from web using Cell values to assemble URL to pull from?
How do I go about using cell references to assemble a URL that excel can use to get data from the web with? Basically I'm ...
- 113
1
vote
1
answer
2k
views
using sql query in excel showing columns in the right order
I am currently using a sql query in excel so the users can get the results by refreshing the worksheet.
The results are getting displayed but the columns are in different order than what they ...
- 31
1
vote
1
answer
2k
views
How to simplify Excel/Google Sheets formula with redundant method calls?
I have an Excel (Well, technically Google Sheets) workbook containing product inventory warehouse storage information. I figured out how to construct queries so it grabs the needed information from ...
- 21
1
vote
2
answers
5k
views
Query for false values in Access not working
I'm trying to create a simple database to keep track of paperwork as it's turned in. In the form and table I've used yes/no check boxes, checking them when a paper is turned in.
What I want to do is ...
- 11
1
vote
1
answer
708
views
How to create a MS Access query to show a data in columns by criteria?
I have a little problem with MS Access 2013. I cannot figure out how to create a query to show needed data in one table. The data structure can be illustrated with the following:
USERS
ID Name
001 ...
- 133
1
vote
1
answer
248
views
Configure DNS Rules for Hosts and Proxy?
I'm not sure if I'm approaching this problem correctly, so please correct me here.
Suppose an organization runs its own DNS service. The organization wants the following:
DNS queries by all hosts ...
- 12.2k
1
vote
1
answer
609
views
Filtering field on view - Lotus 8.5
I have one view with field that I called "Date".
I can´t filter the results for one date...
please help me.
- 11
1
vote
1
answer
110
views
excel / open office - append an incrementing value to all non-unique fields
I have a large table of about 7500 store names. I need to search through those names and, if they are not unique, append an incrementing value, for example:
store_1
store_2
etc.
Anyone know how to ...
- 237
1
vote
1
answer
2k
views
Query data in Powerpoint
I would like to build an MS PowerPoint 2010 presentation where some of the displayed data would be queried from an external source (I am flexible - the simpler the better, I need to update that ...
- 3,253