Search Results

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

Page 542/943 | < Previous Page | 538 539 540 541 542 543 544 545 546 547 548 549  | Next Page >

• How to check the existence of a row in SQLite with Python?

  - by fx

  I have the cursor with the query statement as follows: cursor.execute("select rowid from components where name = ?", (name,)) I want to check for the existence of the components: name and return to a python variable. How do I do that?

  Read the article

• Operations on Java Swing

  - by gustavo

  In my project,I will get the coordinates of some points from an XML file,and create some visual components using this information ? I am planning to give these components to a Java swing frame or panel. However,The users are supposed to click on the figure(which I will construct using Graphics 2d libraries) and select two points and give a label to the points between those two points ? How can i get the clicks clicked on JFrame or JPanel(i.e events for this kind of actions) ?

  Read the article

• Check the value from DBand pass it to next page

  - by user554176

  I have a field ,if user enters data it should go and check db if it is present it should redirect to next page. But here i m not sure whether it is checking the db but mysql query is correct. $ThirdPartyCategoryName =$_POST['ThirdPartyCategoryName']; $activate = mysql_query("SELECT * FROM `thirdpartycategorymaster` WHERE `delete` = 'y' "); if($activate=='y') { header("location:catact.php"); } else { //$activate=='NULL'; header("location:tp_home.php"); }

  Read the article

• syntax error in a mysql statement

  - by knowledge

  what is the error in the following mysql statement : mysql> SELECT columnName FROM tableName WHERE columnName LIKE '%' + @variableName + '%';

  Read the article

• join two tables but want one matching columns instead of showing it separately sql server 2008

  - by amby

  Hi i want to display join result of two tables but don't want to show matching column separately. I want it one instead of two. so please tell me what query should i use for this. I m using sql server 2008 and my query is like: select * from Customer_Order, optRelation where Customer_Order.orderNumber = optRelation.orderNumber AND optRelation.orderNumber = 21. please reply soon

  Read the article

• How to edit resharper's action list

  - by Gerard

  In Resharper I edited the inspection severity of the 'use var keyword when possible' to ''do not show'. But when I select a certain word in the code file, Resharper still shows a pencil with an Action list in the left border with the action 'use var'. Where can I edit the actions that should be shown? I cannot find this option.

  Read the article

• Is it possible to get id of affected rows in MySQL?

  - by user198729

  I'm using pdo to do this : update tags set cnt=cnt-1 where name in ? delete from news_tag where news_id=? and tag_id in (select id from tags where name in ?) But if I can get affected rows' id,the subquery is not needed.

  Read the article

• How do I use ST_Contains in following case?

  - by Z77

  I have two tables. First with points, and second with polygons. I need to find out which points are in required polygon according to the attribute gid. Using query: SELECT table1.* FROM table1, table2 WHERE table2.gid=1 AND ST_Contains(table2.geom2, table1.geom1); What I get is empty table (only columns without data)... Tnx

  Read the article

• Getting dates based on week number

  - by meep

  Hello. I have some rows in my database that contains some dates. I need to select all dates based on a weeknumber, how is this possible?

  Read the article

• mySQL convert varchar to date

  - by Jeff V

  I need to convert a varchar value of 1/9/2011 to a date in mySQL and I want only the month and year. So that I can then use the PERIOD_DIFF function (so I would need the above to be converted to 201101). I've tried various ways using the STR_TO_DATE function: SELECT STR_TO_DATE(CYOApp_oilChangedDate, '%m/%Y') FROM CYO_AppInfo But I get weird results... (for example: 2009-01-00) What am I doing incorrectly?

  Read the article

• JQuery - Set all cookies ending with

  - by Israfel

  I'm wondering if it's possible to use a wildcard to select multiple cookies. I'm using jquery to save various scroll position and would like to clear them out in one go. At the moment I clear them out individually as below function clearScroll(elementID) { if ($.cookie) { $.cookie(elementID + '_scrollpos', 0); } } What I'd like is a clear all something like below. function clearAllScroll() { if ($.cookie) { $cookie([name$='_scrollpos'],0); } } Is this possible?

  Read the article

• changing the name of type="file" input tag?

  - by Syom

  i have an input tag... <input type="file" name="upload"> for browsing it makes the button vith value "browse"(in mozilla) the question is: how can i change the name of that button? i want it to have the name "select" instead of "browse". Thanks

  Read the article

• Signs that a SQL statement is dangerous

  - by Matt

  Hi, I want to develop a function in PHP that checks how dangerous a SQL statement is. When i say dangerous i mean, certain symbols, characters or strings that are used to get data from a database that the user shouldnt see. For example: SELECT * FROM users WHERE userId = '1' can be injected in several ways. Although i clean the params, i also want to monitor how safe the query is to run. Thanks in advance

  Read the article

• Selecting two specific mysql table rows in a single query

  - by Scotta

  Lets say I have a table with 20 entries. They are sorted by date (date is a column name _) in descending order. How would I go about selecting ONLY the newest entry and the 15th oldest entry? I am getting all 15 results by doing the following query SELECT * FROM mytable m WHERE col1 = "zzz" ORDER BY date DESC LIMIT 15;

  Read the article

• validating check boxes in grid view

  - by SmartDev

  Hi, I have used check box in gridview . Now i want to validate those checkboxes as if no check box is selected a message shud pop up saying please select check box and thn press submit Thanks Smartdev

  Read the article

• Rails find through association

  - by yogi

  class Customer < ActiveRecord::Base has_one :address, :foreign_key => "customerid" end class Address < ActiveRecord::Base belongs_to :customer, :foreign_key => "customerid" end How do I find records in customer that do not have customerid in address table? in SQL i'd do select * from customer a, address b where a.customerid <> b.customerid

  Read the article

• jQuery Selection Child of UL. Looking for a better method

  - by john doe

  I have a div element which contains UL and UL contains the LI items. One of the LI item has an ID of stocknumber. I need to select that li. Here is my code which works fine I am just looking for a better implementation. $(".block").children("ul").children("#stocknumber") // gets me the li and it works!!

  Read the article

• Selecting count(*) while checking for a value in the results

  - by Rob

  SELECT COUNT(*) as Count, IF(sch.HomeTeamID = 34,true,false) AS Hawaii FROM schedule sch JOIN schools s ON s.ID = 83 WHERE (sch.HomeTeamID = 83 OR sch.AwayTeamID = 83) AND sch.SeasonID = 4 I'm trying to use count() to simplify my result but also include a field that represents wether any of the results' specific column contained a certain value. Is this possible? I'd basically like a row response with all the info I need.

  Read the article

• troubles creating a List of doubles from a list of objects

  - by Michel

  Hi, i have a list with objects. The object has a property 'Sales' which is a string. Now i want to create a list of doubles with the values of all objects' 'Sales' properties. I tried this: var tmp = from n in e.Result select new{ Convert.ToDouble ( n.Sales) }; but this gives me this error: Error 106 Invalid anonymous type member declarator. Anonymous type members must be declared with a member assignment, simple name or member access.

  Read the article

• Problem in LINQ query formation

  - by Newbie

  I have written List<int> Uids = new List<int>(); Uids = (from returnResultSet in ds.ToList() from portfolioReturn in returnResultSet.Portfolios from baseRecord in portfolioReturn.ChildData select new int { id = baseRecord.Id }).ToList<int>(); Getting error: 'int' does not contain a definition for 'id' what is the problem that i created? Thanks

  Read the article

• How to check the existence of a row in SQLite?

  - by fx

  I have the cursor with the query statement as follows: cursor.execute("select rowid from components where name = ?", (name,)) I want to check for the existence of the components: name and return to a python variable. How do I do that?

  Read the article

• Copy (or USE) data from two tables in different databases

  - by Z77

  I don-t know how to use one table from one database and second table from another databse at the same time or copy data from table in one database to table from another databse. I tried following query: select * into NewTable from existingdb.dbo.existingTable; But it doesnt't work.

  Read the article

• Access different columns from LINQ resultset

  - by Piyush

  I have a query which returns multiple columns from the database using LINQ var donors = from d2 in db.Donors where d2.Status == "Pending" select new { donorID = d2.donorID, bloodGroup = d2.bloodGroup, contactNo = d2.contactMobile, status = d2.Status }; now I want to display the results in different Labels accessing one column value from donors resultset. ex: Label1.Text = donorID; Label2.Text = bloodGroup; ...and so on please help me achieve this.

  Read the article

• Git: Add part of (changed) file to index *by line numbers*

  - by RobM

  Is there a git command to add differences within a range of line-numbers to the index? I want to be able to select lines in my editor and run a macro to add any changes in the selection to the index.

  Read the article

• Create a Calendar that displays one year from today(Asp.Net)

  - by GigaPr

  Hi, I would like to create a calendar that displays a year from today(everyday) and allows the user to select the multiple dates. I tried to use the asp:calendar without any success I am developing in C# .NET any suggestion

  Read the article

< Previous Page | 538 539 540 541 542 543 544 545 546 547 548 549  | Next Page >