Search Results

Search found 49727 results on 1990 pages for 'multiple select query'.

Page 235/1990 | < Previous Page | 231 232 233 234 235 236 237 238 239 240 241 242  | Next Page >

• how to select * from tableA where columnA values don't start with letter 'F'

  - by subash

  Can I have a SQL query to get the data from columna in tableA whose values don't start with 'f' ? For example: select * from tableA where columnA where values don't start with letter 'F'.

  Read the article

• Select 5, 10, 15, 20 and so on with LINQ

  - by Johan Leino

  Hey guys, I want to display items in a dropdownlist like 5%, 10%, 15%, 20% until 100. Is there a way to bind an intelligent LINQ query to the datasource that will do this for me?

  Read the article

• Javascript Event for Select element Selection

  - by JP

  Hi everyone, I'm looking to find the Javascript Event I need to put into jQuery's .bind function in order to have the function triggered when a selection is made from a <select> element. At the moment I'm using .bind('change',function() { ...}) but I need the event to trigger when the selected option is chosen again. Any suggestions?

  Read the article

• Using jQuery to Highlight (Select) All Text in a Textbox

  - by Spyros

  I have an input text box with some text in it , onclick event I want to run a javascript function to select (highlight) all text that is in this box , how I can do that with jquery?

  Read the article

• JQuery - click trigger on select box doesn't work?

  - by sasa

  Does anybody know how dropdown list can be opened with trigger? Here is code which doesn't work: $('select').trigger('click'); Just for note - mousedown and mouseup also doesn't work.

  Read the article

• Dropdown list allow multi-select in sharepoint

  - by HieuNT

  Hi, I have a trouble that : I have to implement a webpart contain a Field that look up into other list. But the requirement that it must allow multi-value, and multi-select as a dropdown-list. Pls, help me :(

  Read the article

• Database select * for a Noob

  - by Kevin Brown

  I've heard that it's bad to select all the fields in a database. Is this true, and if so, why?

  Read the article

• Rails select helper. How do I select the default value?

  - by Ram

  In Rails erb, am using the snippet to show visiting team in a tournament match. How do I get to initially show the current visiting_team? What am I doing wrong? <%= f.select(:visiting_team_id, Team.all.collect{|t| [t.name, t.id] }) %>

  Read the article

• onchange event from select box to update field

  - by Andy

  On this page: http://www.blackdownluxurylettings.co.uk/place_booking/2010-3-18,2 I am using an onchange event on the "number of days" select box to update the "departure date" field. But currently nothing is happening. Any ideas?

  Read the article

• Oralce : select maximum value from different comulms of the same row

  - by gregseth

  The whole question is pretty much in the title. For each row of the table I'd like to select the maximum of a subset of columns. For example, from this table name m1 m2 m3 m4 A 1 2 3 4 B 6 3 4 5 C 1 5 2 1 the result would be name max A 4 B 6 C 5 The query must be compatible oracle 8i. Thanks.

  Read the article

• select xml data column into flat reporting table

  - by Bernard

  We have a xml column in SQL Server 2008. We need to do reporting off the data in the xml so we're going to select the xml into a flat table. The flat table has columns that correspond to various nodes in the xml. What is the best way to do this using SSIS? Is this a good approach? Or should we just try and write the reports directly off the xml column?

  Read the article

• SELECT GROUP BY latest entry in INBOX msg sent by user

  - by Mohatir S

  i am building a simple PM for my personal website where a user can join and send message to the registered users on my website, i am stuck in grouping and selecting latest user (by latest msg time) in INBOX page my table : id msg_from msg_to msg date in_del out_del i want to show latest user's id each in a group here is my SQL query : SELECT ttalk.id, ttalk.msg_from, users.first_name, users.last_name FROM ttalk INNER JOIN users ON ttalk.msg_from = users.id WHERE ttalk.msg_to = '$_SESSION[user_id]' AND ttalk.in_del='0' GROUP BY ttalk.msg_from DESC LIMIT 500 Thanks in advance :-)

  Read the article

• MySQL select date, join statistic data - how?

  - by Webnet

  I have some statistics I need to report on a monthly basis. I need my query to return 0's for statistics which aren't there. The only way I know to do this is to use SQL to generate a list of days within the specified time period and LEFT JOIN the statistic data that I need to report on. Problem is.... I've never not selected from a table like that... how do I do that?

  Read the article

• ASP.NET & jQuery multi-select dropdownlist, get selected values

  - by Dooie

  I have an .aspx page with a databound multi-select jquery dropdown. This works nicley but how can i get hold of the selected items in the code behind?

  Read the article

• JFileChooser select directory but show files

  - by Jeff Storey

  I feel like there should be a simple way to do this but I can't figure it out. I have a JFileChooser that allows the user to select directories. I want to show all the files in the directories to give the user some context, but only directories should be accepted as selections (maybe the Open button would be disabled when a file is selected). Is there an easy way of doing this?

  Read the article

• Right way to handle friend-multi-select post on facebook, issues with session

  - by simple

  Do I need a infinite key with fbml facebook app that resides on fanpage? I am asking user to select user and posting it(facebook posts) to my server. On my server I want to get user_id and selected friends Id. Everything is fine with selected friend_ids, but have issues with getting id of a user. sometimes I can get it all fine, sometimes I am getting session expired exception, sometimes I get nothing. any ideas why this is happening?

  Read the article

• Select all entities of exact class, but not derived from it using NHibernate Criteria API

  - by SergeanT

  I have two classes: Cat and DomesticCat, that extends Cat. I want to select all Cats, but no oneDomesticCat. How to do it using NHibernate criteria API?

  Read the article

• Select number of rows in all tables in the database

  - by Alex N.

  I wonder if this is possible with straight SQL on MySQL. I need to do SELECT COUNT(*) FROM on each table in the database and output results in one result set. Is it possible to do with just SQL?

  Read the article

• Avoid Select All option on a web page in ie

  - by Geetha

  Hi, I am working on a application for touch screen device. I want to avoid the select all option of the web page on the ie. How to do this. Geetha

  Read the article

• convert to UDF from select statement

  - by jeff

  How would one go about converting this into a UDF? I'll pass the product_id to the UDF. Running SQL 2k5 SELECT sum(qty) as qty, product_id FROM vProductQuantity WHERE product_id = @product_id GROUP BY product_id

  Read the article

• mysql - How select a akin records?

  - by zeroonea

  I have a table with name varchar address varchar country varchar city varchar ..... to store address of location example: name|address|country HaLong hotel|156 blahblah street|Vietnam Hotel Ha Long|156 blah blah|Vietnam Two rows above is duplicate data. I have a form, when user submit new location. The code need to find akin records to give a message (ex: This location already in db, use it or create new?) How to make a query to get akin record like this?

  Read the article

• Mysql Trigger to select and delete

  - by Karthick

  Hi, Is this possible, can a trigger in mysql can do a select first and then based on its result do a delete?, both on the same table. Am struggling to get it right. There are duplicate entries in a table, i need to have a trigger which selects and then deletes. Any ideas or thoughts will be really helpful.

  Read the article

• what does select @@identity do?

  - by every_answer_gets_a_point

  i am connecting to a mysql database through excel using odbc what does this line do? Set rs = oConn.Execute("SELECT @@identity", , adCmdText) i am having trouble updating the database: With rs .AddNew ' create a new record ' add values to each field in the record .Fields("datapath") = dpath .Fields("analysistime") = atime .Fields("reporttime") = rtime .Fields("lastcalib") = lcalib .Fields("analystname") = aname .Fields("reportname") = rname .Fields("batchstate") = "bstate" .Fields("instrument") = "NA" .Update ' stores the new record End With it is ONLY updating .Fields("instrument") = "NA", but for all other fields it is putting NULL values

  Read the article

• mysql select records greater than 3 months

  - by fire

  I am trying to write a query to select all records from users table where User_DateCreated (datetime field) is = 3 months from today. Any ideas? Thanks!

  Read the article

• select records from table in the order in which i inserted

  - by echo

  consider a tale is as follows, EmployeeId | Name | Phone_Number Now, i insert 10 records... When i query them back, select * from myTable they are not selected in the order i inserted. I can obviously keep an autoincrement index and ORDER BY index. But i dont want to alter the table. How can i do this without altering the table?

  Read the article

< Previous Page | 231 232 233 234 235 236 237 238 239 240 241 242  | Next Page >