[sqlite] Getting values by column name

[Jon Drnek]

Hello, 

 

I have a prepared statement  that looks like

 

char *getSql = "select * from transducer where id = ?";

rc = sqlite3_prepare_v2(transducerDb,getSql,-1,&preparedGet,NULL);

 

Is there a way that I can find out the number of a given column name in the
query?  

 

Instead of 

 

ts.key = sqlite3_column_int(preparedGet,0);

 

I'd like to do something like:

 

ts.key = sqlite3_column_int(preparedGet,get_column_id(preparedGet,"id"));

 

Is there a way to do that?

 

Thanks, 

 

Jon