The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
8 views

Error when trying to SET field in MySQL

I am trying to set the field block, in the table h8cyw_users, to 1 where the email field in both tables are the same. I am using the following script: UPDATE UPDATE table1 SET block='1' WHERE email ...
5
votes
0answers
38 views

Is it possible to give more weight to a keyword while doing a (Google) search? [migrated]

Say I want to search for an error message like The given filter instance must implement one or more of the following filter interfaces but in the context of MiniProfiler. Is it possible to give more ...
2
votes
1answer
5k 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 ...
0
votes
0answers
23 views

Advanced Query Filtering in Access 2010

I am using Access 2010 to log prospective students for a school program. Once these students apply, they need to have a school ID generated (or if they are a current or former student, simply looked ...
1
vote
1answer
4k 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 ...
15
votes
2answers
83k 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 ...
1
vote
2answers
82 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 ...
1
vote
1answer
70 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 ...
0
votes
0answers
34 views

XAMPP seems to be calling the server twice on every request

I have an issue for a site I'm developing. There's a function on this site that has been run to create a team, and it's been working fine for years. After installing XAMPP on a fresh computer, the ...
24
votes
15answers
18k 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 ...
0
votes
0answers
30 views

SQL Server 2012 change query result position [duplicate]

Traditionally in SQL Server while executing a query the result is displayed below the query dividing the screen horizontally. Is there any settings that can be done to displays the result to the side ...
2
votes
1answer
80 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 ...
0
votes
1answer
41 views

OpenLDAP parametrized replication

My problem is relatively simple: 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 ...
1
vote
0answers
20 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 ...
0
votes
0answers
34 views

Query priority .xls VS .mdb

Hello to all the superusers! My new question regarding conflict problem betweend an access application ad a excel wookbook/worksheet I have a worksheet where using "Get External Data" on the "Data" ...
1
vote
0answers
28 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 ...
2
votes
3answers
3k 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 ...
0
votes
0answers
56 views

Querystring Parameter List in Dell Kace Ticketing System

this is related to Dell's KACE Management System, The URL for the new ticket page has a querystring parameter which allows the page to automatically select the correct queue. Take for example the URL ...
0
votes
1answer
55 views

Trouble with DNS query using whois

What does the look them up with "=xxx" to receive a full display for each record mean? The man page does not discuss an equal sign, and I got an error when I tried to use the = literal. $ whois a.com ...
0
votes
1answer
245 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
2answers
907 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 ...
0
votes
0answers
47 views

Web queries have slowed down after updating Excel 2003 to 2010

I built an excel workbook in windows XP. Using excel 2003. I have moved the file to excel 2010 on Windows 7 enterprise. The workbook has about 20 web queries. I had no problems in the earlier ...
0
votes
0answers
151 views

MS Access 2010 Query Linked to a SQL 2008 database do INSERT to table in MS Access file

We have about a dozen inherited Access programs written 10-12 years ago. The author is not here now. We are having to add functionality to the Access code. I have never developed in Access. I am ...
1
vote
1answer
184 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
2answers
894 views

SQL Server Management Studio Express - include date/time in Results or Messages

In SQL Server Management Studio Express 2005 is it possible to output the date and time that a query completed in the Results or Messages windows? (without having to manually add a SELECT Getdate() ...
0
votes
2answers
164 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
0answers
59 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
1answer
680 views

how to query across collections in rockmongo [closed]

If I have a collection of users and a collection of properties which has a user_id in each properties document; how do I get a list of users' and the zip codes (zip` is a field in the 'properties" ...
3
votes
3answers
39k 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 ...
0
votes
1answer
216 views

Query Execution Plan for MySQL

In Microsoft SQL Server you can see Execution Plans for queries to see how a query is executed, what joins take the most time and see any missing indexs now i want to do the same for MySQL scripts ...
0
votes
1answer
233 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. ...
1
vote
1answer
100 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 ...
2
votes
1answer
168 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 ...
0
votes
3answers
773 views

TFS 2010 - Cannot query certain users

We seem to have an issue with out Team Foundation Server 2010 installation that gives an error when certain users are queried. If we include them in the 'AssignedTo' filter the query instantly errors ...
-1
votes
1answer
238 views

Is there a tool or website to generate DNS query packets for looking up the IP address of a hostname?

Is there a tool or web site where I can plug in some values and have it generate the bytes for a DNS query to look up the IP address of a hostname? Preferably one where it explains how the values ...
2
votes
2answers
10k 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 ...
1
vote
1answer
471 views

VB script or command line instruction to query a modem connected to my PC

Is there any vb script to query a modem that is connected to one of the ports of my machine?How can I query my modem from command prompt?
1
vote
1answer
115 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.
0
votes
0answers
120 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, ...
1
vote
2answers
4k 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 ...
3
votes
2answers
2k 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 ...
0
votes
2answers
783 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
1answer
959 views

Simple fixes for improving multi-user MS Access performance?

I'm overhauling the entire IT infrastructure for a small office. They had a Dell T410 doing nothing but serving as a Win2k8 file share, so I figured I could replicate its functionality on an unused ...
1
vote
1answer
167 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 ...
1
vote
0answers
325 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 ...
1
vote
1answer
94 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 ...
2
votes
1answer
5k 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 ...
16
votes
1answer
8k 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?
0
votes
1answer
274 views

Upgrading from built-in Windows 7 32-bit to 64-bit? [duplicate]

Possible Duplicate: Windows 7 and Vista Activation FAQ: How do language, version, 64-bit or 32-bit, and source affect ability to install and transfer Windows licenses? Recently my hard ...
0
votes
1answer
137 views

Does MS Access update the data on the clipboard from a query when the data in the database changes?

I was just debugging a macro in MS Access, and when it hit the breakpoint ran a query and I copied the data from it to the clipboard. Some of the values were null before stepping to the next step, ...