steve mtangoo wrote: > No problem. > Now only If I could get the ID of the limits (that is ID for Book 1 Chapter > 1 and Verse 1 for example) and the end limit, my problem will be solved!
Well, that is simple... SELECT ID FROM Bible WHERE Book = 1 AND Chapter = 1 AND Verse = 1 same for the ending verse. In fact, as you possibly noted, if the ID is sequentially assigned to each verse (assuming, the verses have been inserted in the desired order), you could just find out the IDs of the lower and higher verses, and then use those to find all the verses in between. > Thanks for helping! > > On Mon, Dec 13, 2010 at 6:13 PM, Puneet Kishor<[email protected]> wrote: > >> Yes, of course, you are correct. Goes on to show that mapping what one >> thinks in the mind (a logical query) to SQL (a set query) can be nastily >> difficult. >> >> Thanks for the correction. >> >> -- >> Puneet Kishor http://punkish.org >> Carbon Model http://carbonmodel.org >> Charter Member, Open Source Geospatial Foundation http://www.osgeo.org >> Science Fellow >> http://creativecommons.org/about/people/fellows#puneetkishor >> Nelson Institute, UW-Madison http://www.nelson.wisc.edu >> --------------------------------------------------------------------------- >> Assertions are politics; backing up assertions with evidence is science >> =========================================================================== >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Puneet Kishor http://punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Fellow http://creativecommons.org/about/people/fellows#puneetkishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu --------------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science =========================================================================== _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
