The tag has no usage guidance.

learn more… | top users | synonyms

2
votes
2answers
687 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 ...
2
votes
2answers
708 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 ...
0
votes
2answers
237 views

How to perform sql query on sheets of excel

I have two tables in excel(sheets) . One has 10,000 entries , another has 1000 entries . Both of them have account number column in common . I want to select only those row in 10,000 entries which ...
0
votes
2answers
1k views

Is it possible to put a wildcard search into a parameter query in LibreOffice Base?

I am using Base in LibreOffice 4.0 (still using the HSQL that comes with Base but looking at moving to HSQL 2.2.8) and I would like to do a query that asks for parameter input like: SELECT * FROM "...
0
votes
2answers
1k views

Return cell reference as result of if statement with vlookups

I have two sets of data in excel. One contains a set of data which represents the initial step of a process. The other set of data represents the additional steps which take place after the first ...
4
votes
1answer
47 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 ...
1
vote
1answer
30 views

MS SQL query which split to other table columns

I have two table: table1: |Manager | USER | +--------+------+ |John | Tom | |John | David| |John | Marry| |James | Henry| table2: Now is empty, but must be like: |Manager|User1|User2|...
1
vote
1answer
308 views

Microsoft Access 2013 - Search for one word in multiple columns at the same time

Is it possible to search in multiple columns for the same word and get every row (no matter in which column the word stands) as a result? For example: I have a database consisting of 5 columns and ...
1
vote
1answer
315 views

Is there a way to change the query a report uses in Libreoffice Base or better yet to select the query at the time a report is run?

I have a standard set of data that I always want out of a report, however it could be based on a query of any of the values. Is it possible to set it up so I double click on a report and it would let ...
1
vote
1answer
194 views

Exporting an SC query result to Excel

I wrote an SC query to show all the services and their state and I can easily display it in a text file. What I want to do is list all this data directly to an Excel worksheet. How / is this ...
0
votes
1answer
168 views

XML query of event log not working

I have been looking for a query to act as a trigger in the Task Scheduler. I want to restart my VPN if it RASClient ends (EventID 20226) for any reason except code 631 (The port was closed by the user)...
0
votes
1answer
62 views

OpenLDAP parametrized replication of a subset

I have a huge LDAP database and I'd like to make a replica that contains only a subset of that database. My objective is to replicate a few groups, and all members within that group. So far, I'm ...
0
votes
1answer
405 views

MS Access 2007 - Update query won't update

I have a Access 2007 database that I wish to be able to click a button and update Null values in a table column with the current date when the button is clicked. For some reason it just won't update. ...
0
votes
1answer
360 views

Using SQL to join spreadsheets in excel

Based on the explanation here: How do I join two worksheets in Excel as I would in SQL? I tried to join two excel sheets from different files into the same sheet. However, I keep getting this error ...
0
votes
1answer
40 views

Managing records of bugs and notes

I want to create a knowledgebase for a piece of software. I'd also like to be able to track bugs and common points of failure in that application. Linking knowledgebase articles to bug records would ...
2
votes
0answers
46 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 ...
2
votes
0answers
55 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 ...
1
vote
0answers
23 views

Excel 2013 Power Query

Does anyone know how to extract all Active Directory Users and show which ones are Users and which ones are just Contacts. I've extracted both Users and Contacts but they seem to show the same in ...
1
vote
0answers
25 views

excel 2007 MS Query

I have created a spread sheet using MS query. I have added several columns to the rows of data so there can be some manually entered notes at the end of each row. The problem is when I refresh the ...
1
vote
0answers
41 views

Microsoft Access database worked before and now old records won't update

This code was working fine on Windows 2003 Server. Updated to Windows 2008 Server and now new records can be listed for update or delete but old records can only list record content, but can't be ...
1
vote
0answers
402 views

Change date in a SQL query to reference a cell in Excel

I have the following code that returns the needed data into excel and manually changing the date will change the returned data; however, I'd like to reference a cell with a formula that will make the ...
0
votes
0answers
23 views

How to tell if multiple sites contain a keyword

I have a list of 9k web addresses, and a couple of keywords. I would like to know if a webpage contains that word. Ideally, automated google search with some search operators would work great, for ...
0
votes
0answers
17 views

How to Create a Query which Combines Two Crosstab Queries under a Split, Merged Column

Sorry if the title is a little confusing. I am attempting to create a query which takes two cross-tab queries and combines them in a slightly different format than the original cross-tabs. I have used ...
0
votes
0answers
7 views

excel vs access query priority

Hi Superuser this is my question Scenario: -an Access 2003 based application to manage the stock; the application had several mask to peform the update of different .mdb table. -an Excel 2003 ...
0
votes
0answers
13 views

Query optimization in Data stream

I am confused about the idea of query optimization in stream of data. As a background, I know that optimization for any query is happening inside the DBMS with using of system catalogs which contain ...
0
votes
0answers
35 views

Web Query with login details

I want to create a web query with that will add info like (Account used, username (emails), password) I created a web query already. Please find below the code. My problem is the fact that I have 5 ...
0
votes
0answers
15 views

Dynamic Web query in excel

What i need to have is an excel that can take data from a certain website based on the info i write to a cell in that excel. to be more clear, in the website "Gcmap" when i search "jfk-lax" it gives ...
0
votes
0answers
63 views

how do i filter by a rolling date range from a sql query

I am trying to filter a query by a date range, but a moving date range. I have heard (read on this site) that this can be handled in a formula in excel, but I couldn't really follow the formula that ...
0
votes
0answers
12 views

Running SPARQL queries via Atom

Using Sublime SPARQL Runner is possible to directly run SPARQL queries. I'm looking to fin a similar solution for Atom. I see that there is some interest in this as the language-sparql provides some ...
0
votes
0answers
57 views

The query could not be processed: File system error: An error occurred while opening the 'File Path\file_name.cub' local cube file

Please Help Me !! What happen and how to fix it ? It occurred when I open Pivot Table in Access 2010. (My OS is Windows 10) File Path\file_name.cub is always changed every time database is opened. Now ...
0
votes
0answers
61 views

How to share Power Query queries

I was looking for a way to share Power Query queries. I am not sure on how to share query in the intranet. Seems like sharing in Power Query Data Catalog is named "Power BI Data Catalog". This is ...
0
votes
0answers
18 views

MySQL Query to Find Distinct Instance of Status

My question is regarding a MySQL query that I am trying to write. I have written some psuedo-code to help illustrate what query I am trying to write: SELECT * FROM persons AS p INNER JOIN ...
0
votes
0answers
34 views

Alternative option for select * from

In the Excel database query we will use the below syntax to define a reference value SELECT * FROM [Sheet1$A1:Z500] where Dept = 'IT' In the above case I am taking the Dept value IT as a reference ...
0
votes
0answers
19 views

Query Concatenation

I need to concatenate 5 fields together. Now the problem is field field2 could have data but not field1 which gives me a headache of extra white space at the beginning and an un-necessary comma if I ...
0
votes
0answers
70 views

How to get Access 2010 query to number based on criteria from other columns

I have a query where it pulls the ID and Employee columns and I am trying to get Access to populate the data as shown in the 'OrderCol1' and 'OrderCol2' columns of the table below. As I'm sure you ...
0
votes
0answers
144 views

Network goes “Request Timed Out” when I run a query

I use postgreSQL 9.2 as the database and Java 6 as the programming language. There is no problem when I run my program on the server computer. But when I run my program from a remote client, ...
0
votes
0answers
510 views

Microsoft Query Wizard specify Column Filter that is greater than or equal to 30 days from today

I'd like to use Microsoft Query Wizard specify Column Filter that is greater than or equal to 30 days from today. Is there reserved name that I can use, like TODAY-30 under the filter criteria?