All pastes #176846 Raw Edit

Macca

public c v1 · immutable
#176846 ·published 2006-09-20 00:12 UTC
rendered paste body
	PGresult *res;	const char* vals[] = { album.c_str() };	res = PQexecParams(			conn,			"select album_id from album where name = $1", 			1,			NULL,			vals,			NULL,			NULL,			1);		if (PQntuples(res) > 0)	{		int fn = PQfnumber(res, "album_id");		int ret = string_to_int(PQgetvalue(res, 0, fn));		printf("ret: %d\n", PQgetvalue(res, 0, fn));		PQclear(res);		return ret;	}