[sqlite] sqlite db5 error for symbian

[Manasi Save]

                 err = stmt.Prepare(db, _L("SELECT Col1 FROM tbl1 WHERE col2 = 
:var"));

                TInt paramIndex = stmt.ParameterIndex(_L(":var"));

                err = stmt.BindInt(paramIndex,user_id);

                id.AppendNum(user_id);

                iChitDemoAppUi->Log(id);

                TInt columnIndex = stmt.ColumnIndex(_L("UserNamePasswordHash"));

                TBuf8<100> data;

                while((err = stmt.Next()) == KSqlAtRow)
                        {

                                        //data.Zero();

                                        data= stmt.ColumnBinaryL(columnIndex);

                                        iChitDemoAppUi->Log(data);

                                        RDebug::Print(_L("val=%d\n"), data);
//
                        }

it is not printing value in Log and debug also in symbian c++ for v9.1.

I want to get the value of col1 where col2 = bind variable value.

Can anyone provide any input on what i am missing in this.

Thanks in advance.
Regards,
Manasi

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users