plummeteer 0 #1 May 17, 2004 I'm looking for some help in Jump Track 2.0. I've got jump numbers/info. matched up wrong due to some h&p's made following my static liners out, I wear a different helmet w/o the Pro Track so I always have this problem. I'd like to find out how to straighten out what I have, for now and future. I guess the simplest way for future would be to set up my ProTec for it and move it when needed. I don't know SQL, have tried one of the pre-written ones but it just made it worse because I don't really understand what it's going to do. I have it backed up, so I can just restore and start fresh (have twice now). Help would be greatly appreciated. Edo Concumbui Aethrae Cernuare Quote Share this post Link to post Share on other sites
AndyMan 7 #2 May 17, 2004 I do know SQL... and all my attempts to tweak the jump-track data led me to quite a few hours of frustration trying to "fix" it afterwards. My recomendations are to not try, unless you really know what you're doing. _Am__ You put the fun in "funnel" - craichead. Quote Share this post Link to post Share on other sites
FrogNog 1 #3 May 17, 2004 I'm sure I could figure out and fix your problem for $50 / hour. But if it's not worth a lot of money to you, I think you will have to just make it look good enough on some sort of paper map between real jumps and database jumps. -=-=-=-=- Pull. Quote Share this post Link to post Share on other sites
ChrisL 2 #4 May 17, 2004 DBA consulting services for $50.00 an hour???? Why dont you just give it away? __ My mighty steed Quote Share this post Link to post Share on other sites
ianmdrennan 2 #5 May 17, 2004 Mr Admin, your skydive link is broken on your homepage Blue ones, IanPerformance Designs Factory Team Quote Share this post Link to post Share on other sites
ChrisL 2 #6 May 17, 2004 No, just not linked to any content yet. I only added the button yesterday __ My mighty steed Quote Share this post Link to post Share on other sites
ChrisL 2 #7 May 17, 2004 Try it now __ My mighty steed Quote Share this post Link to post Share on other sites
ianmdrennan 2 #8 May 17, 2004 LOL - It appears to be working now. I think your Apache server is rendering the markup incorrectly though as it seems to contain a personalized message for me , must be because I'm using IE Blue ones, IanPerformance Designs Factory Team Quote Share this post Link to post Share on other sites
ChrisL 2 #9 May 17, 2004 If you use IE you are supposed to go away!__ My mighty steed Quote Share this post Link to post Share on other sites
ianmdrennan 2 #10 May 17, 2004 I'm using windows xp too Performance Designs Factory Team Quote Share this post Link to post Share on other sites
ChrisL 2 #11 May 17, 2004 I use it occasionall too. But I STOLE IT!!!!__ My mighty steed Quote Share this post Link to post Share on other sites
ianmdrennan 2 #12 May 17, 2004 I tried to steal Redhat, but it was so crappy they were just giving it away!! Blue ones, IanPerformance Designs Factory Team Quote Share this post Link to post Share on other sites
ChrisL 2 #13 May 17, 2004 I cant be baited quite that easily. To do that you would have to pull out the real nukes like jokes about my mom and such __ My mighty steed Quote Share this post Link to post Share on other sites
ianmdrennan 2 #14 May 17, 2004 heh was worth a shot. I suppose I should stop posting meaningless posts in this thread anyway. Sorry for the hijack Performance Designs Factory Team Quote Share this post Link to post Share on other sites
FrogNog 1 #15 May 17, 2004 QuoteDBA consulting services for $50.00 an hour???? Why dont you just give it away? I figure a fellow skydiving brother should get a price break. -=-=-=-=- Pull. Quote Share this post Link to post Share on other sites
plummeteer 0 #16 May 17, 2004 Seems like L&B could make it easier to fix ones f**k ups . I e-mailed them to see what they suggest, so I'll wait a while to see what they say. I can always start over entering them manually, it's only 63 jumps or so, much better than the 405 I lost in it last year due to poor back-up . Edo Concumbui Aethrae Cernuare Quote Share this post Link to post Share on other sites
cpoxon 0 #17 May 17, 2004 What exactly is it you want to do? Shift some of the jump numbers up to increment for the hop and pops? The UPDATE MOVE JUMPNUMBERS statement that comes with JumpTrack is UPDATE LOGBOOK SET Jumpnumber = Jumpnumber + 1 WHERE Jumpnumber >= 100 This adds 1 to all jumps greater than or equal to 100. If you only wanted to increment that and the next jump it would be UPDATE LOGBOOK SET Jumpnumber = Jumpnumber + 1 WHERE Jumpnumber >= 100 AND Jumpnumber <= 101 I suggest that if you have several blocks of hop and pops, that you increment them a block at a time and look to see the new jumpnumbers for the next block that needs to be incremented.Skydiving Fatalities - Cease not to learn 'til thou cease to live Quote Share this post Link to post Share on other sites
mjosparky 3 #18 May 18, 2004 Go to "add a jump" and add what you want. SparkyMy idea of a fair fight is clubbing baby seals Quote Share this post Link to post Share on other sites
jas8472 0 #19 May 18, 2004 Stupid question, but why not just take the protrack on the hop & pop's. Quote Share this post Link to post Share on other sites
rainman 0 #20 May 18, 2004 When I either forget my Protrack or when it doesn't log a jump due to too little freefall time, I just update the total number of jumps and/or freefall time in the menu. I don't have my Protrack or the manual here, so I can't tell you exactly how it's done, but it can be done on the Protrack itself. Edited to add: You would want to do the above before the next jump... HTH, Ramon Quote Share this post Link to post Share on other sites plummeteer 0 #21 May 20, 2004 UPDATE LOGBOOK SET Jumpnumber = Jumpnumber + 1 WHERE Jumpnumber >= 100 AND Jumpnumber <= 101 -------------------------------------------------------------------------------- I suggest that if you have several blocks of hop and pops, that you increment them a block at a time and look to see the new jumpnumbers for the next block that needs to be incremented. Thanks, I think is what I wasn't catching onto. I'm going to give a try. Edo Concumbui Aethrae Cernuare Quote Share this post Link to post Share on other sites EAerodyne 0 #22 May 20, 2004 Seeing there seem to be so many SQL boff's on this thread, any of you looking for a job as a SQL programmer and test jumper? Got tons of SQL work over here, and am currently evaluating whether or not to farm it out, or get a multi talented individual, SQL/IT/Test Jumper type person, to fill a more permanent role. Any interested individuals, please email me personally at [email protected] blue ones Bushman Quote Share this post Link to post Share on other sites Join the conversation You can post now and register later. If you have an account, sign in now to post with your account. Note: Your post will require moderator approval before it will be visible. Reply to this topic... × Pasted as rich text. Paste as plain text instead Only 75 emoji are allowed. × Your link has been automatically embedded. Display as a link instead × Your previous content has been restored. Clear editor × You cannot paste images directly. Upload or insert images from URL. Insert image from URL × Desktop Tablet Phone Submit Reply 0
plummeteer 0 #21 May 20, 2004 UPDATE LOGBOOK SET Jumpnumber = Jumpnumber + 1 WHERE Jumpnumber >= 100 AND Jumpnumber <= 101 -------------------------------------------------------------------------------- I suggest that if you have several blocks of hop and pops, that you increment them a block at a time and look to see the new jumpnumbers for the next block that needs to be incremented. Thanks, I think is what I wasn't catching onto. I'm going to give a try. Edo Concumbui Aethrae Cernuare Quote Share this post Link to post Share on other sites
EAerodyne 0 #22 May 20, 2004 Seeing there seem to be so many SQL boff's on this thread, any of you looking for a job as a SQL programmer and test jumper? Got tons of SQL work over here, and am currently evaluating whether or not to farm it out, or get a multi talented individual, SQL/IT/Test Jumper type person, to fill a more permanent role. Any interested individuals, please email me personally at [email protected] blue ones Bushman Quote Share this post Link to post Share on other sites
