- (ASIFormDataRequest *)generateASIHTTPRequestFromSQLId:(NSUInteger)sqlid
{
 NSString *query = [NSString stringWithFormat:@"SELECT actual_dep, actual_arr, location_dep, location_arr, tops_1, tops_2, tops_3, tops_4, distance, headcode, route, notes, metro, hidden FROM journeys WHERE id = %d", sqlid];
 sqlite3_stmt *statement;
 NSError *error = nil;

 if(sqlite3_prepare_v2(database, [query UTF8String], -1, &statement, nil) == SQLITE_OK)
 {
  ASIFormDataRequest *returnVal = [ASIFormDataRequest requestWithURL:[NSURL URLWithString:[NSString stringWithFormat:@"%@jkh", [[NSUserDefaults standardUserDefaults] objectForKey:@"apiloc"]]]];
  [returnVal setPostValue:@"3" forKey:@"kh"];

  [returnVal setUseKeychainPersistence:NO];
  [returnVal setUsername:[[UIDevice currentDevice] uniqueIdentifier]];
  [returnVal setPassword:[KeychainUtils getPasswordForUsername:@"loginhash" andServiceName:@"RM" error:&error]];
  [returnVal setDelegate:self];
  [returnVal setTimeOutSeconds:30];

  while (sqlite3_step(statement) == SQLITE_ROW) {
   int actualDep = (int)sqlite3_column_int(statement, 0);
   int actualArr = (int)sqlite3_column_int(statement, 1);

   [returnVal setPostValue:[NSString stringWithFormat:@"%d", actualDep] forKey:@"actualDep"];
   [returnVal setPostValue:[NSString stringWithFormat:@"%d", actualArr] forKey:@"actualArr"];

   char *depLoc = (char *)sqlite3_column_text(statement, 2);
   char *arrLoc = (char *)sqlite3_column_text(statement, 3);

   [returnVal setPostValue:[NSString stringWithUTF8String:depLoc] forKey:@"locationDep"];
   [returnVal setPostValue:[NSString stringWithUTF8String:arrLoc] forKey:@"locationArr"];

   char *tops1 = (char *)sqlite3_column_text(statement, 4);
   char *tops2 = (char *)sqlite3_column_text(statement, 5);
   char *tops3 = (char *)sqlite3_column_text(statement, 6);
   char *tops4 = (char *)sqlite3_column_text(statement, 7);

   [returnVal setPostValue:[NSString stringWithUTF8String:tops1] forKey:@"tops1"];
   [returnVal setPostValue:[NSString stringWithUTF8String:tops2] forKey:@"tops2"];
   [returnVal setPostValue:[NSString stringWithUTF8String:tops3] forKey:@"tops3"];
   [returnVal setPostValue:[NSString stringWithUTF8String:tops4] forKey:@"tops4"];

   double distance = (double)sqlite3_column_double(statement, 8);
   char *headcode = (char *)sqlite3_column_text(statement, 9);
   char *routeText = (char *)sqlite3_column_text(statement, 10);
   char *notesText = (char *)sqlite3_column_text(statement, 11);

   [returnVal setPostValue:[NSNumber numberWithDouble:distance] forKey:@"distance"];
   [returnVal setPostValue:[NSString stringWithUTF8String:headcode] forKey:@"headcode"];
   [returnVal setPostValue:[NSString stringWithUTF8String:routeText] forKey:@"route"];
   [returnVal setPostValue:[NSString stringWithUTF8String:notesText] forKey:@"notes"];

   int metroVal = (int)sqlite3_column_int(statement, 12);
   int hiddenVal = (int)sqlite3_column_int(statement, 13);

   [returnVal setPostValue:[NSString stringWithFormat:@"%d", metroVal] forKey:@"metro"];
   [returnVal setPostValue:[NSString stringWithFormat:@"%d", hiddenVal] forKey:@"hidden"];
  }
  sqlite3_finalize(statement);

  return returnVal;
 }
 else {
  return nil;
 }
}