Some notes on software development... RSS 2.0
# Wednesday, 30 April 2008

Below are the parameter details for the (popup) JavaScript function:


The list details are taken from the Blazonry website.

Wednesday, 30 April 2008 10:10:32 (GMT Standard Time, UTC+00:00)  #    -
Web Dev
# Tuesday, 29 April 2008
Tuesday, 29 April 2008 07:52:49 (GMT Standard Time, UTC+00:00)  #    -
SQL Server
# Monday, 28 April 2008

Scott Gu has a nice article describing the null coalescing operator when used with LINQ queries.

A quick example:

The Qty & Size properties for the anonymous type will be defined as integer types NOT nullable integers. If any of the spec.Attribute("x") values are null or don't exist for any reason, the value returned will be a simple integer zero.
This is because using the null coalescing operator (??) is enforcing that null can never ever happen.

Scott Gu blog article

Monday, 28 April 2008 17:01:12 (GMT Standard Time, UTC+00:00)  #    -
# Tuesday, 15 April 2008

To get the rightmost value in a range you can use the Lookup function:


The 1st parameter is the value to lookup in the range. However if the value cannot be found the lookup function will return the highest value in the range by default.
So setting the 1st parameter to 1E+100 basically sets the lookup value to be a huge numeric value, 1 + 100 zeros. If you know what your max value will be you can change this to be max value + 1.

Microsoft Discussion Groups - Microsoft.Public.Excel.Misc

Tuesday, 15 April 2008 08:07:19 (GMT Standard Time, UTC+00:00)  #    -

Sign In
Total Posts: 116
This Year: 0
This Month: 0
This Week: 0
Comments: 36
About the author/Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2019
Hadrian Phillips

All Content © 2019, Hadrian Phillips
DasBlog theme 'Business' created by Christoph De Baene (delarou)