Search Results

Search found 22463 results on 899 pages for 'sub query'.

Page 631/899 | < Previous Page | 627 628 629 630 631 632 633 634 635 636 637 638  | Next Page >

• DISTINCT clause in SQLite

  - by Eye of Hell

  Hello. Recently i found that SQLite don't support DISTINCT ON() clause that seems postgresql-specific. For exeample, if i have table t with columns a and b. And i want to select all items with distinct b. Is the following query the only one and correct way to do so in SQLite? select * from t where b in (select distinct b from t)

  Read the article

• what does a tool like Jasper Reports give me?

  - by Itay Moav

  Ok, So I have to generate very complex reports from my DB. If I am to do it with SQL the query themselves will be complex, and I will have to do some more manipulation on the results later, code level. How do libraries like Jasper Reports/ Crystal Reports and friends save me time when developing such reports? What will they give me?

  Read the article

• some fields of "content//sms/"

  - by soclose

  Hi, I query "content//sms/" and don't know what some fields are. They are - Thread ID Protocol Status Reply_Path_Present Service_Center I check them in LogCat. I find them like below Thread ID : 1 to 6 etc.. Protocol : null / 0 Status : -1 Reply_Path_Present : null / 0 Service_Center : null Please tell me what they are.

  Read the article

• Hyperlink for each record

  - by shantanuo

  I need a link for each depotname that will bring up a child window with the details of the last 10 backup status. while($data=mysql_fetch_array($res)) { if(is_null($depot_array) || !in_array($data['depotname'],$depot_array )) { $depot_array[$r]=$data['depotname']; if($data['SCP_status'] <> 'success') { echo "<tr id='fail'>"; The results of the following query should be displayed in a child window. select * from backup_log where depotname = $data['depotname']

  Read the article

• Drop group of stored procedures by name

  - by Kate

  I have group of stored procedures with names like 'somename_%'. Are there any way to delete that SP with one query, forexample DROP PROCEDURE where name like 'somename_%' .

  Read the article

• SQL: count days in date range?

  - by John Isaacks

  I have a query like this: SELECT COUNT(*) AS amount FROM daily_individual_tracking WHERE sales = 'YES' AND daily_individual_tracking_date BETWEEN '2010-01-01' AND '2010-03-31' I am selected from a date range. Is there a way to also get the total days in the date range?

  Read the article

• Get list of surrounding buildings based on coordinates from open database on Web

  - by Pentium10

  I would like to get a list of well-known buildings(museums, castles etc..) within X meters radius of the current coordinate. I would like to query them in PHP. Do you know any such database that can be queried?

  Read the article

• Is it possible for navigation based application to switch to any other orientation mode?

  - by Rajendra Bhole

  Hi, My application is completely navigation based and my query is that navigation based application can switch to any mode i mean orientation to portrait to landscape. Please help me out Thanks in advance

  Read the article

• importing and appending results of queries from different db in one db

  - by user316833

  I have 1000+ access files. Each file has a query named "overview" that has the same fields in each of the 1000 files. I need to import the results of these 1000+ overview queries into one single access db and append them into one table. Is there an automated way to do this? Thanks very much.

  Read the article

• Store LAST_INSERT_ID() in a transaction

  - by Oden

  Hi, I use codeigniter's database abstarction, and im doing a transaction with it. My problem is, that i have several inserts into several tables, but i need the insert id from the first insert query. Is there any way to store the last insert id for more than one following insert?

  Read the article

• sizeof(class) c++

  - by badkya

  How is it possible for sizeof(class) to return two different values depending on context? The class itself should have the same size right irrespective of where I ask this question? I see a smaller value when querying class size from main() and another when I query class size from an extended class.

  Read the article

• Update all table rows but top N in Mysql

  - by arthurprs

  I was trying to run the following query UPDATE blog_post SET `thumbnail_present`=0, `thumbnail_size`=0, `thumbnail_data`='' WHERE `blog_post` NOT IN ( SELECT `blog_post` FROM blog_post ORDER BY `blog_post` DESC LIMIT 10) But Mysql doesn't allow 'LIMIT' in an 'IN' subquery. I think I can make a select to count the table rows and then make an ordered update limited by 'COUNT - 10', but I was wondering if there is a better way. Thanks in advance.

  Read the article

• Stock Symbols using python

  - by nimmyliji

  Hi all, Hi, I am looking for some stock symbol look-up API. I could able to query yahoo finance with a symbol & could able to retrieve the stock price & other details. Is there any API for stock symbol searches Any help would be great .. Thanks

  Read the article

• How do you keep the order using SELECT WHERE IN()?

  - by Pepper

  Is there a way to keep the order when using SELECT WHERE IN()? For example, using the following query: SELECT id FROM data_table WHERE id IN(56,55,54,1,7); The results will come back using the default order by id. 1,7,54,55,56 When I want to keep the order used in the IN: 56,55,54,1,7 Is there a quick way to do this in mySQL or will I be forced to order it after in code. Thanks :)

  Read the article

• MS Access: index optimisation

  - by Patrick Honorez

  Let's say we have a [Valuations] table containing several values per date and per fund: -FundId -ValDate -Value1 -Value2... The Primary key is obviously FundId+ValDate. I have also indexed the ValDate field since I often query for values on a specific date. My question is: should I also create a specific index for the FundId, or is MsAccess clever enough to use the Primary key when querying on a specific FundId ?

  Read the article

• What's the best way to index many-to-one relation with hibernate search?

  - by tabdulin

  I have an entity with many-to-one mapping. (Product 1-* Regions, unidirectional association) What is the best way to store index of such relation? So it can be easily used to filter search query .

  Read the article

• How to handle touch events on UI Controls

  - by Sreelatha

  Hi, I have a query related to Touch events on the UI controls. I have 4 controls on the screen ( UITextField, UISlider, UISwitch, UIButton ). If the user touches any of the control on the screen, I want to fire touchesBegan and touchesEnded events on those controls in which I would implement some code. Please let me know how to fire these events. Thanks in advance, Sreelatha.

  Read the article

• Insert or update when product is present using mysql

  - by Aryan

  main_product table productid outward shopid 333 2 44//present 343 4 44//present 353 5 44//present 363 1 44//present 373 2 44//not present min_product table productid outward shopid 333 1 44 343 1 44 353 1 44 363 1 44 SELECT DISTINCT (A.productid),A.outward, B.productid,B.outward FROM main_product A INNER JOIN min_product B on B.productid=A.product_id where A.shopid='44' and B.shopid='44' my question how can i INSERT OR UPDATE in one query using mysql by checking if it is present or not if present update else insert something like this? INSERT INTO mytable (key, value) VALUES ($newkey, $newvalue) ON DUPLICATE KEY UPDATE SET value = $newvalue

  Read the article

• Zend_Paginator / Doctrine 2

  - by Kevin

  I'm using Doctrine 2 with my Zend Framework application and a typical query result could yield a million (or more) search results. I want to use Zend_Paginator in line with this result set. However, I don't want to return all the results as an array and use the Array adapter as this would be inefficient, instead I would like to supply the paginator the total amount of rows then and array of results based on limit/offset amounts. Is this doable using the Array adapter or would I need to create my own pagination adapter?

  Read the article

• mysql on xp performance issues

  - by dave

  Please could you let me know if there are any performance issues with using mysql on windows xp. The mysql serves over 10 client server apps, which query the database simultaneously

  Read the article

• SQL SERVER 2000 is Slow & linked server send an error "Server dosen't exisit or Access is denied"

  - by amin

  Dears , I have a prolblem in my SQL SERVER 2000 , the server is so slow when i made any query and recently i couldn't link with other sql servers the message is "the server dosen't exists or access id denied" in spite of that the linked servers were working well and i can access them remotly & the service pack is SP4... any body can help .. thanks again.

  Read the article

• How to decrypt a password from SQL server?

  - by sef

  I have this query in sql server 2000: select pwdencrypt('AAAA') which outputs an encrypted string of 'AAAA': 0x0100CF465B7B12625EF019E157120D58DD46569AC7BF4118455D12625EF019E157120D58DD46569AC7BF4118455D How can I convert (decrypt) the output from its origin (which is 'AAAA')?

  Read the article

• How can I get file size in Perl before processing upload request?

  - by zeina

  I want to get file size I'm doing this: my $filename=$query->param("upload_file"); my $filesize = (-s $filename); print "Size: $filesize ";` Yet it is not working. Note that I did not upload the file. I want to check its size before uploading it. So to limit it to max of 1 MB.

  Read the article

• How to trigger an application in mobile automatically

  - by san6086

  My idea is to make an application start automatically when a message from a specific user reaches the inbox of the mobile . For example if my friend sends some numbers to my mobile, the sms has to be read and validated first and then calculator ( inbuilt mobile application) has to be triggered and process the numbers from the message. Please help me with the above query.

  Read the article

• Set Positions returns E_NOTIMPL

  - by Manish

  Hi, I want to write only a specific portion of a .avi file in the output .avi file .For this I follow Source Filter -Avi mux-File Writer.I try to use IMediaSeeking on the Mux to set the specific start and stop times using Set Positions but it returns E_NOTIMPL. I also try to query the graph builder for IMediaSeeking and try to set the start and stop positions with no success.Can someone help?

  Read the article

< Previous Page | 627 628 629 630 631 632 633 634 635 636 637 638  | Next Page >