[sqlite] select query problem in symbian c++

[rahul . makode]

i am executing this query to get UserNamePasswordHash and i am setting
value of variable       UserID


err = stmt.Prepare(db, _L("SELECT UserNamePasswordHash FROM User WHERE
UserID=:UserID"));

                //TInt err = stmt.Prepare(database, _L("SELECT BinaryField FROM 
Tbl1"));

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

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

                        TInt size = stmt. ColumnSize(columnIndex);

                        HBufC8* buf = HBufC8::NewL(size);

                        TPtr8 bufferPtr1 (buf->Des());


                        err = stmt.ColumnBinary(columnIndex,bufferPtr1);

                        
iChitDemoAppUi->BinaryToString(bufferPtr1,usernamePasswordHash);

                        iChitDemoAppUi->Log(bufferPtr1);

                        delete buf;

                        }

query is executing properly but i am not getting data in buf
if i used hardcoded then it is executed properly in symbian


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