Search Results

Search found 27248 results on 1090 pages for 'table adapter'.

Page 767/1090 | < Previous Page | 763 764 765 766 767 768 769 770 771 772 773 774  | Next Page >

• Is there a way to fix the background image of a UITableView

  - by user337174

  Hi I have set the background of my UITable with a custom image. self.tableView.backgroundColor = [UIColor clearColor]; self.tableView.backgroundColor = [UIColor colorWithPatternImage:[UIImage imageNamed:@"background.png"]]; The problem im having is the background image is scrolling and doesn't look good at the top and bottom of the screen where you see the image being joined. Is there a way to fix the position of the background image and just have the table scroll over the top of it?

  Read the article

• MySQL Joining three tables

  - by text

  I am doing a query with three tables, the problem was one table has many occurrences of id of another. sample data: users: id answers: id:1 user_answer :1 id:1 user_answer :2 id:1 user_answer :3 Questions: id:1 answers :answer description id:2 answers :answer description id:3 answers :answer description How can I get all user information and all answer and its description, I used GROUP by user.id but it only returns only one answer. I want to return something like this list all of users answer: Name Q1 Q2 USERNAME ans1,ans2 ans1,ans2 comma separated description of answer here

  Read the article

• Pause animation in EAGLView which is in a UITableViewCell

  - by hanno

  I have an animation in a EAGLView which is itself in a UITableViewCell. How can I pause the animation in the EAGLView when the view is not visible? Normally, I would simply use the responsible UIViewController and listen to viewDidDisappear. But how do I do that if the EAGLView is in a table?

  Read the article

• Database is very slow when creating an index

  - by kaliyaperumal M

  My database has around 25 core numbers, in that weekly basis I need to create an index and drop index. While creating the index it takes long time to complete, my log file also keeps on increasing, and when I delete some numbers from that table also taking too much time (because weekly basis I have to delete 30 to 50 lack numbers and add 30 to 40 lack new number also). Can u please give me the proper solution..

  Read the article

• symfony: difference between doctrine model "User" and symfony "myUser"?

  - by fayer

  what is the difference between the symfony "myUser" and doctrine model "User"? where should i put the methods for an user? eg. $user-createThread(), $user-deleteThread() and so on should $user be an instance of the doctrine model User (cause i have a table called User) or the myUser that extends sfBasicSecurityUser? thanks!

  Read the article

• ParentId and Parent type in Entity Framework

  - by jonathan

  I have many entities (Customers, prospects,...) I have one entity called Notes, which can handle notes for Customers,prospects... The Notes table is then: Id Parent_Id Parent_Type Note How to handle this with Entity Framework ? Thanks Joghn

  Read the article

• Message reason why Execute method failed

  - by waanders

  I use the DAO method Execute to delete some records. If this fails this is clear by checking RecordsAffected (it will be 0). But is it possible to get the error message (for instance, to log or to show to the user)? I've try to delete the records by hand in the Table grid I get a clear dialog message, e.g. "The record cannot be deleted or changed because tabel x includes related records".

  Read the article

• How is the scope of a variable/identifier maintained?

  - by eswar

  How is the scope of a variable/identifier maintained in the symbol table of a c/c++ compiler. Please suggest some good links and books to know the how compiling process of c/c++ program is implemented for better understanding.

  Read the article

• mysql_fetch_row() not a valid result resource

  - by user1717305

  I am confused, I don't know what's wrong. I'm about to transfer all data from my first table to the other. Here is my code: $getdata = mysql_query("SELECT Quantity, Description, Total FROM ordercart"); while($row = mysql_fetch_row($getdata)) { foreach($row as $cell){ $query1 = mysql_query("INSERT INTO ordermem (Quantity, Description, Total) VALUES ($cell)",$connect); } mysql_free_result($getdata); } I get the error: Warning: mysql_fetch_row(): 5 is not a valid MySQL result resource.

  Read the article

• How do I see the results of unique records added after adding records to mysql

  - by billy

  I'm a PHP noob. I have a database that I will update weekly with a CSV. So far I've managed to upload the file to the server, open the file with PHP, and insert the data in my table. Now I want to return the unique records that were added (on screen or in a file). How do I do this?

  Read the article

• Is this SQL is valid?

  - by Beck

  UPDATE polls_options SET `votes`=`votes`+1, `percent`=ROUND((`votes`+1) / (SELECT voters FROM polls WHERE poll_id=? LIMIT 1) * 100,1) WHERE option_id=? AND poll_id=? Don't have table data yet, to test it properly. :) And by the way, in what type % integers should be stored in database? Thanks for the help!

  Read the article

• UITableViewCell: Allowing Selective Deletion

  - by Aran Mulholland

  I have a table view and want to allow rearranging of all cells, however there are certain cells that i do not want to be allowed to be deleted. when the UiTableView is put into deletion mode i do not want the red '-' button to appear on the left hand side, and do not want the swipe gesture to bring up the Delete button of these cells but want it to happen for the others. Any ideas?

  Read the article

• How to know constraints,indexes,sequences without reading data dictionary?

  - by Vineet

  I want to show indexes,sequences,constraints in DESC command ,is it possible, or any other cammand by which i can see structure(design) of a table along with constraints, sequences,indexes.

  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

• problem with IN clause in SQL

  - by user179056

  Hello, We have observed that there seems to be a maximum number of ids/variables which one can pass in the IN clause of SQL as comma seperated values. To avoid this we are storing all the ids in a table and doing a SELECT within the IN clause. This however means extra database operations to store and retrieve ids. Is there any other way to use IN without SELECT? regards Sameer

  Read the article

• Can I use the same DBML to access different tables?

  - by Sisiutl

  I have many tables with identical schemas but different names. Can I create a single representative DBML/DataContext and re-use it for all the tables, or do I have to drag every table into the dbml designer?

  Read the article

• Get consolidated results with following tables

  - by Ted

  I have a scenario. Here's my table structure is: ID LoginDate RemovalDate ---------------------------------------- 1 2009/08/01 NULL 2 2009/09/12 2010/01/02 3 2009/08/31 2009/10/29 4 2010/02/17 NULL 5 2009/10/18 2009/11/22 I want a consolidated results of how many ID's were not removed in a particular month. So the result set should be Date NotRemoved_ID -------------------------- 2009/08 2 2009/09 3 2009/10 3 [One ID got removed in 2009/10] 2010/02 2 [Two got removed in 2009/11 and 2010/01] Please help.

  Read the article

• How do I protect this function from SQL injection?

  - by dwbanks

  public static bool TruncateTable(string dbAlias, string tableName) { string sqlStatement = string.Format("TRUNCATE TABLE {0}", tableName); return ExecuteNonQuery(dbAlias, sqlStatement) 0; }

  Read the article

• how to get last weeek dates from today to last 7 days date..

  - by Ranjana

  i have a table with column: Registereddate orgid 2010-06-05 10:16:00 1 2010-06-05 10:10:00 2 2010-06-04 22:31:00 3 ... . . ..... . . . i need to get only last weeek dates and orgid from today to last 7 days date..

  Read the article

• mysql error dont understand what it is saying

  - by sea_1987

  Cannot add or update a child row: a foreign key constraint fails (`mydb`.`job_listing_has_employer_details`, CONSTRAINT `job_listing_has_employer_details_ibfk_2` FOREIGN KEY (`employer_details_id`) REFERENCES `employer_details` (`id`)) INSERT INTO `job_listing_has_employer_details` (`job_listing_id`, `employer_details_id`) VALUES (6, '5') What does this mean? The two ID's I am inserting into the table exsist.

  Read the article

• What would cause linq to sql to think that a parameter is nullable?

  - by chobo2

  Hi I have a stored procedure that declares a input parameter @BatchNumber uniqueidentifier This field in the table is set to not allow nullables. When I drag in the stored procedure and it hooks everything up it says the parameter is nullable. I don't understand why. Is this normal for it to think that the parameters are nullable?

  Read the article

• Running query from scratch with something like exec function?

  - by Steel Plume

  Hi, is it possible to make something similar to the following with Postgresql without using a function? pseudo sql code: select * from sometable where somecol = somevalue AND someothercol IN exec( 'select something from exclusionlist' ) My primary intention is to build up a table with predefined queries to call inside a where clause pseudo sql code: select * from sometable where somecol = somevalue AND someothercol IN exec( select query from predefinedqueries where id=someid )

  Read the article

• How to get the top most parent in PostgreSQL

  - by wereach

  I have a tree structure table with columns: id,parent,name. Given a tree A-B-C, how could i get the most top parent A's ID according to C's ID? Especially how to write SQL with "with recursive"? Thanks!

  Read the article

• Find word using JQuery

  - by tinti

  I need a little piece of advice. I have a test page with 2 fields: word number and URL Also i have a button Push. When i push the button i want to open the specified URL (it's local html files) and highlight the word at the "word number" position Of course the code must ignore element nodes (<p>,<b>,<table> and so on)

  Read the article

• Is it a good practice to have trim in setter?

  - by zibi

  I'm doing a code review and I noticed such a code: @Entity @Table(name = "SOME_TABLE") public class SomeReportClass { @Column(name = "REPORT_NUMBER", length = 6, nullable = false) private String reportNumber; ..... public String getReportNumber() { return reportNumber; } public void setReportNumber(String reportNumber) { this.reportNumber = StringUtils.trimToNull(reportNumber); } } Every time I see trimming inside of a setter I feel that its not the clearest solution - what is the general practice with that issue?

  Read the article

< Previous Page | 763 764 765 766 767 768 769 770 771 772 773 774  | Next Page >