Am 23.02.2015 um 15:26 schrieb Julian Wiesener:
> Hi,
>
>> I have a column in a table (postgresql) which has type character
>> varying[]. Is it possible to read this column type with tntndb.
> the tntdb Interface for character varying[] is getString() you just need
> to know at which position in the results the desired String is, the
> equalent to your perl code is more or less:
>
> tntdb::Statement q = conn.prepare("SELECT foo, teams, bar FROM baz");
> // add bindings for where clause here
> tntdb::Result res q.select()
> for(tntdb::Result::const_iterator it = res.begin()
> it != res.end(); ++it)
> if(!it[1].isNull())
> WHATEVR( it[1].getString() );
>
> It's [1] because "teams" is the second SELECT parameter.
>
>
>
> Kind Regards,
> Julian
Hi,
As far as I understand the problem is a little different. You have
really a array of strings in one single field? That is not really
supported by tntdb since it is not standard SQL. I don't know if any
other database support such a feature.
I prefer not to use getString nor tntdb::Result. I suggest to do
something like:
tntdb::Statement q = conn.prepare("SELECT foo, teams, bar FROM baz");
// add bindings for where clause here
std::string teams;
for(tntdb::Statement::const_iterator it = q.begin(); it != q.end(); ++it)
{
if (it->get(teams))
WHATEVR(teams);
}
The iterator over tntdb::Statement do not read the whole result into
memory. It will use a cursor.
The get method is just a matter of taste. I prefer to use the get
method, so I do not need to remember whether to use getInt or getInteger
or getLong or whatever for numbers but just define my variable as needed.
Tommi
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
_______________________________________________
Tntnet-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tntnet-general
