$objRow = GetRowForTableColumnRow($strTableName, $strPkColumnName, $objRow); ParentPagerProgram::CreateOrUpdateForMsSqlRow($objRow); } //////////////////////////// // ParentPager Household //////////////////////////// $strTableName = 'tblHousehold'; $strPkColumnName = 'lngHouseHoldID'; $intRowCount = GetRowCount($strTableName); $intCurrentRow = 0; $objResult = GetPkResultForTableColumn($strTableName, $strPkColumnName); while ($objRow = mssql_fetch_assoc($objResult)) { printf('[%5s/%5s]', $intCurrentRow++, $intRowCount); $objRow = GetRowForTableColumnRow($strTableName, $strPkColumnName, $objRow); print ' - ID #' . $objRow[$strPkColumnName] . ' - ' . $objRow['strHouseHold'] . "\r\n"; ParentPagerHousehold::CreateOrUpdateForMsSqlRow($objRow); } /////////////////////////// // ParentPager Individual //////////////////////////// $strTableName = 'tblIndividual'; $strPkColumnName = 'lngIndividualID'; $intRowCount = GetRowCount($strTableName); $intCurrentRow = 0; $objResult = GetPkResultForTableColumn($strTableName, $strPkColumnName); while ($objRow = mssql_fetch_assoc($objResult)) { printf('[%5s/%5s]', $intCurrentRow++, $intRowCount); $objRow = GetRowForTableColumnRow($strTableName, $strPkColumnName, $objRow); print ' - ID #' . $objRow[$strPkColumnName] . ' - ' . $objRow['strFirstName'] . ' ' . $objRow['strLastName'] . "\r\n"; ParentPagerIndividual::CreateOrUpdateForMsSqlRow($objRow); }