Table View: viewName= Default Order by: `fidId` Sort Order: fidCurDate Limit Records to: 10
Id
Total
Individual
Personal
Managed
SEP
Date
Comments
at420
ai163
ar091
as551
mi866
mi543
mt592
TotManaged
TotNonManaged
Action
Action
We are in final else Junk666 PASSed orderByFld= `fidId` so= DeSc sp= and sv=sv1 l= newSqlCmd=SeLeCT (`mi866`+`mi543` +`mt592` + 'as551') as `totManaged`, (`at420` + `ai163` +`ar091` ) as `totNonManaged`, 'rick',`fidId`,`fidTot`,`fidIndiv`,`fidPer`, `fidProMan`, `fidSep`,date_format(`fidCurDate`,'%m/%d/%Y %W') as fidCurDate,`fidComment`, `at420`,`ai163`,`ar091`,`as551`,`mi866`,`mi543`,`mt592` FROM `fidelity` ORDER BY `fidId` fidCurDate LIMIT 10; sqlCmd=SeLeCT (`mi866`+`mi543` +`mt592` + 'as551') as `totManaged`, (`at420` + `ai163` +`ar091` ) as `totNonManaged`, 'rick',`fidId`,`fidTot`,`fidIndiv`,`fidPer`, `fidProMan`, `fidSep`,date_format(`fidCurDate`,'%m/%d/%Y %W') as fidCurDate,`fidComment`, `at420`,`ai163`,`ar091`,`as551`,`mi866`,`mi543`,`mt592` FROM `fidelity` ORDER BY `fidId` fidCurDate LIMIT :limitRows; Table headings complete