Re: [GENERAL] Syncing Data of data type BLOB into Postgres- Bytea

2016-11-15 Thread Adrian Klaver
On 11/15/2016 05:55 PM, John DeSoi wrote: On Nov 10, 2016, at 12:55 AM, Cynthia Hombakazi Ngejane wrote: I have two databases SQLlite and Postgres, SQLite is my local database in it I am saving fingerprint templates that get capture on site (offline) and my

Re: [GENERAL] Syncing Data of data type BLOB into Postgres- Bytea

2016-11-15 Thread John DeSoi
> On Nov 10, 2016, at 12:55 AM, Cynthia Hombakazi Ngejane > wrote: > > I have two databases SQLlite and Postgres, SQLite is my local database in it > I am saving fingerprint templates that get capture on site (offline) and my > column is of type BLOB. Now I want

Re: [GENERAL] Syncing Data of data type BLOB into Postgres- Bytea

2016-11-14 Thread Adrian Klaver
On 11/13/2016 11:40 PM, Cynthia Hombakazi Ngejane wrote: Please reply to list also. Ccing list. 9.3 it just says syntax error near ( Can you show the actual complete error? I have a variable QByteArray that stores the fingerprint data, then: I am using QString Query = "insert into

Re: [GENERAL] Syncing Data of data type BLOB into Postgres- Bytea

2016-11-14 Thread Adrian Klaver
On 11/13/2016 11:40 PM, Cynthia Hombakazi Ngejane wrote: 9.3 it just says syntax error near ( I have a variable QByteArray that stores the fingerprint data, then: I am using QString Query = "insert into tableName(colName) values (:valName)"; prepare the query; then query.bindValue; lastly

Re: [GENERAL] Syncing Data of data type BLOB into Postgres- Bytea

2016-11-10 Thread Adrian Klaver
On 11/09/2016 11:35 PM, Cynthia Hombakazi Ngejane wrote: Hello, I have two databases SQLlite and Postgres, SQLite is my local database in it I am saving fingerprint templates that get capture onsite (i.e offline) and my column is of type BLOB. Now I want to sync these templates into Postgres

[GENERAL] Syncing Data of data type BLOB into Postgres- Bytea

2016-11-09 Thread Cynthia Hombakazi Ngejane
Hello, I have two databases SQLlite and Postgres, SQLite is my local database in it I am saving fingerprint templates that get capture onsite (i.e offline) and my column is of type BLOB. Now I want to sync these templates into Postgres (to the server), so I created a column of type bytea but