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 >

• Jquery prevent dragging of text value

  - by ipr101

  I have a html textbox on which I've bound a function via jQuery to the paste event to prevent users pasting a value into the textbox. This functionality works well. However it is possible to select some text from another textbox on the page and drag it into the textbox in which pastes are prevented. Is there a jQuery event that I can bind to that will prevent users dragging text into the texbox?

  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

• Is existed web markup languages with possibility insert sql query?

  - by MercurieVV

  Actually what I want - simple DB with simple User Interface. Like MS Access, but for web and it can be without Dragn n Drop, but described with markup language. For example if I want to create list report, then i need to write something like: <table query="SELECT * from mytable"></table> It needed for simple data applications. In that kind application no programming logic required. Just working with DB. Changing DB data and showing it.

  Read the article

• a bugging query

  - by Sachindra

  i need to get a query where the elements are displayed in case the first letter is E (the word is electronics).. i have tried with the following : mysql_query("select * from nested_category where name like '[A-F]%'");

  Read the article

• Having tabs I want to draw a line on map and let it stay there all the time.

  - by Pavel

  Hi. I'm having some difficulty with drawing a line on a map. I'm basically drawing it etc. but when I select other tab and then come back to the "map tab" the line disappears. How can I prevent that so the line stays there all the time?

  Read the article

• Help with XML path views

  - by xmlpath

  Hi all, is there any tool that will give me a view for XML fields like so. I want something that will show me the a view like so, if i select element1 Service/Body/element1 Is there any tool for eclipse for doing the above. Thanks.

  Read the article

• Help with sql query

  - by user225269

  I have two tables: subject and student. I'm trying to count the number of subjects enrolled by each student. How do I do that?I'm trying the code below but it doesn't give the answer I need. Please help. SELECT COUNT( subject.SUBJECT ) , student.IDNO, student.FIRSTNAME, subject.SUBJECT FROM student, subject GROUP BY subject.SUBJECT LIMIT 0 , 30

  Read the article

• DateTime group by date or hours

  - by nCdy

  01.02.2010 0:00:00 - 01.02.2010 anytime 01.02.2010 0:00:00 - 01.02.2010 0:any minutes and seconds so here is my date : DateTime x; it's 01.02.2010 0:00:00 as a string x.Date.ToString() here I compare date DatarowsForOneDay = dt.Select("DailyRecTime= '" + x.ToString() + "'"); So how can I group by date + Hours without care about minutes and seconds.

  Read the article

• sql exception handling

  - by christine33990

  CREATE OR REPLACE PROCEDURE p_createLocaltable IS table_already_exist EXCEPTION; PRAGMA EXCEPTION_INIT (table_already_exist, -00955); BEGIN create table local_table as select * from supplied_table where rownum < 1; EXCEPTION when table_already_exist then DBMS_OUTPUT.put_line('Table already exists , does not need to recreate it'); END; can anyone see any problem of the above code?

  Read the article

• display 25 randomnumbers from an array

  - by qwerty

  Hello, I have in C++ an array of 100 elements, so v[1], ... ,v[100] contains numbers. How can i display, 25 random numbers from this array? So i wanna select 25 random positions from this array and display the values.. How can i do this in C++? Thanks!

  Read the article

• [Qt] Check octal number

  - by sterh

  Hello, I write simple application in C++/Qt. And i have a text and some octal number in it. My app splits this text by spaces. And i need to check octal numbers from text. How can i select octal numbers from this text with regular expressions? Thank you.

  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

• How can you identify all events before and after a today in IRB?

  - by Trip

  I for the life of me can't figure out the correct syntax to show the count of events before and after today. Here's my awful and disgusting attempt: Events.find(:all).select {|e| e.date Time.now}.size The trouble is the or < operators don't work with Time.. :D

  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

• PHP MYSQL SIMPLE SEARCH ISSUE

  - by Kunal

  Hi I have a table with the following structure: id int(11), name varchar(250) I have lots of records in the table but when I am trying to find a particluar record which has the following value on the name field: Lorem ipsum d\'olor sit amet The query is simply returning a blank recordset. I am not being able to figure out this weird behaviour, when my query is as simple as follows: SELECT * FROM slot_games WHERE name='Lorem ipsum d\'olor sit amet' Would appreciate your help please! Thanks in advance.

  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

• 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

• Error in ASP Code

  - by user303949

  Hi Below ASP code have some error in 'Dim MonthNum=Month("Ctxtdatefrom") ' Can help to solve this. ...... If session("cmbLeaveType")=2 then set rs2 = objconn.execute("select * form Particulars where empid='" & session("empid") & "'") if ChildNationality = ABC then Dim MonthNum=Month("Ctxtdatefrom") Dim MonthNum2=Month("ctxtdateto") If(MonthNum=5 and monthnum2=5) if tdays1 then else set rs = objconn.execute("insert into leavebank (empid, datesubmit, datefrom, dateto.... END IF END IF END IF END IF

  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

• treeview selected item should highlight with some color

  - by ibrahimkhan

  I have a treeview in wpf. I want a different color when i select the treeviewitem. Any Suggestions Plz.. Thanks

  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

• jQuery selector: this.parent, is there such a thing?

  - by Kyle Sevenoaks

  I have a lot of div boxes with nested div .titles, with a button inside. Is there a way in jQuery to select the parent of the button? Something like: $("#button").click(function(){ $("this.parent").css({'border-bottom' : 'none'}); }); Or am I going to have to rename all of my title classes to unique classes?

  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

• Retrieve Specific Data/Value From Database 1 Line PHP

  - by Belgin Fish

  Hi, I'm just wondering how I can retrieve a specific value (only 1 thing will be returned) from a database using php. My query is mysql_query("SELECT balance FROM users WHERE username = '". $this->username . "'") I'm just looking for it to retrieve the data from that row so I can save it directory into a variable.

  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

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