PPRuNe Forums - View Single Post - PPRuNe Career Development
View Single Post
Old 28th January 2002 | 02:47
  #10 (permalink)  
CrashDive
Moderator
25 Anniversary
 
Joined: May 1998
Posts: 253
Likes: 0
From: .
Smile

Captain Wannabe - thus far yours is the 2nd mention of a problem with that error, which has seemingly only affected those applying for the PPRuNe Cadet Scheme.

Accordingly I've had a look at the database design and I think I've found what may have caused it to throw a wobbler.

When initially designed, the database columns that hold stuff like 'TotalTime' were declared as integers (i.e. only designed to hold numbers - because most airline pilots when asked "How many hours ?" say something like "roughly 8,400" and might submit '8,430' - and the database would happily accept that as being a number).

However what the database would not like in an integer column is stuff such as, "123 hours" ( or worse still, "123:10 and I'm going up in my clubs C152 next week so I'll get a few more soon too !" ).. .In that instance, with an Integer column constraint, the database engine then says to itself "Nah, that's not a proper number, so I'd better throw the whole thing out".. .It then reports a very 'woolly' error to me, which then have to try and interpret as what the likely real problem is - and then pass on to you (and characters in integer fields was not one I was expecting, obviously).

So to (hopefully) fix that problem, I've now converted ALL the database columns that hold numbers into ones that instead hold characters (albeit that it upsets my purist streak to do it, but 'needs must' and all that).. .That said, when it comes to anything to do with total time / flying hours, etc, those fields are now at most only a whole eight characters wide inside the database - so everybody please don’t embellish your hours with extra info - I've also just asked Danny to change the application web page to give you a clue as to the format we'd like you to express your hours in, i.e. a nice simple number.

Ultimately CaptW, I'm not saying that that's what happened in your case, but please do give it another try, and report back……. and if you do get a "white screen of death" - read what it says, then press your browsers BACK button and all the stuff you entered should still be there such that you can fix any problem and press 'Apply' again - which you know anyway.

Ps. To be fair, the on-line recruitment went live this morning at 1am. I went to bed at 2am, and was up and at it again at 6am - check the time now - and I need to be out the door at 6am, but rest assured we're all striving to make this as painless experience as we can (both you and us) - but the occasional glitch might occur....... now did I hear somebody say "Swanwick ?!"

[ 27 January 2002: Message edited by: CrashDive ]</p>
CrashDive is offline