Recent content by scorpio66

Use an intermediate step. stringvar.replace(/££/g,'_').replace(/£/g, '€').replace(/_/g, '£');

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

Sorry, cut and paste error. Line in loadImg should read: document.getElementById('caption').innerText = arImgData[idx][1];

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...

One that I use and like is FCKEditor. http://www.fckeditor.com

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...

Address TEXT ;-)

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...