Hi Ratin,
Going to take a stab at this one.
Have you looked into INFORMATION_SCHEMA.COLUMNS for your query?
Might be where you want to look for what you are trying.
Sorry can't help more.
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
> On Aug 18, 2016, at 1:27 PM, Ratin
Hi Karl, Thanks a lot for your response, I think INFORMATION_SCHEMA is not
available for sqlite database. I had to built up the whole query with php
using PRAGMA table_info(tablename), looking at the pk entry, when its 1,
get the column name, and then update the sql statement based on that. A bit
I'm writing the generic get that works on different tables having different
primary keys but the argument of get is always the primary key , i.e. get
request is -
get (column name, value)
the value is always the primary key value.
It looks like it would be a pretty standard method but I cant
