Search Results

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

Page 510/943 | < Previous Page | 506 507 508 509 510 511 512 513 514 515 516 517  | Next Page >

• How to load a table view when coming to back with out selection index

  - by ratnasomu

  Hellow all, I am using navigation controller and have table views inside views. when i select any cell it it will navigate to another view. so,from there if i click back button it come sto previous view.But,it showing the cell which is selected previously. I dnt want this .it should not show which cell we selected previously. Could any one help me how to get this. Thanks.

  Read the article

• Listview Multiple Selection

  - by Evan

  Is there any way to force a listview control to treat all clicks as though they were done through the Control key? I need to replicate the functionality of using the control key (selecting an item sets and unsets its selection status) in order to allow the user to easily select multiple items at the same time. Thank you in advance.

  Read the article

• MySQL: How can fetch SUM() of all fields in one Query?

  - by takpar

  Hi, I just want somthing like this: select SUM(*) from `mytable` group by `year` any suggestion? (I am using Zend Framework; if you have a suggestion using ZF rather than pure query would be great!) Update: I have a mass of columns in table and i do not want to write their name down one by one. No Idea??

  Read the article

• Oracle: What does `(+)` do in a WHERE clause?

  - by Jonathan Lonowski

  Found the following in an Oracle-based application that we're migrating (generalized): SELECT Table1.Category1, Table1.Category2, count(*) as Total, count(Tab2.Stat) AS Stat FROM Table1, Table2 WHERE (Table1.PrimaryKey = Table2.ForeignKey(+)) GROUP BY Table1.Category1, Table1.Category2 What does (+) do in a WHERE clause? I've never seen it used like that before.

  Read the article

• How to rebuild Safari Web Clip functionality in PHP

  - by Mayko

  Hi there, is there a way to rebuild Mac OSX Snow Leopard's Dashboard Widget 'Web Clip' on a PHP website? Something like a crawler or scraper. I thought about using file_get_contents to getting the page content into the page, but how do I select a section on the external page? And does this work with session/login content as well? I'm happy for any kind of suggestions! Cheers

  Read the article

• Mysql database not responded(crash?) when UPDATE , DROP/ALTER tables

  - by liuxingruo

  When I try to update a value in a column or DROP a table or ALTER a table, the database just not respond, and I have to reboot the service to get database works again. I can only SELECT data from my database(SO SAD).... Please help me, THANKS!!!!!!!!!!!!!!!!!

  Read the article

• The Best Way to shred XML data into SQL Server database columns

  - by eddiegroves

  What is the best way to shred XML data into various database columns? So far I have mainly been using the nodes and value functions like so: INSERT INTO some_table (column1, column2, column3) SELECT Rows.n.value('(@column1)[1]', 'varchar(20)'), Rows.n.value('(@column2)[1]', 'nvarchar(100)'), Rows.n.value('(@column3)[1]', 'int'), FROM @xml.nodes('//Rows') Rows(n) However I find that this is getting very slow for even moderate size xml data.

  Read the article

• node to traverse cannot be null (Hibernate SQL)

  - by tiswas

  I'm performing a SQL query through hibernate, which looks like: SELECT thi FROM track_history_items thi JOIN artists art ON thi.artist_id = art.id WHERE thi.type = "TrackBroadcast" GROUP BY art.name ORDER thi.createdAt DESC but I'm getting the message that 'Node to traverse cannot be null!'. Anyone know what could be causing this? --EDIT-- I'm pretty sure that this problem is being caused by the possibility of artist_id to be null. However, I can't prevent this, so can I just skip the rows track_history_item rows which have a null artist_id?

  Read the article

• How to create Insert script using c#

  - by karthik

  From my c# code behind, i pass a query to mysql database and get the data in a DataTable. Now i want to use the data in data table to write the Insert query in a script file [.sql] The objective of doing so is, whatever records i select from mysql, i should write that to a script file as backup. Thais why i need the insert statements. How ? Or any other idea is appreciated.

  Read the article

• Hibernate using OneToOne

  - by Soft

  I have two tables tab1 { col1 (PK), col2, col3 } tab2 { col1, col2(PK), col3 } I am using Hibernate annotation for joining using "OneToOne" I have the below Hibernate class for tab1 class tab1 { @OneToOne @JoinColumn(name = "col2", referencedColumnName = "col1") private tab2 t2; } i was expecting to run the below sql select * from tab1 t1, tab2 t2 where t1.col1 = t2.col2 But it is not working as i expected.Please help

  Read the article

• C#: DataBase Null in RadioButtonList

  - by Vinzcent

  Hey, I would like to have a radiobuttollist were you can select value null. Something like this: <asp:RadioButtonList ID="rblCD" runat="server" SelectedValue='<%# Bind("tblCD") %>'> <asp:ListItem Value="RW">RW</asp:ListItem> <asp:ListItem Value="R">R</asp:ListItem> <asp:ListItem Value="DBNull">None</asp:ListItem> </asp:RadioButtonList> Thanks a lot, Vincent

  Read the article

• Determine Last Modification Datetime for an Azure Table

  - by embeddedprogrammer

  I am developing an application which may be hosted on a microsoft sql server, or on Azure SQL, depending upon the end user's wishes. My whole system works fine with the exception of some WCF functions which determine the last modification time of tables using the following technique: SELECT OBJECT_NAME(OBJECT_ID) as tableName, last_user_update as lastUpdate FROM mydb.sys.dm_db_index_usage_stats This query fails in Azure. Is there any analogous way to get table last modification dates from Azure's sql?

  Read the article

• Order by Domain Extension Name using CodeIgniter Active Record Class

  - by allan

  $extension = “SUBSTRING_INDEX(domain_name, ‘.’, -1)”; $this->db->order_by($extension, “asc”); It says: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘asc LIMIT 50’ at line 44 But its working when I didn’t used the $this-db-order_by Active Record Class such as this one: $this-db-query(“SELECT * FROM domain ORDER BY SUBSTRING_INDEX(domain_name, ‘.’, -1)”); Anyone please help me. Thanks.

  Read the article

• Selectable GridView Row

  - by Hany

  I have a GridView on my ASP.NET page. What I want is to execute a function when I click on the row, and I also want to change the style of this row. I don't want to use the select button of type command field. Any help please?

  Read the article

• jQuery Selector issue finding href with text category1 in it

  - by sushil bharwani

  i have a set of hyperlinks with href = javascript:method('category1') and likewise category2 category3 ... I want to select hyperlink with href containing category1 so i have written jQuery(a[href*='category1']) but dont know why it also selects hyperlinks with category10 category11 category12 ... also I understand that category1 is common in all of them but 'category1' should'nt be do i need to put ' with escape charaters.

  Read the article

• how to bind gridview through linq

  - by Manoj Wadhwani

  I am using linq to sql Currently i am binding gridviw through linq which query written in business logic call . i have extract record through query in business logic class and i want to bind that particular data to gridviw and return data . how to retrun data which type is array. code is mention below: CMSBusiness.DataClasses1DataContext db = new DataClasses1DataContext(); var cate = from p in db.categoryTables select new { categoryId=p.categoryId, categoryName=p.categoryName, categoryDesc=p.categoryDesc }; how to return value and bind gridview , Please suggest

  Read the article

• What is the best way to use MySQL full-text search with a self-join?

  - by gersh

  I want to do something like: select a.a_ft,count(b.a_ft) FROM row a JOIN row b on match a.a_ft against (b.b_ft). However, this isn't legal. Basically, I just want to look for similar phrases in my database. What is the easiest way to do this?

  Read the article

• Why date comparison in sql is not working. Please help

  - by Shantanu Gupta

  I am trying to fetch some records from table but when i use OR instead of AND it returns me few records but not in other case. dates given exactly are present in table. What mistake i am doing ? select newsid,title,detail,hotnews from view_newsmaster where datefrom>=CONVERT(datetime, '4-22-2010',111) AND dateto<=CONVERT(datetime, '4-22-2010',111)

  Read the article

• Tooltip steals mouse click

  - by deerchao

  I'm writing a custom TreeView from ScrollableControl. I decided to show tooltips when the mouse hovers over nodes with text too long to display. I find that when tooltips are shown, the user is not able to click the node to select it because (I think) he's clicking the tooltip window, not my control. Is there any easy solutions? As far I can see, System.Windows.Forms.TreeView don't have this problem. Thanks!

  Read the article

• Ado.net entity model problem

  - by ognjenb

  public ActionResult Index() { using (testEntities korisnici = new testEntities()) { my_aspnet_users user = new my_aspnet_users(); user = from i in korisnici.my_aspnet_users select i; return View(user); } } Error: Cannot implicitly convert type 'System.Linq.IQueryable' to 'MyApp.Models.my_aspnet_users'. An explicit conversion exists (are you missing a cast?)

  Read the article

• How can I uninstall NetBeans on a mac?

  - by Henri W

  I currently have NetBeans 6.5 installed on my mac running leopard. I searched Google on how to uninstall it and the NetBeans website says to right click on it, select "Show Package Contents" and the uninstaller should be there, but it isn't. How can I completely uninstall NetBeans in this situation? Thanks!

  Read the article

• Php/Mysql - need help to insert and update multiple rows with a single query

  - by Guanche

  Hello, is there any way how in this situation insert and update DB with single queries? $message = 'Hello to all group members'; $userdata = mysql_query("SELECT memberid, membernick FROM members WHERE groupid='$cid'") or die('Error'); while(list($memberid, $membernick) = mysql_fetch_row($userdata)) { $result1 = mysql_query("INSERT INTO messages VALUES (NULL,'$membernick', '$memberid', '$message')") or die('Error'); $result2 = mysql_query("UPDATE users SET new_messages=new_messages+1, total_messages=total_messages+1 WHERE id='$memberid'") or die('Error'); }

  Read the article

• How to convert this SQL query to Linq to Entity query?

  - by George

  Hi, could you help me please convert this SQL query to Linq to Entity query? Thank you select distinct item, count(item) as count from TableName where ColumnName = @parameter and (ColumnName2 = @parameter2 OR ColumnName3 = @parameter3) group by item order by item asc

  Read the article

• Oracle Rows into Columns

  - by user2904845

  Can someone help me design the query to get below o/p. Data I have: Table X: Count Name Amount Days 5 ABC 500 Day1 10 ABC 1000 Day2 3 BCD 100 Day1 4 BDC 200 Day2 Result I need: Name Count AmountDay1 Count AmountDay2 ABC 5 500 10 1000 BCD 3 100 4 200 etc Is this Possible? I tried something with the below query, but not getting the desired o/p select * from X pivot (sum(amount) for days in ('Day1', 'Day2')) Please help I'm using Oracle 11 G

  Read the article

• Improve long mysql query

  - by John Adawan

  I have a php mysql query like this $query = "SELECT * FROM articles FORCE INDEX (articleindex) WHERE category='$thiscat' and did>'$thisdid' and mid!='$thismid' and status='1' and group='$thisgroup' and pid>'$thispid' LIMIT 10"; As optimization, I've indexed all the parameters in articleindex and I use force index to force mysql to use the index, supposedly for faster processing. But it seems that this query is still quite slow and it's causing a jam and maxing out the max mysql connection limit. Let's discuss how we can improve on such long query.

  Read the article

< Previous Page | 506 507 508 509 510 511 512 513 514 515 516 517  | Next Page >