Actually, the extra bank holiday was in 2002 for the Queens Golden Jubilee.
They added an extra day (June 3rd) and moved the end of May holiday to June 4th for a 4 day weekend.
See what I mean.
Chaz
It's really difficult to get Easter calculations right - there is a whole page of information about calculating Easter here:
http://www.cs.rutgers.edu/pub/soc.religion.christian/faq/easter-date
and more here:
http://www.bbc.co.uk/dna/h2g2/A653267
Actually, public holidays are a pain in...
And what you really want is the value of the selected index.
function fn(ele) {
var selected = ele.options[ele.selectedIndex].value;
alert(selected)
}
</script>
<select id='dropdiv' onchange="fn(this)">
<option value=1>1</option>
<option value=2>2</option>
</select>
Chaz
Out of interest, why not keep your image data and caption together in a single array?
var arImgData = [
['pix01', 'comment01']
, ['pix02', 'comment02']
, ['pix03', 'comment03']
...
]
// Tell browser where to find the image
var myImgSrc = "/dogdaysinla/";
// Tell browser the type of...
All excellent points Denny. I've never considered the possibility that MS would change the hashing algorithm so that definitely deserves a star.
Kate, if you do decide to use pwdencrypt (and seriously consider Denny's concerns) then you do the authentication on the server. For example...
All excellent points Denny. I've never considered the possibility that MS would change the hashing algorithm so that definitely deserves a star.
Kate, if you do decide to use pwdencrypt (and seriously consider Denny's concerns) then you do the authentication on the server. For example...
Kate,
There is one more thing - SQL2K supports some undocumented encryption functions which can be used to obscure the password.
As stated, these are undocumented - I don't know if they're in SQL2K5.
select pwdencrypt('HELLO WORLD')
select pwdcompare('HELLO WORLD', encrypted_value)
You'd...
Could you not create a view containing all of the columns except your password col and lock down the original table so that no-one could select from it?
That would stop someone casually looking through the passwords (except a DBA, of course)
Chaz
I have another, slightly smaller and possibly quicker function for this:
CREATE FUNCTION dbo.FN_PROPER(@STR_IN NVARCHAR(4000))
RETURNS NVARCHAR(4000)
AS
BEGIN
DECLARE @POS INT
, @RETVAL NVARCHAR(4000)
, @LEN INT
SELECT @POS = CHARINDEX(' ', @STR_IN, 0), @RETVAL = UPPER(LEFT(@STR_IN...
Oh, one more thing.
If the definition of TBL is
TBL_ID int identity,
field1 datatype,
field2 datatype,
field3 datatype,
...
status char(1)
the definition of TBL_HIST we use is
TBL_HIST_ID int identity,
TBL_ID int,
field1 datatype,
field2 datatype,
field3 datatype,
...
status char(1)
You...
bessebo, follow ptheriaults advice - honestly, it's the best way of auditing.
Where I'm working we have TBL_RAW, TBL_HIST and a view TBL.
TBL_RAW contains the base data, TBL_HIST the historic data. However, for this audit to work correctly you must never physically delete data. Therefore, in...
I don't know if this is relevant but we've had lots of problems getting drag and drop working in XP here.
Nothing wrong with the code - it worked fine in W2K (slightly earlier version of IE - that might make a difference) but when we migrated to XP it all just stopped working.
We ended up...
tsujis answer is a regular expression that represents what you want, but if you want to have those numbers in a structure that allows you to loop through then then put them in an array.
var arItems = [1, 2, 3, 4, 5];
or alternatively
var arItems = [];
for (var i=startVal; i<endVal; i++)...
Sorry about the delay - weekend and whatever!
There are several things you could do to get around this: you could have an array of valid select boxes and only use the ones that are in the array, or alternatively you could set a property in the select tag itself and check that.
for example...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.