Search Results

Search found 33538 results on 1342 pages for 'select query'.

Page 169/1342 | < Previous Page | 165 166 167 168 169 170 171 172 173 174 175 176  | Next Page >

• What is wrong with using SELECT * FROM sometable

  - by Ankur

  I have read the using "SELECT * FROM sometable" is bad practice, esp. if the query is being sent over a network. Specifically what is wrong with it?

  Read the article

• jquery select by two condition

  - by sunglim

  I like to select an element by more than two condition. for example name is some name and checked how can I do this?

  Read the article

• How to select item in jComboBox

  - by jtnire

  Hi folks, I have a jComboBox that I am populating with some objects. The objects are of a type which I have made myself, and include a String and an int. The object's toString method returns the String, which is displayed in the Combo Box. Now, I wish to select an item in the Combo Box with code. How do I do this? There are multiple items starting with the same letter Thanks

  Read the article

• How to Select two values from one value

  - by Jacob Seleznev

  I want to do something like this: foreach (Customer c in customers) { yield return c.Name; yield return "0"; } I started: customers.Select(c => new { c.Name, Second = "0" }).??? But then what?

  Read the article

• Rails select helper - Default selected value, how?

  - by totocaster

  Here a code I'm using now. <%= f.select :project_id, @project_select %> How to modify it to make it it's default value params[:pid] when page is loaded?

  Read the article

• select distinct col1 with min(col2) and max(col3) from table

  - by user338804

  My table looks like this with duplicates in col1 col1, col2, col3, col4 1, 1, 0, a 1, 2, 1, a 1, 3, 1, a 2, 4, 1, b 3, 5, 0, c I want to select distinct col1 with max (col3) and min(col2); so result set will be: col1, col2, col3, col4 1, 2, 1, a 2, 4, 1, b 3, 5, 0, c I have a solution but looking for best ideas?

  Read the article

• select top 50 records from sql

  - by air

  i have following database table name tbl_rec recno uid uname points ============================ 1 a abc 10 2 b bac 8 3 c cvb 12 4 d aty 13 5 f cyu 9 ------------------------- ------------------------- i have about 5000 records in this table. i want to select first 50 higher points records. i can't use limit statement as i am already using limit for paging. Thanks

  Read the article

• Not able to select a row in my ListView

  - by Krishna Thota

  I'm not able to select a row in my list Item Here is my code <Grid DockPanel.Dock="Left" MinWidth="250"> <ListView x:Name="ListVendors" ItemsSource="{Binding SourceCollection}"> <ListView.View> <GridView> <GridView.ColumnHeaderContainerStyle> <Style><Setter Property="FrameworkElement.Visibility" Value="Collapsed"/></Style> </GridView.ColumnHeaderContainerStyle> <GridViewColumn> <GridViewColumn.CellTemplate> <DataTemplate> <Grid> <Grid.RowDefinitions> <RowDefinition /> <RowDefinition /> <RowDefinition /> </Grid.RowDefinitions> <TextBlock Grid.Row="0" Text="{Binding Name}" FontSize="20"/> <TextBlock Grid.Row="1" Text="{Binding Code}" Foreground="Gray" /> <TextBlock Grid.Row="2" Text="{Binding ContactNo}" Foreground="Gray" /> </Grid> </DataTemplate> </GridViewColumn.CellTemplate> </GridViewColumn> <GridViewColumn> <GridViewColumn.CellTemplate> <DataTemplate> <Grid> <Grid.RowDefinitions> <RowDefinition /> </Grid.RowDefinitions> <TextBlock Grid.Row="0" Text="{Binding Path=Address, Converter={StaticResource addNewLineConv}}" Grid.RowSpan="3" /> </Grid> </DataTemplate> </GridViewColumn.CellTemplate> </GridViewColumn> <GridViewColumn> <GridViewColumn.CellTemplate> <DataTemplate> <Grid> <Grid.RowDefinitions> <RowDefinition /> </Grid.RowDefinitions> <TextBlock Grid.Row="2" Text="{Binding Email}"/> </Grid> </DataTemplate> </GridViewColumn.CellTemplate> </GridViewColumn> <GridViewColumn DisplayMemberBinding="{Binding Email}" Header="Email"/> </GridView> </ListView.View> </ListView> How can I select a row in this ListView?

  Read the article

• Style / Replace a select box using prototype / scriptactulous

  - by Elliot

  Hey everyone, I'm trying to style my select box, I assume I need some type of javascript method. I'm using rails - and sticking with prototype/scriptactulous. Does anyone know of any solutions?

  Read the article

• double click and select the path(including '/') in Terminal.app

  - by mash

  I'm using Terminal.app on Mac OS10.6.3, with gnu screen and zsh. What I want to do is, see pwd(or an URL) in Terminal.app and double click on it, and select the whole path, to copy and paste after that. But what I get now is a single directory name, because '/' is not treated as a word. I found that iTerm has a setting to change it(iTerm - Preferences - Mouse - Characters considered part of a word), but is there any way to do this on my environment?

  Read the article

• how to add a "Please select" to a dropdown box

  - by oo

  i have the following code in an asp.net mvc view. <% = Html.DropDownList("Filter", new SelectList(Model.Items, "Id", "Name", 0), new { @id = "Filter", @class = "autoComplete1" })%> i want to add an element at the top of the dropdown as the first item that says, "Please select". do i have to add that into my Model.Items or is there a way i can add that element into the view and ignore the selection of that first element ??

  Read the article

• How do I select top ranker by date in MySQL

  - by mathew

  I do have a user data base with rank.what I am looking is how do I select top rank person based on today's search?? and I need to do this in daily basis.

  Read the article

• Select count() max() Date HELP!!! mysql oracle

  - by DAVID

  Hi guys i have a table with shifts history along with emp ids im using this code to retrieve a list of employees and their total shifts by specifying the range to count from: SELECT ope_id, count(ope_id) FROM operator_shift WHERE ope_shift_date >=to_date( '01-MAR-10','dd-mon-yy') and ope_shift_date <= to_date('31-MAR-10','dd-mon-yy') GROUP BY OPE_ID which gives OPE_ID COUNT(OPE_ID) 1 14 2 7 3 6 4 6 5 2 6 5 7 2 8 1 9 2 10 4 10 rows selected. NOW how do i choose the employee with the highest no of shifts under the specified range date, please this is really important

  Read the article

• Using NHibernate Criteria API to select all entities of exact class, but not derived from it

  - by SergeanT

  I have two classes: Cat and DomesticCat, that extends Cat. I want to select all Cats, but no oneDomesticCat. How to do it using NHibernate criteria API?

  Read the article

• Create select based on routing, how?

  - by huug

  I am trying to implement navigation like in Tree Based Navigation but based on url's defined in routes.rb (named routes, resources, ...). Is it possible to retreive a collection of all routes defined in routes.rb? So I can use it in a select like this: <%= f.collection_select :url, Route.all, :url, :name %> Tnx!

  Read the article

• how to select * from tableA where columnA values don't start with letter 'F'

  - by subash

  Can I have a SQL query to get the data from columna in tableA whose values don't start with 'f' ? For example: select * from tableA where columnA where values don't start with letter 'F'.

  Read the article

• Optimize SELECT DISTINCT CONCAT query in MySQL

  - by L. Cosio

  Hello! I'm running this query: SELECT DISTINCT CONCAT(ALFA_CLAVE, FECHA_NACI) FROM listado GROUP BY ALFA_CLAVE HAVING count(CONCAT(ALFA_CLAVE, FECHA_NACI)) > 1 Is there any way to optimize it? Queries are taking 2-3 hours on a table with 850,000 rows. Adding an index to ALFA_CLAVE and FECHA_NACI would work? Thanks in advanced

  Read the article

• Select 5, 10, 15, 20 and so on with LINQ

  - by Johan Leino

  Hey guys, I want to display items in a dropdownlist like 5%, 10%, 15%, 20% until 100. Is there a way to bind an intelligent LINQ query to the datasource that will do this for me?

  Read the article

• Javascript Event for Select element Selection

  - by JP

  Hi everyone, I'm looking to find the Javascript Event I need to put into jQuery's .bind function in order to have the function triggered when a selection is made from a <select> element. At the moment I'm using .bind('change',function() { ...}) but I need the event to trigger when the selected option is chosen again. Any suggestions?

  Read the article

• JQuery - click trigger on select box doesn't work?

  - by sasa

  Does anybody know how dropdown list can be opened with trigger? Here is code which doesn't work: $('select').trigger('click'); Just for note - mousedown and mouseup also doesn't work.

  Read the article

• Using jQuery to Highlight (Select) All Text in a Textbox

  - by Spyros

  I have an input text box with some text in it , onclick event I want to run a javascript function to select (highlight) all text that is in this box , how I can do that with jquery?

  Read the article

• Dropdown list allow multi-select in sharepoint

  - by HieuNT

  Hi, I have a trouble that : I have to implement a webpart contain a Field that look up into other list. But the requirement that it must allow multi-value, and multi-select as a dropdown-list. Pls, help me :(

  Read the article

• Database select * for a Noob

  - by Kevin Brown

  I've heard that it's bad to select all the fields in a database. Is this true, and if so, why?

  Read the article

• Rails select helper. How do I select the default value?

  - by Ram

  In Rails erb, am using the snippet to show visiting team in a tournament match. How do I get to initially show the current visiting_team? What am I doing wrong? <%= f.select(:visiting_team_id, Team.all.collect{|t| [t.name, t.id] }) %>

  Read the article

• onchange event from select box to update field

  - by Andy

  On this page: http://www.blackdownluxurylettings.co.uk/place_booking/2010-3-18,2 I am using an onchange event on the "number of days" select box to update the "departure date" field. But currently nothing is happening. Any ideas?

  Read the article

< Previous Page | 165 166 167 168 169 170 171 172 173 174 175 176  | Next Page >