--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/applayerpluginsandutils/uripermissionservices/server/src/sqldbtransaction.cpp	Tue Feb 02 01:09:52 2010 +0200
@@ -0,0 +1,102 @@
+// Copyright (c) 2007-2009 Nokia Corporation and/or its subsidiary(-ies).
+// All rights reserved.
+// This component and the accompanying materials are made available
+// under the terms of "Eclipse Public License v1.0"
+// which accompanies this distribution, and is available
+// at the URL "http://www.eclipse.org/legal/epl-v10.html".
+//
+// Initial Contributors:
+// Nokia Corporation - initial contribution.
+//
+// Contributors:
+//
+// Description:
+//
+
+#include "sqldbtransaction.h"
+
+/**
+Stanadard factory construction method
+*/
+MDBTransaction* CSqlDbTransaction::NewL ( RSqlDatabase& aDb, const TDesC8& aQueryStmt )
+	{
+	CSqlDbTransaction* self = new ( ELeave )CSqlDbTransaction ();
+	CleanupStack::PushL ( self );
+	self->ConstructL ( aDb, aQueryStmt );
+	CleanupStack::Pop (); // self
+	
+	return self;
+	}
+	
+CSqlDbTransaction::~CSqlDbTransaction ()
+	{
+	iStatement.Close ();	
+	}
+
+CSqlDbTransaction::CSqlDbTransaction ( )
+	{
+		
+	}
+
+void CSqlDbTransaction::ConstructL ( RSqlDatabase& aDb, const TDesC8& aQueryStmt )
+	{
+	iStatement.PrepareL ( aDb, aQueryStmt );
+	}
+
+/**
+Binds the text value with the SQL statement
+*/	
+void CSqlDbTransaction::BindTextL ( TInt aParamPos, const TDesC8& aParamValue )
+	{
+	User::LeaveIfError ( iStatement.BindBinary ( aParamPos, aParamValue ) );			
+	}
+
+/**
+Binds the int value with the SQL statement
+*/	
+void CSqlDbTransaction::BindIntL ( TInt aParamPos, TInt aParamValue )
+	{
+	User::LeaveIfError ( iStatement.BindInt ( aParamPos, aParamValue ) );
+	}
+
+/**
+Executes the SQL statement. Leaves incase of an error. Otherwise returns with
+the number of records changed during a INSERT, UPDATE or DELETE operation
+*/
+TInt CSqlDbTransaction::ExecuteL ()
+	{
+	TInt ret = iStatement.Exec ();
+	User::LeaveIfError ( ret );
+	return ret;
+	}
+
+/**
+Returns the column text value from the result set, given the field position
+*/	
+TPtrC8 CSqlDbTransaction::ColumnTextL ( TInt aFieldPos )
+	{
+	return iStatement.ColumnBinaryL ( aFieldPos );
+	}
+
+/**
+Returns the column integer value from the result set, given the field position
+*/
+TInt CSqlDbTransaction::ColumnIntL ( TInt aFieldPos )
+	{
+	return iStatement.ColumnInt ( aFieldPos );
+	}
+
+/**
+Moves to the first or next record. Returns ETrue if there is a record otherwise returns
+EFalse
+*/
+TBool CSqlDbTransaction::Next ()
+	{
+	return ( iStatement.Next() == KSqlAtRow );	
+	}
+
+void CSqlDbTransaction::Release ()
+	{
+	delete this;	
+	}
+