> Actually I doubt it can - since without the column name it can't create the
> prepared statement byte code, right?
Right. It can't be done.
>
> Is it possible for a bind variable to be a column name? I'd like to make a
> query which is:
>
> select <column_name> from MyTable;
>
> and I'd like the column_name to be a bind variable. This doesn't work using
> the straight sqlite3_bind_text() call on the statement "select ? from
> MyTable;", which treats the column name as text and not part of the compiled
> statement.
>
> -Dave
>
>
____________________________________________________
Sell on Yahoo! Auctions no fees. Bid on great items.
http://auctions.yahoo.com/