#186545 by HighFlyer
11 Oct 2007, 20:18
You mean you have not memorised them all yet? :)

Thanks,
Sarah
#186546 by Neil
11 Oct 2007, 20:20
Phew - thought I was the only one who knew the flight times off the top of my head[:I]
#186549 by NS
11 Oct 2007, 20:39
Yeh, of course if have - it's for the benefit of those who haven't yet :D:D:D
#186589 by Pete
12 Oct 2007, 03:56
I can probably extract the flight times from the flight number (for Virgin flights). Leave that one with me....
#186618 by Pete
12 Oct 2007, 13:59
Ok, added the scheduled flight time (for VS flights) - I should add the disclaimer that Virgin have a habit of tweaking flight times quite a lot, so the one displayed is the usual published scheduled time, and may be subject to seasonal changes or specific flight alterations that I don't have data for. If, however, it's just to work out roughly when someone will be in the Clubhouse, then it should be ok for that purpose.

Pete
#186622 by woggledog
12 Oct 2007, 14:27
Fantastic!

Now that we have that could we tie it into a calender that shows when users may be in the CH? I suppose the sql query may have several joins with Gold / UC / Flight times, but it's nothing too difficult!
#186624 by NS
12 Oct 2007, 14:37
Thanks Pete! A great help!
Virgin Atlantic

Who is online

Users browsing this forum: No registered users and 4 guests

Itinerary Calendar