Search Results

Search found 32970 results on 1319 pages for 'zend db select'.

Page 412/1319 | < Previous Page | 408 409 410 411 412 413 414 415 416 417 418 419  | Next Page >

• How do I test the speed of a mySQL query?

  - by Chris

  I have a select and query like below... $sql = "SELECT * FROM notifications WHERE to_id='".$userid."' AND (alert_read != '1' OR user_read != '1') ORDER BY alert_time DESC"; $result = mysql_query($sql); how do I test how long the query took to run?

  Read the article

• Binary string search on one field.

  - by CrazyJoe

  I have 300 boolean fields in one table, and im trying to do somithing like that: One string field: 10000010000100100100100100010001 Ha a simple way to do a simple search os this field like: select * from table where field xor "10000010000100100100000000010001" Im tring this but is to long: select * from teste where mid(info,2,1) and mid(info,3,1) :) Help!!

  Read the article

• Difference between "and" and "where" in joins

  - by Midhat

  Whats the difference between SELECT DISTINCT field1 FROM table1 cd JOIN table2 ON cd.Company = table2.Name and table2.Id IN (2728) and SELECT DISTINCT field1 FROM table1 cd JOIN table2 ON cd.Company = table2.Name where table2.Id IN (2728) both return the same result and both have the same explain output

  Read the article

• Can php query the results from a previous query?

  - by eaolson

  In some languages (ColdFusion comes to mind), you can run a query on the result set from a previous query. Is it possible to do something like that in php (with MySQL as the database)? I sort of want to do: $rs1 = do_query( "SELECT * FROM animals WHERE type = 'fish'" ); $rs2 = do_query( "SELECT * FROM rs1 WHERE name = 'trout'" );

  Read the article

• Getting random values in mySql query

  - by Roland

  I have a query which selects 6 names in the database. eg SELECT names FROM users LIMIT 6 Now I want this query to select a random 6 names in the database table, is this possible? And how

  Read the article

• How can I preform operations on rows in a Tabular form in MS access?

  - by Justin Tanner

  I have a Tabular type Form based upon a SELECT * FROM table type of query in MS access. I would like to: check / select rows in this form iterate through the checked / selected rows

  Read the article

• Unknown Column In Where Clause

  - by Corpo

  I have a simple query: SELECT u_name AS user_name FROM users WHERE user_name = "john"; I get "Unknown Column 'user_name' in where clause". Can I not refer to 'user_name' in other parts of the statement even after select 'u_name as user_name'?

  Read the article

• i want to insert values from table1 to table2 with incremantal value

  - by adnan

  i tried something like this but the id value is not changing, getting the value for first record and set the value for all rest... insert into table1 (Id,b,c,d) (select (select max(Id)+1 from table1),x,y,z from table2 where... )

  Read the article

• [Django] How do I filter the choices in a ModelForm that has a CharField with the choices attribute

  - by nubela

  I understand I am able to filter queryset of Foreignkey or Many2ManyFields, however, how do I do that for a simple CharField that is a Select Widget (Select Tag). For example: PRODUCT_STATUS = ( ("unapproved", "Unapproved"), ("approved", "Listed"), #("Backorder","Backorder"), #("oos","Out of Stock"), #("preorder","Preorder"), ("userdisabled", "User Disabled"), ("disapproved", "Disapproved by admin"), ) and the Field: o_status = models.CharField(max_length=100, choices=PRODUCT_STATUS, verbose_name="Product Status", default="approved") Suppose I wish to limit it to just "approved" and "userdisabled" instead showing the full array (which is what I want to show in the admin), how do I do it? Thanks!

  Read the article

• SQL Server - How Do I Substract 2 Hours from Formatted Time

  - by user1842653

  I need to know how to add 2 hours to the below 'Completed' timestamp. Here is the Select statement Select Tsk.task_id,Tsk.org_id,Tsk.completed,Tsk.assgn_acct_id,name FROM tdstelecom.tasks As Tsk WHERE Tsk.task_id = '11094836' AND DATE(Tsk.completed) < CURDATE() AND DATE(Tsk.completed) >= DATE_SUB(CURDATE (),INTERVAL 180 DAY) Here are the results: 2012-08-22 14:18:14 Desired results: 2012-08-22 16:18:14

  Read the article

• Is there a way to fix the length of drop down list?

  - by Harry Pham

  <select> <option>...</option> ... </select> Is there a way to fix the length of the drop down list.

  Read the article

• Question about Benchmark function in Mysql ( Incredible results ).

  - by xRobot

  I have 2 tables: author with 3 millions of rows. book with 20 miles rows. . So I have benchmarked this query with a join: SELECT BENCHMARK(100000000, 'SELECT book.title, author.name FROM `book` , `author` WHERE book.id = author.book_id ') And this is the result: Query took 0.7438 sec ONLY 0.7438 seconds for 100 millions of query with a join ??? Do I make some mistakes or this is the right result ?

  Read the article

• How to construct these HQL statements

  - by losintikfos

  Do anyone know how to construct these two SQL statement in HQL; SELECT MIN(id) FROM Books WHERE mid < ? OR mid =? SELECT SUM(noOfBooks) FROM Bookcount WHERE mId=128

  Read the article

• Uncheck all checkboxes added as a group

  - by newbee

  I have 4 checkboxes added as a group so that I will be able to select only one checkbox. But if I select one of them and now want to uncheck all of them in a group, I am unable to do that. Any one has idea how can I do that?

  Read the article

• SQL: how to predicate over stored procedure's result sets?

  - by Ariel

  Simple question I couldn't figure out (not a SQL expert... sorry): I want to do a select on the result set of sp_who2. How can I? for ex. select SPID from [result set from sp_who2]

  Read the article

• Getting jQuery to recognise .change() in IE

  - by Philip Morton

  I'm using jQuery to hide and show elements when a radio button group is altered/clicked. It works fine in browsers like Firefox, but in IE 6 and 7, the action only occurs when the user then clicks somewhere else on the page. To elaborate, when you load the page, everything looks fine. In Firefox, if you click a radio button, one table row is hidden and the other one is shown immediately. However, in IE 6 and 7, you click the radio button and nothing will happen until you click somewhere on the page. Only then does IE redraw the page, hiding and showing the relevant elements. Here's the jQuery I'm using: $(document).ready(function(){ $(".hiddenOnLoad").hide(); $("#viewByOrg").change(function () { $(".visibleOnLoad").show(); $(".hiddenOnLoad").hide(); }); $("#viewByProduct").change(function () { $(".visibleOnLoad").hide(); $(".hiddenOnLoad").show(); }); }); Here's the part of the XHTML that it affects. Apologies if it's not very clean, but the whole page does validate as XHTML 1.0 Strict: <tr> <td>View by:</td> <td> <p> <input type="radio" name="viewBy" id="viewByOrg" value="organisation" checked="checked"/> Organisation </p> <p> <input type="radio" name="viewBy" id="viewByProduct" value="product"/> Product </p> </td> </tr> <tr class="visibleOnLoad"> <td>Organisation:</td> <td> <select name="organisation" id="organisation" multiple="multiple" size="10"> <option value="1">Option 1</option> <option value="2">Option 2</option> </select> </td> </tr> <tr class="hiddenOnLoad"> <td>Product:</td> <td> <select name="product" id="product" multiple="multiple" size="10"> <option value="1">Option 1</option> <option value="2">Option 2</option> </select> </td> </tr> If anyone has any ideas why this is happening and how to fix it, they would be very much appreciated!

  Read the article

• How to set user environment variables in Windows Server 2008 R2 as a normal user?

  - by likm

  In older versions of Windows, it was just open the Control Panel, select the System applet, select the Advanced tab, and then hit the Environment variables button. As a normal user, you could edit the "User variables" but not the "System variables". In Windows Server 2008 R2, if I try to hit the Advanced System settings option in the System applet, it prompts for the Administrator password.

  Read the article

• SQL is this equivalent to a LEFT JoIn?

  - by Jim

  Is this equivalent to a LEFT JOIN? SELECT DISTINCT a.name, b.name FROM tableA a, (SELECT DISTINCT name FROM tableB) as b It seems as though there is no link between the two tables. Is there an easier / more efficient way to write this?

  Read the article

• Localization of UI

  - by Nadeem

  I am working on localization project and when i change the language the UI gets disturbed because some translations are large. For example say there is button with text "Select All". But when this is localized in french it reads as "Sélectionner tout". That is larger than Select All and hence the gui gets affected. Is there any way to localize the gui as well.

  Read the article

• what does "foo" mean in SqlServer Query ?

  - by John

  for eg... SELECT * FROM ( SELECT RANK() OVER (ORDER BY stud_mark DESC) AS ranking, stud_id, stud_name, stud_mark FROM tbl_student ) AS foo WHERE ranking = 10 Here foo is present...actually what it does ?..

  Read the article

• Translate LINQ to sql statement

  - by zielu1

  Hi, I want to translate LINQ expression tree to SQL statement and I don't want to write my own code for this. Example: var query = from c in Customers where c.Country == "UK" && c.City == "London" select c); To SELECT ... FROM Customers AS c WHERE c.Country = "UK" AND c.City = "London" I know DataContext.Log, but I want to use: query.ToSqlStatementString() Thanks

  Read the article

• Selecting from a Large Table SQL 2005

  - by Eugene

  I have a SQL table it has more than 1000000 rows, and I need to select with the query as you can see below: SELECT DISTINCT TOP (200) COUNT(1) AS COUNT, KEYWORD FROM QUERIES WITH(NOLOCK) WHERE KEYWORD LIKE '%Something%' GROUP BY KEYWORD ORDER BY 'COUNT' DESC Could you please tell me how can I optimize it to speed up the execution process? Thank you for useful answers.

  Read the article

• Do any of the built in asp.net grid controls (or similiar) provide effecient data paging?

  - by Blankman

  I know in asp.net 1.0 the grid display controls would pull all the data in, and then provide paging but the paging was done in memory. Are there any smarter controls that provide paging where they only pull the data relevent to current page being displayed? ie. select 10 rows for the current page, instead of doing a select of ALL the rows in the table.

  Read the article

• check if a table exsist in where

  - by Luca Romagnoli

  This query generates an error because table2 doesn't exist: Select * FROM table WHERE table2.id IS NOT NULL Is there anything like this for check the table2 before apply the check on the id? Select * FROM table WHERE (EXIST(table2) AND table2.id IS NOT NULL) or not EXIST(table2) Thanks

  Read the article

• SQL with codition on calculated value

  - by user619893

  I have a table with products, their amount and their price. I need to select all entries where the average price per article is between a range. My query so far: SELECT productid,AVG(SUM(price)/SUM(amount)) AS avg FROM stock WHERE avg=$from AND avg<=$to GROUP BY productid If do this, it tells me avg doesnt exist. Also i obviously need to group by because the sum and average need to be per wine

  Read the article

< Previous Page | 408 409 410 411 412 413 414 415 416 417 418 419  | Next Page >