On 8 May 2011, at 8:04pm, Igor Tandetnik wrote: > Sam Carleton <scarle...@gmail.com> wrote: >> I want to go the other way: I have the string name, I need the index of the >> column, same concept as >> sqlite3_bind_parameter_index(). > > You'll have to enumerate all columns, get the name of each, and compare it > with the desired name.
Out of interest, are you trying to analyse the results of a "SELECT *" ? Because since it's your query in the first place, you should know what columns you asked for. Generally, experienced programmers don't use "SELECT *" inside real applications, although it can be useful for utilities. The problem comes when you want to change your schema and find if difficult to find all the SELECTs you now have to modify. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users