Search Results

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

Page 42/943 | < Previous Page | 38 39 40 41 42 43 44 45 46 47 48 49  | Next Page >

• SQL: Select distinct values from 1 column

  - by Parm

  I want to select distinct values from only one column (the BoekingPlaatsId column) with this query: SELECT MAX(BoekingPlaatsId), BewonerId, Naam, VoorNaam FROM table GROUP BY BewonerId, Naam, VoorNaam How do I do that in SQL Server?

  Read the article

• Grouped Select in Rails

  - by Neil Middleton

  Simple question really - how do I use the select(ActionView::Helpers::FormOptionsHelper) with grouped options? I have got it working with a select_tag (ActionView::Helpers::FormTagHelper) but I would really like to have it using a select tag to match the rest of the form. Is this possible? My options look like this: [ ['Group 1', ["Item 1", "Item 2", "Item 3"]], ['Group 2',["Item 1", "Item 2", "Item 3", "Item 4"]] ] whilst my view is currently: %tr#expense %td = f.text_field :value = f.hidden_field :type, :value => mode

  Read the article

• Close socket and select()

  - by kamziro

  So I need to close a particular connection, but the problem is another thread is, at the same time, doing a select() which has the socket as one of the file descriptors it's watching. Will the select() terminate gracefully, or will anything bad happen?

  Read the article

• Does an insert made in a transaction is visible by SELECT before transaction is commited

  - by 20c

  I need a confirmation. Client 1 insert rows in a table inside a transaction. Client 2 request this table with a SELECT. If on this client isolation level is set to READ COMMITTED, can you confirm that the SELECT won't returns the rows that aren't yet committed by Client 1. Thanks

  Read the article

• document.getElementById().innerHTML for select tag doesn't work in IE

  - by Syom

  i have the following simple script <input type="button" onclick="document.getElementById('a').innerHTML = '<option>something</option>';"/> <select id="a" style="width: 150px;"> </select> but it doesn't work in IE. could you tell me why? thanks

  Read the article

• selected item in a select tag

  - by comi

  hi everybody i have a problem please help me i have 4 select tag in my php page and when i post my parameters to my page all of select tags clear and i want my selected item dont change - excuse me for my bad english

  Read the article

• MSSQL - select date field in table

  - by thegunner

  Hi, In my table I have a date column which the date is displayed in the format "2009-11-18 10:55:28.370" How can just get the date value of this field in a select statement. e.g. select id from risks, where creation_date = getdate()

  Read the article

• Select Top N Records Ordered by X, But Have Results in Reverse Order

  - by I. J. Kennedy

  I'm trying to get the top N records (when ordered by some column X), but have the result set in reverse order. The following statement is incorrect, but probably demonstrates what I'm after: SELECT * FROM (SELECT TOP 10 * FROM FooTable ORDER BY X DESC) ORDER BY X ASC For example, column X could be an ID or a timestamp; I want the latest 10 records but want them returned in forward chronological order.

  Read the article

• cannot select items list from telerik mvc combox box

  - by user384080

  I'm trying to implement the comboboxfor as follow: @(Html.Telerik().ComboBoxFor(model => model.ProductId) .AutoFill(true) .HighlightFirstMatch(true) .DataBinding(binding => binding.Ajax().Select("GetProductByKeyword", "Product")) I managed to populate the list but does not allow me to select from the list. Also, I need to show the product name but at the same time I need to bind the productId as this is Id will stored in the database. any ideas?

  Read the article

• Multiple conditions on select query

  - by stats101

  I have a select statement and I wish to calculate the cubic volume based on other values within the table. However I want to check that neither pr.Length_mm or pr.Width_mm or pr.Height_mm are NULL prior. I've looked at CASE statements, however it only seems to evaluate one column at a time. SELECT sa.OrderName, sa.OrderType, pr.Volume_UOM ,pr.Length_mm*pr.Width_mm*pr.Height_mm AS Volume_Cubic ,pr.Length_mm*pr.Width_mm AS Volume_Floor ,pr.Length_mm ,pr.Height_mm ,pr.Width_mm FROM CostToServe_MCB.staging.Sale sa LEFT JOIN staging.Product pr ON sa.ID = pr.ID

  Read the article

• check select statement is valid or not in c#.net

  - by kiran

  i want to check select statement(string) is valid or not in c#.net, if select statement is right then retrieve data and fill dropdown list box else drop down should be empty

  Read the article

• Passing multiple parameters of same column to SQL Server select SP

  - by Bill

  I have a string value in the web.config — for example 2 guids seperated by a ",". I need to query the database dynamically (i.e i have no idea how many values could be seperated by a comma in the web.config) and run a select statement on the table passing these values and getting all that is relevant for example: select * from tablename where columnname = string1 string2 string3 etc etc some strings may only contain 1 guid some may contain 10

  Read the article

• I can't clear the SELECT list with "selectedIndex = -1" in Internet Explorer 8

  - by ML

  hi :) after an hour of trying to find a solution, I give up (temporarily). "this.selectedIndex = -1" clears all select element just fine in FF and other browsers, but NOT in Internet Explorer 8. any idea how to clear select elements in IE? thanks!

  Read the article

• about Select statement !

  - by user329820

  hi, I have read that after select we use column-names but I have found a statement that was like this: SELECT 'A' FROM T WHERE A = NULL; would you lease help me? thanks (A is a column- name here?) my DBMS is MySQL

  Read the article

• Select a column returned by a stored procedure

  - by vaibhav

  I have a stored procedure which is returning me about 50 columns. I want to write a query, where I will be able to select a particular column from the list of column returned by the SP. I tried writing select RSA_ID from exec(uspRisksEditSelect '1') But Its throwing me an error. I think we need to write some dynamic sql for it. But I am new to it.

  Read the article

• how can I select data from MySQL based on date (unix time record)

  - by bn

  I have a record of data with unix time date in it i want to select the row based on the date/month/year only (not with time) currently Im using something like this select * from tablename where date > '$today' and date < '$tomorow' LIMIT 1; how ever this is not that accurate if the $today and $tomorrow have different time (but same date) is there any better way to do this?

  Read the article

• Kernel.Select from ruby causing Thread(0x7f1a159abd58): deadlock (fatal)

  - by ElTren

  I don't have multiple threads or anything like that, and I thought select() was non-blocking, however, as I add more items to an array used as the IO object, and using select(), after about 1000~ items in the array (with some interaction on them).. the whole script exits with a deadlock / fatal error... Hope any1 could help Thank you so much!

  Read the article

• SQL select maximum from two time periods

  - by HamishC

  I have a query, Im trying to select the maximum value from the summer period (nov-april down here) but it only gives me values from nov-dec with this query. Any ideas why? SELECT TOP 10 Value, DateTime FROM history WHERE Tagname = @Tag AND ((DateTime >= @StartYear AND DateTime < @StartWinter) OR (DateTime >= @FinishWinter AND DateTime < @FinishYear)) ORDER BY Value DESC

  Read the article

• does it makes sense to do SP for simple queries like select * from users

  - by Omu

  is it going to be faster if instead of doing select * from users where id = 1 or delete from users where id = 1 or select count(*) from users I would create a SP for it ?

  Read the article

• mysqli_query SELECT FROM WHERE [ partial match ] ?

  - by user296516

  Hi guys, I have a database that a time filed that is stored in this format "2010.06.04. | 18:53 01". What I need is to select rows that have a specific date, for example "2010.06.04." Right now I am doing it my first selecting all rows and then looping through them and adding ones with the specified date to a new array. Maybe there is an easier way to do it and I somehow can select it using mysqli_query? Thanks!

  Read the article

• MySQL: Question about SELECT WHERE AND/OR

  - by Andrew

  I'm trying to write a query that returns the same result from three different events, but I think I am doing it wrong. I can run my query against one event ID and it works. How can I select all three? Here's what I have so far: SELECT * FROM `Registrations` WHERE `Role` = "Attendee" AND `RegistrationStatus_ID` = "1" AND `DigSignature` IS NULL AND `Event_ID` = "147" OR `Event_ID` = "155" OR `Event_ID` = "160"

  Read the article

• Query select field on JqGrid edit form

  - by abuzuhair

  I have this colom Model on JqGrid: {name:'ta',index:'ta',jsonmap:'ta',width:70,editable:true,edittype:'select', editoptions: {dataUrl:hostname+'/sisfa/ta_cb'}} I am using JqGrid form editing to edit this field. How to 'catch' the field editor for this field on form editing. I'm using this method, but not work .editGridRow("new", {closeAfterAdd: true, addCaption:'Add Data', width:500,dataheight:300,beforeShowForm:function(formid){ console.log($('#tr_ta').find('select[name=ta]')); }}); This method work for other edittype.

  Read the article

• MPTT to select root element mysql

  - by bah

  Hi, What mysql query should i use to select root elements? Let's say i have tree structure like this: http://www.ipix.lt/desc/18496369 And i want to select (Vaisiai, Daržoves) elements.

  Read the article

• How do you preform an IF...THEN in a SQL SELECT

  - by Eric Labashosky

  I want to be able to perform a IF...THEN in an SQL SELECT Statement. For Example; SELECT IF(Obsolete = 'N' or InStock = 'Y';1;0) as Salable, * FROM Product

  Read the article

• Is an editable select box the right way?

  - by Neil Middleton

  I have a scenario where a user is emailing another user in an HTML based web app. For the To: field, the user may select one of a pre-defined list of emails OR enter their own ignoring the pre-defined options. What would be the best way of doing this from a UI point of view? I've looked at editable select boxes using jQuery but none seem to let you enter your own option. Is there some other UI mechanism that would work here?

  Read the article

< Previous Page | 38 39 40 41 42 43 44 45 46 47 48 49  | Next Page >