Set the `UITableView` property [allowsSelectionDuringEditing][1] to `YES`.


[1]: https://developer.apple.com/documentation/uikit/uitableview/1614889-allowsselectionduringediting?language=objc

Set &quot;Editing&quot; property to &quot;Single Selection During Editing&quot;


How to debug python programs in emacs? 

I use `python-mode.el`

I get reference like 
   

    import pdb; pdb.set_trace();

but not sure how to use it.


Debugging python programs in emacs

I just stumbled upon something in ORACLE SQL (not sure if it&#39;s in others), that I am curious about. I am asking here as a wiki, since it&#39;s hard to try to search symbols in google... 

I just found that when checking a value against a set of values you can do 

    WHERE x = ANY (a, b, c)

As opposed to the usual 

    WHERE x IN (a, b, c)

So I&#39;m curious, what is the reasoning for these two syntaxes? Is one **standard** and one some oddball Oracle syntax? Or are they both standard? And is there a preference of one over the other for performance reasons, or ? 

Just curious what anyone can tell me about that &#39;= ANY&#39; syntax. 
CheerZ!

Oracle: &#39;= ANY()&#39; vs. &#39;IN ()&#39;

I have a UITableView where when I put it in editing mode, I want selective rows to be selectable, however, they are not. Is there a way I can force them to be selectable?

Selecting row while UITableView is in editing mode

<p>I have a UITableView where when I put it in editing mode, I want selective rows to be selectable, however, they are not. Is there a way I can force them to be selectable?</p>


Is there a way for UILabel to draw a border around itself? This is useful for me to debug the text placement and to see the placement and how big the label actually is.

How to draw border around a UILabel?

Let see that I have a string look like this:   

    NSString *longStr = @&quot;AAAAA\nBBBBB\nCCCCC&quot;;  

How do I make it so that the UILabel display the message like this   

&gt; AAAAA&lt;br /&gt;
&gt; BBBBB&lt;br /&gt;
&gt; CCCCC

I don&#39;t think `\n` is recognized by UILabel, so is there anything that I can put inside NSString so that UILabel knows that it has to create a line break there?

How to add line break for UILabel?

How do you make a **UINavigationBar transparent**? Though I want its bar items to remain visible.

Make UINavigationBar transparent

Alright, so I&#39;ve been doing some poking around, and I realize my problem, but I don&#39;t know how to fix it.  I have made a custom class to hold some data.  I make objects for this class, and I need to them to last between sessions.  Before I was putting all my information in `NSUserDefaults`, but this isn&#39;t working.

    -[NSUserDefaults setObject:forKey:]: Attempt to insert non-property value &#39;&lt;Player: 0x3b0cc90&gt;&#39; of class &#39;Player&#39;.

That is the error message I get when I put my custom class, &quot;Player&quot;, in the `NSUserDefaults`.  Now, I&#39;ve read up that apparently `NSUserDefaults` only stores some types of information.  So how an I get my objects into `NSUSerDefaults`?

I read that there should be a way to to &quot;encode&quot; my custom object and then put it in, but I&#39;m not sure how to implement it, help would be appreciated!  Thank you!

****EDIT****

Alright, so I worked with the code given below (Thank you!), but I&#39;m still having some issues.  Basically, the code crashes now and I&#39;m not sure why, because it doesn&#39;t give any errors.  Perhaps I&#39;m missing something basic and I&#39;m just too tired, but we&#39;ll see.  Here is the implementation of my Custom class, &quot;Player&quot;:

    @interface Player : NSObject {
    	NSString *name;
    	NSNumber *life;
    	//Log of player&#39;s life
    }
    //Getting functions, return the info
    - (NSString *)name;
    - (int)life;
    
    
    - (id)init;
    
    //These are the setters
    - (void)setName:(NSString *)input; //string
    - (void)setLife:(NSNumber *)input; //number    
    
    @end

Implementation File:


    #import &quot;Player.h&quot;
    @implementation Player
    - (id)init {
    	if (self = [super init]) {
    		[self setName:@&quot;Player Name&quot;];
    		[self setLife:[NSNumber numberWithInt:20]];
    		[self setPsnCounters:[NSNumber numberWithInt:0]];
    	}
    	return self;
    }
    
    - (NSString *)name {return name;}
    - (int)life {return [life intValue];}
    - (void)setName:(NSString *)input {
    	[input retain];
    	if (name != nil) {
    		[name release];
    	}
    	name = input;
    }
    - (void)setLife:(NSNumber *)input {
    	[input retain];
    	if (life != nil) {
    		[life release];
    	}
    	life = input;
    }
    /* This code has been added to support encoding and decoding my objecst */
    
    -(void)encodeWithCoder:(NSCoder *)encoder
    {
    	//Encode the properties of the object
    	[encoder encodeObject:self.name forKey:@&quot;name&quot;];
    	[encoder encodeObject:self.life forKey:@&quot;life&quot;];
    }
    
    -(id)initWithCoder:(NSCoder *)decoder
    {
    	self = [super init];
    	if ( self != nil )
    	{
    		//decode the properties
    		self.name = [decoder decodeObjectForKey:@&quot;name&quot;];
    		self.life = [decoder decodeObjectForKey:@&quot;life&quot;];
    	}
    	return self;
    }
    -(void)dealloc {
    	[name release];
    	[life release];
    	[super dealloc];
    }
    @end

So that&#39;s my class, pretty straight forward, I know it works in making my objects.  So here is the relevant parts of the AppDelegate file (where I call the encryption and decrypt functions):

    @class MainViewController;
    
    @interface MagicApp201AppDelegate : NSObject &lt;UIApplicationDelegate&gt; {
        UIWindow *window;
        MainViewController *mainViewController;
    }
    
    @property (nonatomic, retain) IBOutlet UIWindow *window;
    @property (nonatomic, retain) MainViewController *mainViewController;
    
    -(void)saveCustomObject:(Player *)obj;
    -(Player *)loadCustomObjectWithKey:(NSString*)key;
    
    
    @end

And then the important parts of the implementation file:

        #import &quot;MagicApp201AppDelegate.h&quot;
        #import &quot;MainViewController.h&quot;
        #import &quot;Player.h&quot;
        
        @implementation MagicApp201AppDelegate
        
        
        @synthesize window;
        @synthesize mainViewController;
        
        
        - (void)applicationDidFinishLaunching:(UIApplication *)application {
        NSUserDefaults *prefs = [NSUserDefaults standardUserDefaults];
        	//First check to see if some things exist
        	int startup = [prefs integerForKey:@&quot;appHasLaunched&quot;];
        	if (startup == nil) {
    //Make the single player 
    		Player *singlePlayer = [[Player alloc] init];
    		NSLog([[NSString alloc] initWithFormat:@&quot;%@\n%d\n%d&quot;,[singlePlayer name], [singlePlayer life], [singlePlayer psnCounters]]); //  test
    		//Encode the single player so it can be stored in UserDefaults
    		id test = [MagicApp201AppDelegate new];
    		[test saveCustomObject:singlePlayer];
    		[test release];
    }
    [prefs synchronize];
    }
    
    -(void)saveCustomObject:(Player *)object
    { 
    	NSUserDefaults *prefs = [NSUserDefaults	standardUserDefaults];
    	NSData *myEncodedObject = [NSKeyedArchiver archivedDataWithRootObject:object];
    	[prefs setObject:myEncodedObject forKey:@&quot;testing&quot;];
    }
    
    -(Player *)loadCustomObjectWithKey:(NSString*)key
    {
    	NSUserDefaults *prefs = [NSUserDefaults standardUserDefaults];
    	NSData *myEncodedObject = [prefs objectForKey:key ];
    	Player *obj = (Player *)[NSKeyedUnarchiver unarchiveObjectWithData: myEncodedObject];
    	return obj;
    }


Eeee, sorry about all the code.  Just trying to help.  Basically, the app will launch and then crash immediatly.  I&#39;ve narrowed it down to the encryption part of the app, that&#39;s where it crashes, so I&#39;m doing something wrong but I&#39;m not sure what.  Help would be appreciated again, thank you!

(I haven&#39;t gotten around to decrypting yet, as I haven&#39;t gotten encrypting working yet.)

How to store custom objects in NSUserDefaults

I have a `UITableView` with `UITextField`s as cells.  I would like to dismiss the keyboard when the background of the `UITableView` is touched.  I&#39;m trying to do this by creating a `UIButton` the size of the `UITableView` and placing it behind the `UITableView`.  The only problem is the `UIButton` is catching all the touches even when the touch is on the UITableView.  What am I doing wrong?

Thanks!

Dismiss keyboard by touching background of UITableView

I have a basic spinning animation of the iPhone. Is there any way that I can &quot;pause&quot; the animation so that the position of the view will be maintained? I guess one way of doing this would be to cause the animation to &quot;complete&quot; instead of calling &quot;remove&quot; on it, how would I do that?

    CABasicAnimation* rotationAnimation;
    rotationAnimation = [CABasicAnimation animationWithKeyPath:@&quot;transform.rotation.z&quot;];
    rotationAnimation.toValue = [NSNumber numberWithFloat: M_PI * 2];
    rotationAnimation.duration = 100;
    rotationAnimation.cumulative = YES;
    rotationAnimation.repeatCount = HUGE_VALF;
    rotationAnimation.removedOnCompletion = NO;
    rotationAnimation.fillMode = kCAFillModeForwards;
    [myView.layer addAnimation:rotationAnimation forKey:@&quot;rotationAnimation&quot;];

Is there a way to pause a CABasicAnimation?

I would like to make my app able to do an automatic lightweight migration when I add
 new attributes to my core data model.

In the guide from Apple this is the only info on the subject I could find:

&gt;**Automatic Lightweight Migration**
&gt;
&gt; To request automatic lightweight
&gt; migration, you set appropriate flags
&gt; in the options dictionary you pass in
&gt; addPersistentStoreWithType:configuration:URL:options:error:.
&gt; You need to set values corresponding
&gt; to both the
&gt; NSMigratePersistentStoresAutomaticallyOption
&gt; and the
&gt; NSInferMappingModelAutomaticallyOption
&gt; keys to YES:

    NSError *error;
    NSURL *storeURL = &lt;#The URL of a persistent store#&gt;;
    NSPersistentStoreCoordinator *psc = &lt;#The coordinator#&gt;;
    NSDictionary *options = [NSDictionary dictionaryWithObjectsAndKeys:
        [NSNumber numberWithBool:YES], NSMigratePersistentStoresAutomaticallyOption,
        [NSNumber numberWithBool:YES], NSInferMappingModelAutomaticallyOption, nil];
     
    if (![psc addPersistentStoreWithType:&lt;#Store type#&gt;
        configuration:&lt;#Configuration or nil#&gt; URL:storeURL
        options:options error:&amp;error]) {
        // Handle the error.
    }

My `NSPersistentStoreCoordinator` is initialized in this way:

    - (NSPersistentStoreCoordinator *)persistentStoreCoordinator {
        
        if (persistentStoreCoordinator != nil) {
            return persistentStoreCoordinator;
        }
        
        NSURL *storeUrl = [NSURL fileURLWithPath: [[self applicationDocumentsDirectory] stringByAppendingPathComponent: @&quot;FC.sqlite&quot;]];
        
        NSError *error = nil;
        persistentStoreCoordinator = [[NSPersistentStoreCoordinator alloc] initWithManagedObjectModel:[self managedObjectModel]];
        if (![persistentStoreCoordinator addPersistentStoreWithType:NSSQLiteStoreType configuration:nil URL:storeUrl options:nil error:&amp;error]) {
    
            NSLog(@&quot;Unresolved error %@, %@&quot;, error, [error userInfo]);
            abort();
        }    
        
        return persistentStoreCoordinator;
    }

**I am having trouble seeing where and how I should add the Apple code to get the Automatic Lightweight Migration working?**

Implementation of &quot;Automatic Lightweight Migration&quot; for Core Data (iPhone)

I would like to add a drop shadow to a UIButton. I tried to use self.layer.shadow* properties. Those properties work in UIView, but they behave differently in UIButton. I would really appreciate it if I could get any pointers to draw the drop shadow. Thank you!

    self.layer.cornerRadius = 8.0f;
    self.layer.masksToBounds = YES;
    self.layer.borderWidth = 1.0f;
    	
    self.layer.shadowColor = [UIColor greenColor].CGColor;
    self.layer.shadowOpacity = 0.8;
    self.layer.shadowRadius = 12;
    self.layer.shadowOffset = CGSizeMake(12.0f, 12.0f);

How to add a drop shadow to a UIButton?

I need to add some blank space to the top of my UITableView that does not affect the size of the content area. Shifting the content down or adding a blank cell is NOT what I want to do. Instead I just want an offset.

How?


UITableView + Add content offset at top

How can I get a `UITableViewCell` by `indexPath`? Like this:

I use the `UIActionSheet`, when I click confirm `UIButton` I want to change the cell text.

The nowIndex I define as a property

    - (void)actionSheet:(UIActionSheet *)actionSheet clickedButtonAtIndex:(NSInteger)buttonIndex
    {
        if (buttonIndex == 0)
        {
            NSInteger section =  [nowIndex section];
            NSInteger row = [nowIndex row];
            NSDateFormatter *formatter = [[[NSDateFormatter alloc] init] autorelease];
            formatter.dateFormat = @&quot;yyyy-MM-dd&quot;;
     
            if (section == 0)
            {
                if (row == 0)
                {
        
                }
                else if (row == 1)
                {
                    UILabel *content = (UILabel *)[[(UITableView *)[actionSheet ] cellForRowAtIndexPath:nowIndex] viewWithTag:contentTag];
                    content.text = [formatter stringFromDate:checkInDate.date];
                }
                else if (row == 2)
                {
        
                }
            }
        }
    }

How can I get a uitableViewCell by indexPath?

Does anyone know how to change the background color of a cell using UITableViewCell, for each selected cell? I created this UITableViewCell inside the code for TableView.


Changing background color of selected cell?

I have been working on this for about 2 days, so i thought i share my learnings with you.

The question is: Is it possible to make the width of a cell in a grouped UITableView smaller?

The answer is: No.

But there are two ways you can get around this problem.

**Solution #1: A thinner table**
It is possible to change the frame of the tableView, so that the table will be smaller. This will result in UITableView rendering the cell inside with the reduced width.

A solution for this can look like this:

    -(void)viewWillAppear:(BOOL)animated
    {
        CGFloat tableBorderLeft = 20;
        CGFloat tableBorderRight = 20;
    
        CGRect tableRect = self.view.frame;
        tableRect.origin.x += tableBorderLeft; // make the table begin a few pixels right from its origin
        tableRect.size.width -= tableBorderLeft + tableBorderRight; // reduce the width of the table
        tableView.frame = tableRect;
    }

**Solution #2: Having cells rendered by images**

This solution is described here: http://cocoawithlove.com/2009/04/easy-custom-uitableview-drawing.html

I hope this information is helpful to you. It took me about 2 days to try a lot of possibilities. This is what was left.

How to set the width of a cell in a UITableView in grouped style

In **SQL Server**, it is possible to insert rows into a table with an `INSERT.. SELECT` statement:

    INSERT INTO Table (col1, col2, col3)
    SELECT col1, col2, col3 
    FROM other_table 
    WHERE sql = &#39;cool&#39;

Is it also possible to _update_ a table with `SELECT`? I have a temporary table containing the values and would like to update another table using those values. Perhaps something like this:

    UPDATE Table SET col1, col2
    SELECT col1, col2 
    FROM other_table 
    WHERE sql = &#39;cool&#39;
    WHERE Table.id = other_table.id


How do I UPDATE from a SELECT in SQL Server?

I&#39;m in the process of creating a table and it made me wonder.

If I store, say cars that has a make (fx BMW, Audi ect.), will it make any difference on the query speed if I store the make as an int or varchar.

So is

    SELECT * FROM table WHERE make = 5 AND ...;

Faster/slower than

    SELECT * FROM table WHERE make = &#39;audi&#39; AND ...;

or will the speed be more or less the same?

SQL SELECT speed int vs varchar

For the following datatable column, what is the fastest way to get the min and max values?

    AccountLevel  
    0  
    1  
    2  
    3 


 


How to select min and max values of a column in a datatable?

I&#39;m trying to execute a SELECT statement that includes a column of a static string value.  I&#39;ve done this in Access, but never with raw SQL.  Is this possible?

Example:

     Name  | Status
     ------+--------
     John  | Unpaid
     Terry | Unpaid
     Joe   | Unpaid

In the above example, the &quot;Status&quot; column doesn&#39;t exist in the database.
     

Include in SELECT a column that isn&#39;t actually in the database

In our production database, we ran the following pseudo-code SQL batch query running every hour:

    INSERT INTO TemporaryTable
        (SELECT FROM HighlyContentiousTableInInnoDb
         WHERE allKindsOfComplexConditions are true)

Now this query itself does not need to be fast, but I noticed it was locking up `HighlyContentiousTableInInnoDb`, even though it was just reading from it. Which was making some other very simple queries take ~25 seconds (that&#39;s how long that other query takes).

Then I discovered that InnoDB tables in such a case are actually locked by a SELECT! https://www.percona.com/blog/2006/07/12/insert-into-select-performance-with-innodb-tables/

But I don&#39;t really like the solution in the article of selecting into an OUTFILE, it seems like a hack (temporary files on filesystem seem sucky). Any other ideas? Is there a way to make a full copy of an InnoDB table without locking it in this way during the copy. Then I could just copy the `HighlyContentiousTable` to another table and do the query there.

How to improve INSERT INTO ... SELECT locking behavior

I&#39;ve got a very large MySQL table with about 150,000 rows of data. Currently, when I try and run

    SELECT * FROM table WHERE id = &#39;1&#39;;

the code runs fine as the ID field is the primary index.
However, for a recent development in the project, I have to search the database by another field. For example:

    SELECT * FROM table WHERE product_id = &#39;1&#39;;

This field was not previously indexed; however, I&#39;ve added one, so mysql now indexes the field, but when I try to run the above query, it runs very slowly. An EXPLAIN query reveals that there is no index for the product_id field when I&#39;ve already added one, and as a result the query takes any where from 20 minutes to 30 minutes to return a single row.

My full EXPLAIN results are:

    | id | select_type | table | type | possible_keys| key  | key_len | ref  | rows  | Extra       |
    +----+-------------+-------+------+--------------+------+---------+------+-------+------------------+
    |  1 | SIMPLE      | table | ALL  | NULL         | NULL | NULL    | NULL |157211 | Using where |
    +----+-------------+-------+------+--------------+------+---------+------+-------+------------------+

It might be helpful to note that I&#39;ve just taken a look, and ID field is stored as INT whereas the PRODUCT_ID field is stored as VARCHAR. Could this be the source of the problem?

How do I add indexes to MySQL tables?

    &lt;html&gt;
        &lt;head&gt;
            &lt;title&gt;Table Row Padding Issue&lt;/title&gt;
            &lt;style type=&quot;text/css&quot;&gt;
                tr {
                    padding: 20px;
                }
            &lt;/style&gt;
        &lt;/head&gt;
        &lt;body&gt;
            &lt;table&gt;
                &lt;tbody&gt;
                    &lt;tr&gt;
                        &lt;td&gt;
                            &lt;h2&gt;Lorem Ipsum&lt;/h2&gt;
                            &lt;p&gt;Fusce sodales lorem nec magna iaculis a fermentum lacus facilisis. Curabitur sodales risus sit amet
                            neque fringilla feugiat. Ut tellus nulla, bibendum at faucibus ut, convallis eget neque. In hac habitasse 
                            platea dictumst. Nullam elit enim, gravida eu blandit ut, pellentesque nec turpis. Proin faucibus, sem sed 
                            tempor auctor, ipsum velit pellentesque lorem, ut semper lorem eros ac eros. Vivamus mi urna, tempus vitae 
                            mattis eget, pretium sit amet sapien. Curabitur viverra lacus non tortor luctus vitae euismod purus 
                            hendrerit. Praesent ut venenatis eros. Nulla a ligula erat. Mauris lobortis tempus nulla non 
                            scelerisque.&lt;/p&gt;
                        &lt;/td&gt;
                    &lt;/tr&gt;
                &lt;/tbody&gt;
            &lt;/table&gt;
        &lt;/body&gt;
    &lt;/html&gt;

Here&#39;s what the padding looks like. See how the td inside isn&#39;t affected. What&#39;s the solution?
![Table Row Padding Issue][1]


  [1]: http://i.stack.imgur.com/RRMec.png

Padding a table row

    insert into table select * from table where primarykey=1

I just want to copy one row to insert into the same table (i.e., I want to duplicate an existing row in the table) but I want to do this without having to list all the columns after the &quot;select&quot;, because this table has too many columns.

But when I do this, I get the error:
 &gt; Duplicate entry &#39;xxx&#39; for key 1

I can handle this by creating another table with the same columns as a temporary container for the record I want to copy:

    create table oldtable_temp like oldtable;
    insert into oldtable_temp select * from oldtable where key=1;
    update oldtable_tem set key=2;
    insert into oldtable select * from oldtable where key=2;

Is there a simpler way to solve this?

In MySQL, can I copy one row to insert into the same table?

Why when i use SimpleCursorAdapter for ListView i have items height in ListView like this - ![listview image][1]

(My code based on [this][2])

**But when using arrays Listview items have big height**  

![listview big][3]

(I learn listview based on [this][4])

Row layout for item listview is

    &lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;
    &lt;TextView android:id=&quot;@+id/text1&quot;
    xmlns:android=&quot;http://schemas.android.com/apk/res/android&quot;
    android:layout_width=&quot;wrap_content&quot;
    android:layout_height=&quot;wrap_content&quot;/&gt;

**So My question is why there is a difference in row heights when using ArrayAdapter and SimpleCursorAdapter?**


  [1]: http://i.stack.imgur.com/tS8xS.jpg
  [2]: https://stackoverflow.com/questions/2982948/sqlite-and-populating-list-view-android
  [3]: http://i.stack.imgur.com/tSrYu.png
  [4]: http://androidpeople.com/android-listview-example/

android listview item height

After some research, I couldn&#39;t find an answer to this question. There was [this][1] but it didn&#39;t really answer my question. I would like to &quot;strikethrough&quot; a complete HTML table row in CSS, not just the text in it. Is it at all possible? From the example that I linked, it seems tr styling doesn&#39;t even work in Firefox. (And anyway, text-decoration only applies on text afaik)




  [1]: https://stackoverflow.com/questions/1758584/css-line-through-not-being-removed

Content Type	Original Author	Original Content on Stackoverflow
Question	skylerl	View Question on Stackoverflow
Solution 1 - Ios	gerry3	View Answer on Stackoverflow
Solution 2 - Ios	ayalcin	View Answer on Stackoverflow

Selecting row while UITableView is in editing mode

Ios Problem Overview

Ios Solutions

Solution 1 - Ios

Solution 2 - Ios

Oracle: '= ANY()' vs. 'IN ()'

Debugging python programs in emacs

Attributions