Search Results

Search found 27691 results on 1108 pages for 'multi select'.

Page 83/1108 | < Previous Page | 79 80 81 82 83 84 85 86 87 88 89 90  | Next Page >

• MYSQL: Pull Only Words with Minimum Character length

  - by elmaso

  Hi, how can I pull only words with maximum 50 Characters from MYSQL? $query = "SELECT * FROM example ORDER BY ID DESC LIMIT 200";

  Read the article

• Calculate the SUM of the Column which has Time DataType:

  - by thevan

  I want to calculate the Sum of the Field which has Time DataType. My Table is Below: TableA: TotalTime ------------- 12:18:00 12:18:00 Here I want to sum the two time fields. I tried the below Query SELECT CAST( DATEADD(MS, SUM(DATEDIFF(MS, '00:00:00.000', …

  Read the article

• ocupation and business type drop down lists

  - by Phil Jackson

  Hi, does anyone know of an API or where I could get hold of data/script to create a <select> drop down lists for occupation and job type? Regards, Phil

  Read the article

• How to write this query in Linq2Sql

  - by RememberME

  I have a table company which holds the company_id, company_name and other details. I have a table subcontracts which has a company_id column that maps to company.company_id. How can I write a select statement to get all companies which have not been assigned to a subcontract? IE The company_id cannot be found in subcontracts.company_id

  Read the article

• change img src on select box selection

  - by user1871596

  i have a form that auto populates input fields using jquery and ajax i can not get the img url to change in the img src when i select the option from dropdown my dropdown is dynamicaly populated here is is my function <script type="text/javascript"> $(document).ready(function(){ $("#id").change(function(){ $.ajax({ …

  Read the article

• Notepad++ -like line-selecting in textarea with jquery?

  - by Martti Laine

  Hey Is is possible to trigger a link to select a single line inside textarea. If it is, how? Martti Laine

  Read the article

• Which is the fastest way to retrive all items in SQLite?

  - by sxingfeng

  I am programming on windows, I store my infors into sqlite. However I find to get all items is a bit slow. I am using the following way: select * from XXX; retriving all items in 1.7M SQLite DB takes about 200-400ms, It is too slow. Can Anyone Help! Many Thanks!

  Read the article

• Parameter has no value

  - by Simon

  string queryString = "SELECT SUM(skupaj_kalorij)as Skupaj_Kalorij " + "FROM (obroki_save LEFT JOIN users ON obroki_save.ID_uporabnika=users.ID)" + "WHERE users.ID= " + a.ToString() + " AND obroki_save.datum =?"; using (OleDbCommand cmd = new OleDbCommand(queryString,database)) …

  Read the article

• MySQL> Selecting from more tables (with same columns) without UNION

  - by Petr

  Hi, It is probably pretty simple but I cannot figure it out: Say I have tables A and B both with the same columns. I need to do SELECT * FROM A,B without having results merged into one row. I.e. when each table has 2 rows, I need the result to have 4 rows. EDIT: I know about JOIN but dont know how to join the tables without predicate. I need…

  Read the article

• Selecting first records of a type in a given period

  - by Emanuil Rusev

  I have a database table that stores user comments: comments(id, user_id, created_at) I want to get from it the number of users that have commented for the first time in the past week. Here's what I have so far: SELECT COUNT(DISTINCT `user_id`) FROM `comments` WHERE `created_at` BETWEEN DATE_SUB(NOW(), INTERVAL 7 DAY) AND NOW() …

  Read the article

• mysql left join queries

  - by Mike79

  I have a question about the snippet below. I'm wondering, if the first query doesn't bring any results, would I still get the results for the second query? select * from ( -- first query ) as query1 left join ( -- second query ) as query2 on query1.id=query2.id left join ( -- third query ) as query3 on query1.id=query3.id; …

  Read the article

• mySQL query not returning correct results!

  - by Pete Herbert Penito

  Hi! This query that I have is returning therapists whose 'therapistTable.activated' is equal to false as well as those set to true! so it's basically selecting all of the db, any advice would be appreciated! ` $query = "SELECT therapistTable.* FROM therapistTable …

  Read the article

• How to use value from primary accessdatasource control as parameter in select query for secondary ac

  - by weedave

  Hi, I'm trying to display all orders placed and I have a primary accessdatasource control that has a select query to get the customer information and the orderID. I want to use the orderID value from this first query as a parameter for the secondary accessdatasource control that selects the product information of the products in…

  Read the article

• Is it possible to capture data from a WHERE clause?

  - by Kristopher Ives

  I have a scenario where I'm calculating something in the WHERE clause of my SQL, but I also want to get that calculation - since it's expensive. Is it possible to get the results of something done in the WHERE clause, like this: SELECT `foo` FROM `table` WHERE (foo = LongCalculation()) Wishful thinking, or possible with MySQL?

  Read the article

• How to get this done in mysql?

  - by bala3569

  Consider i have a registartion table and there is field prefLocationId and it contains value like this 1,2,3,2,1,4 and so many.... And i have a table prefLocation which looks like this Id LocationName 1 Chennai 2 Mumbai 3 Kolkatta 4 Delhi and i want to select record of users and show values like …

  Read the article

• Linux signals with extra information parameter

  - by Tester

  I was to have some extra information in the callback to sa_sigaction handler, it does not seems possible. So I was wondering if you could suggest me alternatives. Basic requirements: Function A raises an signal/event with a pointer to a struct Handler function tackles the event. The handler function…

  Read the article

• SQL ENQUIRY In how to Get defined number of records

  - by ramadan2050

  I have a select statement, retrieve about 1000 record I want to modify it to return only some records defined by @startIndex and @count e.g. : If I said @startIndex=20 and @count=20 the result will be : from the 21th record to 40th I try to make it, but it take the same time as if I retrieve the 1000…

  Read the article

• How can I show just the icon of the currently selected option?

  - by Paul Tomblin

  Is it possible to have a bunch of <select> dropdowns in html that only display a small (say 10 pixels wide) icon, but when you click it the drop down has a list with the icons beside a descriptive string. (Let's see if ASCII art works on SO): [X] | X - Disable | | v/ - Enable | | O - Ignore |…

  Read the article

• MYSQL - Query to check against other table (hard to explain...)

  - by Sam

  I have a query that gets a list of emails who have subscribed for a newsletter trial which lasts 30 days.. $thirty = time() - 3024000; SELECT c.email FROM tbl_clients AS c JOIN tbl_clientoptions AS o ON o.client = c.id WHERE o.option = 'newsletter' AND c.datecreated $thirty What I want to do is do…

  Read the article

• MySQL: How to do a conditional update?

  - by Tom

  Hi, I'm trying to a create an update statement along the following lines: TABLE car: id | owner_id | type | status An owner can have multiple cars. UPDATE car c SET c.type = 1 WHERE c.owner_id IN ($ids) AND c.status = [1 IF IT EXISTS, ELSE 0] $ids is reasonably small (under 50…

  Read the article

• Symfony: there is a "0" (zero) in a sfWidgetFormChoice

  - by user248959

  Hi, i want to show a select which options are the character '-' and a range of integers. I have this: $years = range(14,130); new sfWidgetFormChoice(array('choices' => array_merge(array('' => '-',array_combine($years,$years))); The problem: between the '-' and the range of…

  Read the article

• What is wrong with this sql statement?

  - by chandru_cp

  I am trying to fetch records based on two dates from sql server... Select * from table where CreatedDate between @StartDate and @EndDate and i pass 5/12/2010 and 5/12/2010 (ie) fetching records for today... I have 17 records dated 5/12/2010 but none seems to get selected.... EDIT: I use this…

  Read the article

• Dual booting Windows 7 & 8.1, using the Windows 8 Startup Options Menu, when Windows 8.1 is already installed and you want to add Windows 7

  - by Josh

  There are many excellent guides out there that explain how to dual-boot Windows 7 & 8. However, they are written for people starting with a Windows 7 installation and add a Windows 8 installation to separate partition. From what I'm reading, following this procedure will result in…

  Read the article

• Disable Windows 8 edge gestures/hot corners for multi-touch applications while running in full screen

  - by Bondye

  I have a full screen AS3 game maby with Adobe AIR that runs in Windows 7. In this game it may not be easy to exit (think about kiosk mode, only exit by pressing esc and enter a password). Now I want this game to run in Windows 8. The game is working like expected but the anoying…

  Read the article

• Multi-line strings in objective-c localized strings file

  - by chrispix

  I have a template for an email that I've put in a localized strings file, and I'm loading the string with the NSLocalizedString macro. I'd rather not make each line its own string with a unique key. In Objective-C, I can create a human-readable multiline string like so: …

  Read the article

< Previous Page | 79 80 81 82 83 84 85 86 87 88 89 90  | Next Page >