PriceList[0] is a float. PriceList[0][1] is trying to access the first element of a float. Instead, do PriceList[0] = PriceList[1] = …code omitted… = PriceList[6] = PizzaChange or PriceList[0:7] = [PizzaChange]*7
As pointed out by Jeffrey, you are using accessOrder. When you created the LinkedHashMap, the third parameter specify how the order is changed. “true for access-order, false for insertion-order” For more detailed implementation of LRU, you can look at this http://www.programcreek.com/2013/03/leetcode-lru-cache-java/
The ObservableCollection exposes an protected Items property which is the underlying collection without the notification semantics. This means you can build a collection that does what you want by inheriting ObservableCollection: class RangeEnabledObservableCollection<T> : ObservableCollection<T> { public void InsertRange(IEnumerable<T> items) { this.CheckReentrancy(); foreach(var item in items) this.Items.Add(item); this.OnCollectionChanged(new NotifyCollectionChangedEventArgs(NotifyCollectionChangedAction.Reset)); } } Usage: void Main() { … Read more
Excerpt from the relevant page in the manual: Outputs On successful completion, an INSERT command returns a command tag of the form INSERT oid count The count is the number of rows inserted. If count is exactly one, and the target table has OIDs, then oid is the OID assigned to the inserted row. Otherwise … Read more
update As BrianCampbell points out here, SQLite 3.7.11 and above now supports the simpler syntax of the original post. However, the approach shown is still appropriate if you want maximum compatibility across legacy databases. original answer If I had privileges, I would bump river’s reply: You can insert multiple rows in SQLite, you just need … Read more
The best way to make “pseudo-inplace” changes to a file in Python is with the fileinput module from the standard library: import fileinput processing_foo1s = False for line in fileinput.input(‘1.txt’, inplace=1): if line.startswith(‘foo1’): processing_foo1s = True else: if processing_foo1s: print ‘foo bar’ processing_foo1s = False print line, You can also specify a backup extension if … Read more
You don’t use the VALUES keyword when inserting from a SELECT statement. INSERT INTO t2 (a, b) SELECT a, b FROM `t1` AS o WHERE o.id NOT IN ( SELECT a FROM t2 )
MySQL supports the insert-on-duplicate syntax, f.e.: INSERT INTO table (key,col1) VALUES (1,2) ON DUPLICATE KEY UPDATE col1 = 2;
You just need to add @ID to the params collection and then retrieve it like this, cmd.Parameters.Add(“@ID”, SqlDbType.Int, 4).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); //Now just read the value of: cmd.Parameters[“@ID”].value Or, if you prefer this syntax: SqlParameter param = new SqlParameter(“@ID”, SqlDbType.Int, 4); param.Direction = ParameterDirection.Output; cmd.Parameters.Add(param);