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
------------------------------------------------------------------------------
Got visibility?
Most devs has no idea what their production app looks like.
Find out how fast your code is with AppDynamics Lite.
http://ad.doubleclick.net/clk;262219671;13503038;y?
http://info.appdynamics.com/FreeJavaPerformanceDownload.html
_______________________________________________
Tntnet-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tntnet-general
