Search Results

Search found 23568 results on 943 pages for 'select'.

Page 27/943 | < Previous Page | 23 24 25 26 27 28 29 30 31 32 33 34  | Next Page >

• SELECT SQL Variable - should i avoid using this syntax and always use SET?

  - by Sholom

  Hi All, This may look like a duplicate to here, but it's not. I am trying to get a best practice, not a technical answer (which i already (think) i know). New to SQL Server and trying to form good habits. I found a great explanation of the functional differences between SET @var = and SELECT @var = here: …

  Read the article

• Converting a list into a select with jquery

  - by Davemof

  I'm trying to convert the following list into a select list so it can be submitted via a form - the element within the lists will become the value of each option: <ul class="selected connected-list ui-sortable" style="height: 279px;"> <li class="ui-helper-hidden-accessible" style=""></li>…

  Read the article

• Is there a Windows equivalent for eventfd?

  - by Leaurus

  I am writing a cross-platform library which emulates sockets behaviour, having additional functionality in the between (App-mylib-sockets). I want it to be the most transparent possible for the programmer, so primitives like select and poll must work with accordingly with this lib. The problem is when…

  Read the article

• WatiN SelectList Methods - Page not refreshing/actions not being fired after interacting with a sele

  - by Chad M

  Preface: If you don't care about the preface, skip down to the section marked "Question." Hi, Recently my company has upgraded to the latest version of WatiN for its test automation framework. We upgraded to avoid a problem where interacting with a select list would cause an ACCSES DENIED error. This…

  Read the article

• Named pipe is not flushing in Python

  - by BrainCore

  I have a named pipe created via the os.mkfifo() command. I have two different Python processes accessing this named pipe, process A is reading, and process B is writing. Process A uses the select function to determine when there is data available in the fifo/pipe. Despite the fact that process B flushes…

  Read the article

• Sqlite: Selecting records spread over total records

  - by Martin

  I have a sql / sqlite question. I need to write a query that select some values from a sqlite database table. I always want the maximal returned records to be 20. If the total selected records are more than 20 I need to select 20 records that are spread over the total records. It is also important that…

  Read the article

• Limiting selected rows count with a stored procedure parameter in MySQL

  - by ssobczak

  I have a procedure SelectProc wich contains SELECT statement. I want to add a procedure param LimitRowsCount and use it as following: CREATE PROCEDURE SelectProc (IN LimitRowsCount INTEGER UNSIGNED) BEGIN SELECT (...) LIMIT LimitRowsCount; END but this approach doesn't work. The SELECT…

  Read the article

• Scroll up/down while selecting multi-page block of text in Vim through putty

  - by shan23

  I'm using vim 6.3.81 on a xterm through putty. When I use set mouse=a , I can scroll through the file , but not select text. When mouse is disabled using set mouse=, I can select text with mouse (automatically copied to a buffer) , but if the text block is over one page long , I can't scroll…

  Read the article

• SQL join different tables depending on row information

  - by Xster

  Hi, I think this question hasn't be asked yet. Suppose I have table A with a field that can be either 1 or 2 How do I select such that for each row in table A, if the field is 1, join the select with table B and if the field is 2, join the select with table C?

  Read the article

• Selecting a radio button when a dropdown value changes

  - by Tim F.

  My setup is something like this: radiobutton1 - selection1 radiobutton2 - selection2 textinput1 I want radiobutton1 to be selected whenever selection1 is changed, and I want radiobutton2 to be selected whenever either selection2 or textinput1 is changed. There has to be a simple…

  Read the article

• COUNT(*) vs. COUNT(1) vs. COUNT(pk): which is better?

  - by zneak

  Hello guys, I often find these three variants: SELECT COUNT(*) FROM Foo; SELECT COUNT(1) FROM Foo; SELECT COUNT(PrimaryKey) FROM Foo; As far as I can see, they all do the same thing, and I find myself using the three in my codebase. However, I don't like to do the same thing…

  Read the article

• How do I execute SQL_CALC_FOUND_ROWS in python MySQLDB

  - by alex

  cursor.execute("SELECT SQL_CALC_FOUND_ROWS user_id FROM...limit 5") rows = cursor.fetchall() ... total_rows = cursor.execute("SELECT FOUND_ROWS()") #this doesn't work for some reason. Edit: I tried SELECT FOUND_ROWS() FROM my_table...and the numbers are funky.

  Read the article

• Insert into Table from #tempTable fails

  - by AJ

  I am simply taking the data from a Table and insert it into #tempTable then delete the data, and insert it back to the table. I get "Insert Error: Column name or number of supplied values does not match table definition." Error. Here are the lines I am running. SELECT * INTO…

  Read the article

• assigning selected="selected" to dynamic option list

  - by leemjac

  In an "edit article" page i have a select list which displays author first and last name, as well as authorId as the value. As well as the article context and headline and so on (fetched with a different method) - though this method also holds the authorId of the specific…

  Read the article

• mySQL query: How to insert with UNION?

  - by Industrial

  Hi everybody, I am kind of new to mySQL:s union functions, at least when doing inserts with them. I have gotten the following to work based upon a example found on the net: INSERT INTO tableOne(a, b) SELECT a, $var FROM tableOne WHERE b = $var2 UNION ALL SELECT…

  Read the article

• jQuery success:function{} issue

  - by ufw

  I have several 'select' elements on the page. When I choose some of options, the ajax request is being sent to server and the element adjacent to this 'select' must be updated with response value. I expected the following code to be working: …

  Read the article

• Use of where in multiple joins to remove rows - linq

  - by bergin

  hi, I have a table of orders. the status is on the soilorders which is joined to the orders. I only want to return orders where the joined soilorder does not have status "Removed". I had thought that join sso in db.SoilSamplingOrders…

  Read the article

• Need Help Writing SQL query

  - by user204588

  I have two product tables Product1 and Product2. There is a one 2 one mapping on the field ProductId. What I want is to get all the product ids where the Product2.Exported field is false AND Where the product ids that are in Product1 but…

  Read the article

• SQL SERVER – Disabled Index and Update Statistics

  - by pinaldave

  When we try to update the statistics, it throws an error as if the clustered index is disabled. Now let us enable the clustered index only and attempt to update the statistics of the table right after that. Have you ever come across the…

  Read the article

• Whether to use UNION or OR in SQL Server Queries

  - by Dinesh Asanka

  Recently I came across with an article on DB2 about using Union instead of OR. So I thought of carrying out a research on SQL Server on what scenarios UNION is optimal in and which scenarios OR would be best. I will analyze this with a…

  Read the article

• How to change the language of driver interface for Canon Pixma printers?

  - by Sammy

  Is there a way to change the language of the driver interface for Canon Pixma printers? Which language is used seems to be determined by the language of the OS or the Windows localization settings. I really don't want that, I want to…

  Read the article

• select a diagonal area in paint.net

  - by Toc

  In Paint.net, is it possible to select a quadrilateral area with diagonal faces? How?

  Read the article

• XKB - remap arrow keys and preserve shift behaviour to select text

  - by dgirardi

  I realize arrow key remapping is an old problem, however I cannot seem to find a good solution that lets me select text with SHIFT + remapped keys as I would do with the vanilla arrow keys. For instance, if I remap Caps Lock to…

  Read the article

• Unable to drag and drop / select multiple with mouse

  - by J. Scott Elblein

  I'm running into a perplexing issue with Windows 8 Pro x64, where randomly I'm unable to drag to select multiple files (i.e. in Explorer or Directory Opus). I've also noticed that a similar issue happens when I'm running for…

  Read the article

• select and edit row in the gridview from xmlhttp request object

  - by user27740

  Can anyone tell me, How to select and edit row the gridview by using the xmlhttp object not by using the ajax updatepanel

  Read the article

< Previous Page | 23 24 25 26 27 28 29 30 31 32 33 34  | Next Page >