Search Results

Search found 28469 results on 1139 pages for 'select statement'.

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

• 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

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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• Oralce : select maximum value from different comulms of the same row

  - by gregseth

  The whole question is pretty much in the title. For each row of the table I'd like to select the maximum of a subset of columns. For example, from this table name m1 m2 m3 m4 A 1 2 3 4 B 6 3 4 5 C 1 5 2 1 the result would be name max A 4 B 6 C 5 The query must be compatible oracle 8i. Thanks.

  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

• Oracle : select maximum value from different columns of the same row

  - by gregseth

  The whole question is pretty much in the title. For each row of the table I'd like to select the maximum of a subset of columns. For example, from this table name m1 m2 m3 m4 A 1 2 3 4 B 6 3 4 5 C 1 5 2 1 the result would be name max A 4 B 6 C 5 The query must be compatible oracle 8i. Thanks.

  Read the article

• select xml data column into flat reporting table

  - by Bernard

  We have a xml column in SQL Server 2008. We need to do reporting off the data in the xml so we're going to select the xml into a flat table. The flat table has columns that correspond to various nodes in the xml. What is the best way to do this using SSIS? Is this a good approach? Or should we just try and write the reports directly off the xml column?

  Read the article

• SELECT GROUP BY latest entry in INBOX msg sent by user

  - by Mohatir S

  i am building a simple PM for my personal website where a user can join and send message to the registered users on my website, i am stuck in grouping and selecting latest user (by latest msg time) in INBOX page my table : id msg_from msg_to msg date in_del out_del i want to show latest user's id each in a group here is my SQL query : SELECT ttalk.id, ttalk.msg_from, users.first_name, users.last_name FROM ttalk INNER JOIN users ON ttalk.msg_from = users.id WHERE ttalk.msg_to = '$_SESSION[user_id]' AND ttalk.in_del='0' GROUP BY ttalk.msg_from DESC LIMIT 500 Thanks in advance :-)

  Read the article

• Right way to handle friend-multi-select post on facebook, issues with session

  - by simple

  Do I need a infinite key with fbml facebook app that resides on fanpage? I am asking user to select user and posting it(facebook posts) to my server. On my server I want to get user_id and selected friends Id. Everything is fine with selected friend_ids, but have issues with getting id of a user. sometimes I can get it all fine, sometimes I am getting session expired exception, sometimes I get nothing. any ideas why this is happening?

  Read the article

• ASP.NET & jQuery multi-select dropdownlist, get selected values

  - by Dooie

  I have an .aspx page with a databound multi-select jquery dropdown. This works nicley but how can i get hold of the selected items in the code behind?

  Read the article

• JFileChooser select directory but show files

  - by Jeff Storey

  I feel like there should be a simple way to do this but I can't figure it out. I have a JFileChooser that allows the user to select directories. I want to show all the files in the directories to give the user some context, but only directories should be accepted as selections (maybe the Open button would be disabled when a file is selected). Is there an easy way of doing this?

  Read the article

• Select all entities of exact class, but not derived from it using NHibernate Criteria API

  - 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

• what does select @@identity do?

  - by every_answer_gets_a_point

  i am connecting to a mysql database through excel using odbc what does this line do? Set rs = oConn.Execute("SELECT @@identity", , adCmdText) i am having trouble updating the database: With rs .AddNew ' create a new record ' add values to each field in the record .Fields("datapath") = dpath .Fields("analysistime") = atime .Fields("reporttime") = rtime .Fields("lastcalib") = lcalib .Fields("analystname") = aname .Fields("reportname") = rname .Fields("batchstate") = "bstate" .Fields("instrument") = "NA" .Update ' stores the new record End With it is ONLY updating .Fields("instrument") = "NA", but for all other fields it is putting NULL values

  Read the article

• Avoid Select All option on a web page in ie

  - by Geetha

  Hi, I am working on a application for touch screen device. I want to avoid the select all option of the web page on the ie. How to do this. Geetha

  Read the article

• Select number of rows in all tables in the database

  - by Alex N.

  I wonder if this is possible with straight SQL on MySQL. I need to do SELECT COUNT(*) FROM on each table in the database and output results in one result set. Is it possible to do with just SQL?

  Read the article

• mysql select records greater than 3 months

  - by fire

  I am trying to write a query to select all records from users table where User_DateCreated (datetime field) is = 3 months from today. Any ideas? Thanks!

  Read the article

• Mysql Trigger to select and delete

  - by Karthick

  Hi, Is this possible, can a trigger in mysql can do a select first and then based on its result do a delete?, both on the same table. Am struggling to get it right. There are duplicate entries in a table, i need to have a trigger which selects and then deletes. Any ideas or thoughts will be really helpful.

  Read the article

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