Am 21.09.2012 21:19, schrieb Denis Loh:
> Hi,
>
> I have a sqlite table with the following structure:
>
> CREATE TABLE metadata(`@id` TEXT PRIMARY KEY,`@parentID` TEXT NOT
> NULL,`dc:title` TEXT NOT NULL,`upnp:class` TEXT NOT
> NULL,`@restricted` INTEGER NOT NULL,`dc:creator` TEXT,`dc:description`
> TEXT,`upnp:longDescription` TEXT,`dc:date` TEXT,`dc:language`
> TEXT,`upnp:channelNr` INTEGER,`upnp:channelName`
> TEXT,`upnp:scheduledStartTime` TEXT,`upnp:scheduledEndTime` TEXT)
>
> The following code shall retrieve the elements:
>
> tntdb::Statement select1 = mConnection.prepare("SELECT * FROM metadata WHERE
> `@parentID`='0'");
> for(tntdb::Statement::const_iterator it = select1.begin(); it !=
> select1.end(); ++it){
> tntdb::Row row = (*it);
> ...
> }
>
> My table has at least two entries with @parentID = 0. When I am using
> the firefox sqlite addon, I am able to select those lines. However,
> tntdb always returns no rows at all. If I am removing the WHERE clause,
> it returns only 1 row, though there are at least 3 rows in the table.
> What's wrong with my code?
>
> Thank you very much
>
> Denis
>
Sorry for the delay. I was offline for a week. But I'm back now.
You have strange column names. I did not know, that it is possible in
sqlite. But I don't see any problems here. I try to reproduce the problem.
Tommi
------------------------------------------------------------------------------
How fast is your code?
3 out of 4 devs don\\\'t know how their code performs in production.
Find out how slow your code is with AppDynamics Lite.
http://ad.doubleclick.net/clk;262219672;13503038;z?
http://info.appdynamics.com/FreeJavaPerformanceDownload.html
_______________________________________________
Tntnet-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tntnet-general
