Search Results

Search found 25175 results on 1007 pages for 'dispatch table'.

Page 663/1007 | < Previous Page | 659 660 661 662 663 664 665 666 667 668 669 670  | Next Page >

• performSelectorInBackground, notify other viewcontroller when done.

  - by Michiel

  Hi, I have a method used to save an image when the user clicks Save. I use performSelectorInBackground to save the image, the viewcontroller is popped and the previous viewcontroller is shown. I want the table (on the previousUIViewController) to reload its data when the imagesaving is done. How can I do this? The save method is called like this: [self performSelectorInBackground:@selector(saveImage) withObject:nil]; [self.navigationController popViewControllerAnimated:YES];

  Read the article

• Microsoft SQL Server 2005 Function, passing list of start and end times

  - by Kevin

  I'd like to do had a dynamic number of one start/end time pairs passed to a function as an input parameter. The function would then use the list instead of just one start, and one end time in a select statement. CREATE FUNCTION [dbo].[GetData] ( @StartTime datetime, @EndTime datetime ) RETURNS int AS BEGIN SELECT @EndTime = CASE WHEN @EndTime > CURRENT_TIMESTAMP THEN CURRENT_TIMESTAMP ELSE @EndTime END DECLARE @TempStates TABLE (StartTime datetime NOT NULL , EndTime datetime NOT NULL , StateIdentity int NOT NULL ) INSERT INTO @TempStates SELECT StartTime , EndTime , StateIdentity FROM State WHERE StartTime <= @EndTime AND EndTime >= @StartTime RETURN 0 END

  Read the article

• Generating report with MySQL and Rails - how?

  - by Arywista

  Here is my data model from my application: id :integer(4) not null, primary key spam :boolean(1) not null duplicate :boolean(1) not null ignore :boolean(1) not null brand_id :integer(4) not null attitude :string not null posted_at :datetime not null Attitude could have 3 states: negative, positive, neutral. I want to generate resultset in table, this way, for each day between start and end date: date | total | positive | neutral | negative 2009-10-10 | 12 | 4 | 7 | 1 (...) 2009-10-30 | 5 | 2 | 1 | 1 And ignore all records which have: duplicate = true ignore = true spam = true How it's could be done?

  Read the article

• Any guidelines to follow to design database Metadata Repository ?

  - by Shamik

  I would like to design a metadata repository for the internal database. The repository should be able to provide simeple answers to questions like - which tables have what type of data and what are the table relationships ? Any industry standard guidelines that I should follow ?

  Read the article

• How Can I Import Data From Sql Server CE DataBase File To Excel?

  - by hosseinsinohe

  Hi How Can I Import Data From a Table in Sql Server CE To Excel? I Try This From Excel But I Can Not Find an Item for This In Excel Please Help Me To This

  Read the article

• Is it possible to write in a two-columns style in restructuredtext?

  - by attwad

  I would like to write a research paper using restructuredtext, is it possible to have the two-column style inherent to this kind of document? I looked at the specifications but appart using a table wich will be a real pain I haven't be able to find an alternative. Any help would be greatly appreciated, thanks!

  Read the article

• Is there any query in sqlite to choose a substring ?

  - by john terry

  Hey, Lets say I have a table Y with column X. There is one row of "X" with the string "abcdefg", and another row with "qwerty". Can I make a SELECT query in sqlite to choose the row which contains the substring "abcd" ? Thanks in advance.

  Read the article

• How to insert / retrieve a file stored as a BLOB in a MySQL db using python

  - by Phage

  I want to write a python script that populates a database with some information. One of the columns in my table is a BLOB that I would like to save a file to for each entry. How can I read the file (binary) and insert it into the DB using python? Likewise, how can I retrieve it and write that file back to some arbitrary location on the hard drive?

  Read the article

• How to do a join with ttwo tables ??

  - by bahamut100

  HI, I try to translate this query : SELECT * FROM `reunion` , lieu WHERE reunion.lieu_reunion = lieu.id_lieu to propel query : $c=new Criteria(); $c->addJoin(ReunionPeer::LIEU_REUNION,LieuPeer::ID_LIEU, Criteria::LEFT_JOIN); $this->reunions = ReunionPeer::doSelect($c); But in my template, when I made a print_r($reunions), the field "ville" (from the table 'lieu') is not present. Why ??

  Read the article

• How do I update a cumulative field in a Rails database (using ActiveRecord or Mongoid)?

  - by picardo

  I want to update a field in a database table that has to have a cumulative value. So basically I need to find the current value of the field and update it using a new number. My first inefficient try at this (in Mongoid) is: v = Landlord.where(:name=>"Lorem") v.update_attributes(:violations=>v.violations + 10) Is there a simple method than making one query to read, then sum up, and another query to write?

  Read the article

• Where clause in nhibernate map

  - by Phil Whittaker

  I have an Nhibernate hbm that maps a many to many relationship. For database simplicity it uses a where clause on the bag to filter the joining table. this works well until I start to test and I use the hbm file to create a database from the generated schema. The root and user tags columns aren't created. In the hbm file how do I define these two columns so they are generated in the schema?

  Read the article

• Parsing a file with column data in Python

  - by rejinacm

  I have a file that contains the symbol table details.Its in the form of rows and columns. I need to extract first and last column. How can I do that?

  Read the article

• Selecting records with specific month and year in SQL Server 2005

  - by John

  I want to list records with a particular month and year. The table name is 'Arrival' and 'date' is the field that stores the date that the record was added. This is to be done from a C# application. For example, if the user selects month as 'April' and year as '2009' in the application, it will list all the records that were added on April,2009. (I only need the query, hope I can figure out the rest :) )

  Read the article

• What is difference between @Resource UserTransaction and EntityManager.getTransaction()

  - by Nitesh Panchal

  Hello, Can anybody explain what is difference between :- @Resource UserTransaction objUserTransaction; and EntityManager.getTransaction(); And also what is container managed transaction? and how should i do it in my session facade if i want to insert three rows in table in transaction.

  Read the article

• Core Data Change property value when another property changes

  - by user320587

  Hi, I have a Core Data Entity which has three properties startDate, endDate and duration. All three properties are persistent properties. I would like to know how I can calculate and update the duration property whenever the value for startDate and endDate changes? BTW, I won't be able to make the duration as transient property since I have to use the property for sorting in my table view? Any help is greatly appreciated Thanks, Javid

  Read the article

• MySQL: How can fetch SUM() of all fields in one Query?

  - by takpar

  Hi, I just want somthing like this: select SUM(*) from `mytable` group by `year` any suggestion? (I am using Zend Framework; if you have a suggestion using ZF rather than pure query would be great!) Update: I have a mass of columns in table and i do not want to write their name down one by one. No Idea??

  Read the article

• jqueryUI Slider: Setting minimum and maximum values in range from DB

  - by alexBrand

  I have a jQueryUI slider on my website that deals with price range. I have a products table in mysql that has various entries. I am using the slider to filter the results, but I need to set the minimum and maximum prices from the records in my database. Should I just generate (with php) hidden fields in my html that contain the minimum and maximum and then use jQuery to obtain them? Or is there a better way of achieving this, maybe using AJAX? Thanks

  Read the article

• Watin: Clicking on a element works in debug mode but not otherwise

  - by Vadi

  I've below code which basically clicks on a Click event present a table, browser.Frame("f").Element("Table1").Click(); it works properly when during debug mode (like if i put a break point and execute it). But, it does not work when i run it in a flow, I've used SimpleTimer to wait until Settings.WaitForCompleteTimeOut, but no use. Any help?

  Read the article

• Where does Drupal store user permissions in the database?

  - by Ryan Nelson

  Does anyone know where Drupal stores, in the Database, the role of a user? It's not in the users table, and I can't seem to find it. I can find where it defines the role, defines the role's permissions, but I can't find where it defines what Role a certain User is. Anyone know? Thanks!

  Read the article

• Need help converting SQL to EF4 please

  - by Ken Eldridge

  I need help converting this SQL statement, into EF4: Select Posts.PostID, Post, Comment from Posts left join Comments on posts.PostID = Comments.PostID Where CommentID not in ( Select PostID from Votes where VoteTypeID = 4 --4 = flagged comment type ) In my database, the Votes table stores either the PostID of reported posts, or CommentID of reported comments in the column Votes.PostID Thanks in advance!

  Read the article

• WordPress Business Directory - best approach

  - by NTulip

  I want to implement a business directory in WordPress and I am looking for feedback on the best approach: I have a categories and a businesses table Do I create a page for every business together with it's category relationship Do I create a page and assign it a template? What are the ups and downs with each approach? Looking for some answers from people that might of already done this and can speak from experience

  Read the article

• Non-SQL API for SQL Server?

  - by David Lively

  Is there any sort of non-SQL API for talking to SQL Server? I'm curious if there is a more direct way to retrieve table or view data. (I don't have a problem with SQL, just curious if any of the layer between the SQL parser and the underlying data store is exposed.)

  Read the article

• Oracle Rows into Columns

  - by user2904845

  Can someone help me design the query to get below o/p. Data I have: Table X: Count Name Amount Days 5 ABC 500 Day1 10 ABC 1000 Day2 3 BCD 100 Day1 4 BDC 200 Day2 Result I need: Name Count AmountDay1 Count AmountDay2 ABC 5 500 10 1000 BCD 3 100 4 200 etc Is this Possible? I tried something with the below query, but not getting the desired o/p select * from X pivot (sum(amount) for days in ('Day1', 'Day2')) Please help I'm using Oracle 11 G

  Read the article

• How to check user id already exists

  - by Sheery

  Hi Friends, I am a beginner coder, i am building a project using C# Asp.Net in which i am registering users with a user id, now my question is that how to check that the user id is already exists in the user table or not when user trying to register, i am using sql server 2000?

  Read the article

• mySQL: Joining three tables - how?

  - by Industrial

  Hi everybody, I have the following query in my application. It works well, but I need it to also contain the number of products that are associated with each manufacturer. The current query: SELECT * FROM (`manufacturers`) JOIN `languages` ON `manufacturers`.`lang` = `languages`.`id` ORDER BY `languages`.`id` asc, `id` asc My products table looks like this: id | name | manufacturerid 0 | Product1 | 0

  Read the article

< Previous Page | 659 660 661 662 663 664 665 666 667 668 669 670  | Next Page >