Ah... sorry, I forgot to reply on my first message. It was my fault. The
database was deleted in the meantime but was still open in firefox. So,
firefox had the contents still in its memory.
It's working quite fine now :)
Thanks
Am 29.09.2012 20:12, schrieb Tommi Mäkitalo:
> 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
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://ad.doubleclick.net/clk;258768047;13503038;j?
http://info.appdynamics.com/FreeJavaPerformanceDownload.html
_______________________________________________
Tntnet-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tntnet-general
