Google caritech

Posted Sat, 06/13/2009 - 18:45 by walin

When I googled caritech, this was what I got...

It's glad and excited to announce that caritech is activated! Who we are? Caritech is a subsidiary of Allstaff, which is a first choice manpower outsourcing ...

Sounds a bit strange to describe a company...

And also, to send you a general feedback, should it be under forum? I thought it's usually in guest book ??

On a positive note, I like the interface and design of Caritech: CLEAN and SIMPLE !! And it will load faster if there are less images, unlike FunNstuff where there are too many pictures on the first page...

how to unzip a rar file ›

To update a column of a table

by alexdenipaul - 01/21/2010 - 13:14

To update a column of a table with a rank based on subsets of data, the IF() function does a wonderful job website design.

A summary table (in this case created to hold summary counts of other genealogy data, based on the two fields that make up the PRIMARY key) often contains unique key fields and one or more summary totals (Cnt in this case). Additional ranking fields in the summary table can be easily updated to contain rankings of the Cnt field using the IF function and wireless internet service
local variables.

Table DDL:

CREATE TABLE `countsbyboth` (
`SurnameID` int(11) unsigned NOT NULL default '0',
`GedID` int(11) unsigned NOT NULL default '0',
`Cnt` int(11) unsigned NOT NULL default '0',
`sRank` int(11) unsigned NOT NULL default '0',
`nRank` int(11) unsigned NOT NULL default '0' internet phone service,
PRIMARY KEY (`SurnameID`,`GedID`),
KEY `SurnameID` (`SurnameID`,`Cnt`),
KEY `GedID` (`GedID`,`Cnt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

After populating the table with rows containing key and summary data (and leaving the rank field(s) to be updated in
a subsequent step), the rank fields can be updated using syntax similar to the following internet access:

Thanks!

by kailoon - 06/13/2009 - 22:21

Hi Daniel,

Thanks, your feedback counts. First of all, thanks for the positive feedback, we appreciate it. Caritech team has amended the META tag accordingly, and that takes some times to correct. So, stay tune!

Caritech at original and beginning stage has only very few features, so we put feedback corner under forum. But guess what? We'll consider having guest book for next upcoming version, where every members in Caritech can have their own guest book, and one main guest book page for the site!

Caritech is improving day by day in long, not over night. So be patient, and we can be better :)