help with SPI_<commands> Please

Hello experts.

I am writing my first function using the SPI_ interface.

I don't know how to access data that I just selected.

here's the outline:

my question is in the block comments

thanks a ton!!!!

mike



int32 allocate_address(int32 networkID)
{
char[255] query;

if (SPI_connect() < 0) {
return 0;
}

sprintf(query,
"Select addressID FROM networkaddress WHERE networkid = %i",
networkID);

if (SPI_exec(query, 1) < 0) {
return 0;
}

/* ############################################################ */
/* how do I access the data that I just selected ? */
/* ie I want to find the value of the each row in the select
/* ############################################################ */

SPI_finish();

return 1;
}
~