print ' - ID #' . $objRow[$strPkColumnName] . ' - ' . $objRow['strAddress1'] . ' ' . $objRow['strCity'] . "\r\n"; ParentPagerAddress::CreateOrUpdateForMsSqlRow($objRow); } /////////////////////////// // ParentPager Child Records //////////////////////////// $strTableName = 'tblChildInStationHistory'; $strPkColumnName = 'lngChildHistoryID'; $intRowCount = GetRowCount($strTableName); $intCurrentRow = 0; $objResult = GetPkResultForTableColumn($strTableName, $strPkColumnName); while ($objRow = mssql_fetch_assoc($objResult)) { printf('[%6s/%6s]', $intCurrentRow++, $intRowCount); $objRow = GetRowForTableColumnRow($strTableName, $strPkColumnName, $objRow); print ' - ID #' . $objRow[$strPkColumnName] . "\r\n"; ParentPagerChildHistory::CreateOrUpdateForMsSqlRow($objRow); } /////////////////////////// // ParentPager Volunteer Records //////////////////////////// $strTableName = 'tblAttendantInStationHistory'; $strPkColumnName = 'lngAttendantHistoryID'; $intRowCount = GetRowCount($strTableName); $intCurrentRow = 0; $objResult = GetPkResultForTableColumn($strTableName, $strPkColumnName); while ($objRow = mssql_fetch_assoc($objResult)) { printf('[%6s/%6s]', $intCurrentRow++, $intRowCount); $objRow = GetRowForTableColumnRow($strTableName, $strPkColumnName, $objRow); print ' - ID #' . $objRow[$strPkColumnName] . "\r\n"; ParentPagerAttendantHistory::CreateOrUpdateForMsSqlRow($objRow); }