Search Results

Search found 29702 results on 1189 pages for 'select insert'.

Page 107/1189 | < Previous Page | 103 104 105 106 107 108 109 110 111 112 113 114  | Next Page >

• Why sometimes I get "Cursor not returned from Query" from a valid select statement

  - by Erick Sasse

  I have some valid select statements that when I send to MSSQL2005 sometimes return the error "Cursor not returned from Query". How can I trace this and find out what's wrong? Thanks

  Read the article

• How to select image in round shape from the iphone photo library

  - by John

  I am open iphone photo library from the my application.And i am selecting photo in squre shape.Its fine.But i want select photo in round shape.How it possible?

  Read the article

• select top 5 in entity framework

  - by fishiefishie

  I have [Person] PersonID, EmailAddress, FirstName, LastName [OnlineAccount] OnlineAccountID, PersonID, Nickname Each person is allowed to have 0-* OnlineAccount. In entity framework with C#, how do I select the top 5 Person that has the most accounts?

  Read the article

• Select into from one sql server into another?

  - by blasto

  I want to select data from one table (T1, in DB1) in one server (Data.Old.S1) into data in another table (T2, in DB2) in another server (Data.Latest.S2). How can I do this ? Please note the way the servers are named. The query should take care of that too. That is, SQL server should not be confused about fully qualified table names. For example - this could confuse SQL server - Data.Old.S1.DB1.dbo.T1.

  Read the article

• Oracle select query

  - by Jasim

  I have a table like this C1 C2 C3 Code 1 2 3 33 1 2 3 34 2 4 1 14 1 2 3 14 i want to select only those record whose code is appearing only in single row. ie, in this case rows with code 33 and 34.. as they appear only once in this table. How can i write a query for that

  Read the article

• How to select last row of mysql_query?

  - by sergdev

  It is possible to select last row selected by mysql_query in php without iterating using mysql_fetch_row from first row till last? If so, what should I use?

  Read the article

• 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

• 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

• 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 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

< Previous Page | 103 104 105 106 107 108 109 110 111 112 113 114  | Next Page >