All pastes #192582 Raw Edit

Unnamed

public text v1 · immutable
·published 2006-10-06 01:49 UTC
rendered paste body
getSettingValue(PGresult *res, char settingname)
{
	int setting_value_row;
	int setting_value;
	char field_name;
	char tmp_setting_name;
	int nFields;
	int i;
	int j;

	nFields = PQnfields(res);
	
	for (i = 0; i < nFields; i++)
	{
		field_name = PQfname(res, i);
		if(field_name == "setting_name")
		{
			for (j = 0; j < nFields; j++)
			{
				tmp_setting_name = PQgetvalue(res, i, j);
				if(tmp_setting_name == settingname)
				{
					// We found which row our setting value is, end the loop.
					fprintf("Setting name found: '%s'\n", tmp_setting_name);
					setting_value_row = j;
					j=nFields;
					i=nFields;
				}
			}
			
		}
	}
	
	for(i = 0; i < nFields; i++)
	{
		field_name = PQfname(res, i);
		if(field_name == "setting_value")
		{
			// We have found our setting value end the loop
			setting_value = PQgetvalue(res, i,setting_value_row);
			i = nFields;
		}
	}
	
	return setting_value;
}