Search Results

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

Page 507/943 | < Previous Page | 503 504 505 506 507 508 509 510 511 512 513 514  | Next Page >

• Android number input with plus and minus sign.

  - by alaak

  Hi, I am developing in android and I would like an input field for numbers, where the user can select the correct number using the plus sign at the top and the minus sign at the bottom of the input field. I know this works for date picker. Is there some property or something similar to make this available for any integer number input field? Thanks

  Read the article

• linq to entites left outer join

  - by parminder

  I am struggling linq to entities left outer join. I have two entities (tables): Listings { ListingID, MakeID (nullable) } Makes { MakeID, Description } I want to write something like this in LINQ: select listings.listingID ,listings.makeid , IsNull(makes.Description, 'NA') from listings left outer join makes on listings.makeid = makes.makeid

  Read the article

• Check if row exists, if not add it [MySQL]

  - by Steven

  I need to add a row to a MySQL database table but only if the row doesn't already exist. My database server just went down so I can't test this, but will this work as expected? INSERT INTO `blocks` (`block_file`,`settings_group`) VALUES ('announcements','announcement_settings') WHERE NOT EXISTS (SELECT `block_file`,`settings_group` FROM `blocks` WHERE `block_file`='announcements' AND `settings_group`='announcement_settings') It seems like sound logic. Is this a valid query or is there a better way of doing this?

  Read the article

• How To Upload a file on the click of an image button

  - by Jibu P C_Adoor

  Hii, I have an 'Attach image button' in my web page, I don't want see the the file upload control in my page. On the click of the 'Attach image button' it will directly shows the browser's directory window and select the file from that and can directly uploads to the server. Does any body knows how it is possible

  Read the article

• Need mySQL TIMESTAMP for begining of the current week or any given date?

  - by Kenan

  Hi, I need mySQL timestamp for start of current week or any given date, if week starts with monday? I'm trying something like: SELECT UNIX_TIMESTAMP(CONCAT( DATE_SUB(CURDATE(), INTERVAL WEEKDAY(DATE_SUB(CURDATE(), INTERVAL 7 DAY)) DAY), ' 00:00:00')) as start

  Read the article

• C# analog for sql in operator

  - by er-v

  There is in operator in SQL SELECT * FROM MyTable WHERE id IN (1, 2, 3, 4, 5) Is there similar sintax in C#, I mean if(variable in (1, 2, 3, 4, 5)){ }

  Read the article

• Convert XML to UDT in Oracle

  - by Josh

  Is there an easy way to convert an XMLType to a User Defined Type? I can convert the UDT to XMLType using the below. select SYS_XMLGEN(pUDT) into param2 from dual; I can't though, is find a function that takes that and turns it back into that UDT using the same mappings the SYS_XMLGEN used.

  Read the article

• Writing a simple conditional statement in IRB

  - by Trip

  I am looking up all Organizations with the url "http://", and updating their attributes to "". My attempt: Organization(:all).select { |o| o.url = "http://" ? o.update_attribute("url","")} Which returns a compile error: SyntaxError: compile error (irb):2: syntax error, unexpected '}' from (irb):2 Any ideas?

  Read the article

• Django represent a many-to-many relationship as a CharField

  - by Brandon

  I have a many-to-many field on one of my models and a ModelForm to represent it. I have it in a template but it shows up as a multiple select field. I need it to show up as a CharField so the user can put in comma-delimited values. Is there any way to do this?

  Read the article

• mysql IF EXISTS

  - by cosy

  What is wrong with this ? mysql_query("IF EXISTS(SELECT * FROM y where 1=1 ) THEN do something ELSE do something END IF"); Thanks!

  Read the article

• How Display Excel rows on selection of first Excel Column Value

  - by Yashwant Chavan

  Hi, I have Two Excel sheets. My requirement is when i select Reason Value From First Excel sheet Reason Column. It will display respected Reason Value in Second Excel. So using Macro i want to Display Second Excel Rows on selection of reason in first excel. Please Help. First Excel is And Reason Column Contains Reason1 , Reason 2 etc. This Second Excel Data

  Read the article

• convert a sql statement to class?

  - by walter

  Is there a tool or code to convert a sql statement to class? Something like: Dim sqlText = "SELECT CustomerID, Name, Address, City FROM dbo.Customer WHERE CustomerID = 1" Dim obj As New ***SqlStatementTool***(sqlText) obj.GetTables() 'Will Return Tables in sqlText obj.GetWheres() 'Will Return conditions in sqltext obj.GetParameters() 'will return parameters in sqltext

  Read the article

• Error using iif in ms access query

  - by naveen

  I am trying to fire this query in MS Access SELECT file_number, IIF(invoice_type='Spent on Coding',SUM(CINT(invoice_amount)), 0) as CodingExpense FROM invoice GROUP BY file_number I am getting this error Error in list of function arguments: '=' not recognized. Unable to parse query text. I tried replacing IIF with SWITCH to no avail. What's wrong with my query and how to correct this?

  Read the article

• Linq to Sql statement for multiple aggregate values in single expression

  - by Jeff Langston

  How would I write a linq to sql statement for the following tsql? select count(*), sum(Amount), avg(Amount), min(Amount), max(Amount) from TableName

  Read the article

• SQL - How to display the students with the same age?

  - by Cristian

  the code I wrote only tells me how many students have the same age. I want their names too... SELECT YEAR(CURRENT DATE-DATEOFBIRTH) AS AGE, COUNT(*) AS HOWMANY FROM STUDENTS GROUP BY YEAR(CURRENT DATE-DATEOFBIRTH); this returns something like this: AGE HOWMANY --- ------- 21 3 30 5 Thank you. TABLE STUDENTS COLUMNS: StudentID (primary key), Name(varchar), Firstname(varchar), Dateofbirth(varchar) I was thinking of maybe using the code above and somewhere add the function concat that will put the stundents' names on the same row as in

  Read the article

• how to get file name from java script...input type="file".....

  - by dpaksp

  in html when i select some file...using JavaScript i need to display the whole file path..i tried i was able to get only the file name that i have selected...how to get the full path, is is possilbe

  Read the article

• The explain tells that the query is awful (it doesn't use a single key) but I'm using LIMIT 1. Is th

  - by Ricardo

  The explain command with the query: explain SELECT * FROM leituras WHERE categorias_id=75 AND textos_id=190304 AND cookie='3f203349ce5ad3c67770ebc882927646' AND endereco_ip='127.0.0.1' LIMIT 1 The result: id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE leituras ALL (null) (null) (null) (null) 1022597 Using where Will it make any difference adding some keys on the table? Even that the query will always return only one row.

  Read the article

• showcase website in album

  - by proyb2

  What is the best gallery to showcase web design you have came across? Plan to get various creative agencies to showcase their works on an advertisement platform so that new user will be able to see various portfolio. When it come to select a suitable album, I am indecisive if it too plain (Load and display) or too flashy (coverflow album), which album/gallery script do you recommend for our corporate theme? I would prefer background to be white.

  Read the article

• diff between two days, in hours

  - by Cristian Boariu

  Hi, I do not uderstand why the result of: (DateTime.Now.Subtract(user.created_time.Value.Date)).Hours is 23. where: DateTime.Now is:{3/30/2010 12:00:00 AM} and user.created_time.Value.Date is : {3/24/2010 12:00:00 AM} Does it make sense for anybody? ps: I want to select all users created in last 72 hours so i suppose that is the way i should do...

  Read the article

• Cant change text in custom cell

  - by darkman

  I created a custom cell to display a text a two images, when the user select the cell, the image is suposed to change, i can acess the properties of the cell, but cant change then : - (void)tableView:(UITableView *)tableView didSelectRowAtIndexPath:(NSIndexPath *)indexPath { [tableView deselectRowAtIndexPath:indexPath animated:YES]; CustomCell *cell = (CustomCell *)[self.tableView cellForRowAtIndexPath:indexPath]; cell.check.image = setImage:[UIImage imageNamed:@"1355327732_checkbox-checked"]; [cell.check setImage:[UIImage imageNamed:@"1355327732_checkbox-checked"]]; } cell.check is a UIImageView Am i missing something?

  Read the article

• How come I can't bundle an instance from Amazon's AWS Management console?

  - by bantic

  When I select a running instance and click the "instance actions" pull-down, the option to bundle the image to an S3 bucket is grayed out. Why would this be? See here: http://skitch.com/eoligarry/dnr7n/aws-management-console I am signed up for S3, and this is not a windows instance.

  Read the article

• "preprocess current file" addin for Visual Studio? (C++ )

  - by Virgil

  I realize that Visual Studio has the "/P" option to generate preprocessed files, but it's extremely inconvenient. I'm looking for an addin that allows you to right-click on a file and select "view preprocessed" - or any similar solution that would basically preprocess the currently-open file (with the appropriate options from the current configuration) and show me the output, with no extra hassle. Does such a thing exist?

  Read the article

• SQL Server Update Group by

  - by Gerardo Abdo

  I'm trying to execute this on MS-SQL but returns me an error just at the Group by line update #temp Set Dos=Count(1) From Temp_Table2010 s where Id=s.Total and s.total in (Select Id from #temp) group by s.Total Do anyone knows how can I solve this problem having good performance.

  Read the article

• Django left join m2m field.

  - by duder

  Here's my Model: class User(models.Model): pass class Item(models.Model): pass class ItemVote(models.Model): user = models.ForeignKey(User) item = models.ForeignKey(Item) vote = models.BooleanField() I want to retrieve a list of Items, and I want to know if the current user has voted for each Item. How do I alter my query object so that it will generate sql similar to: SELECT ... FROM items LEFT OUTER JOIN item_votes ON (item_votes.user_id = ? AND item_votes.item_id = items.id)

  Read the article

• mysql reader not worked when i worked with huge amount of data

  - by Steven Spielberg

  my Select query not worked when i worked with mysql and database have a huge amount of information. i got error System.NullReferenceException: Object reference not set to an instance of an object. for MySqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

  Read the article

< Previous Page | 503 504 505 506 507 508 509 510 511 512 513 514  | Next Page >