Re: [Tutor] sqlite search

2013-01-27 Thread Alan Gauld
On 18/01/13 18:11, Roger wrote: At the moment this works to search for everything beginning with A sql = SELECT * FROM plants WHERE genus LIKE 'A%'; cursor.execute(sql); SQLlite supports a form of format string where you put in some magic charactrs then provide arguments which SQLLite will

Re: [Tutor] sqlite search

2013-01-27 Thread Oscar Benjamin
On 27 January 2013 18:21, Alan Gauld alan.ga...@btinternet.com wrote: On 18/01/13 18:11, Roger wrote: At the moment this works to search for everything beginning with A sql = SELECT * FROM plants WHERE genus LIKE 'A%'; cursor.execute(sql); SQLlite supports a form of format string where you

Re: [Tutor] sqlite search

2013-01-27 Thread ALAN GAULD
file:///home/alang/Documents/HomePage/tutor/tutdbms.htm You might have better luck using this link: http://www.alan-g.me.uk/tutor/tutdbms.htm Oops, thanks for spotting that!  I keep two copies of the site open in separate browser tabs and mistakenly used the local  file version when

[Tutor] using ranges with argparse()

2013-01-27 Thread Kurt Lieber
Hi -- brand new to python, but trying to write a simple script that takes command line arguments. One of the arguments needs to test if a value is a) an integer and b) within a stated range. I currently have: parser.add_argument(-f, --floor, default=6000, help=floor is the minimum amount of

Re: [Tutor] HELP- Regarding working with python

2013-01-27 Thread Gayathri S
Hi all..! wanna know how to compile python script in python command line, and is there any need for setting path for python like JAVA? whats the difference between .py file and .pyc file? Thanks...! On Sat, Jan 19, 2013 at 8:54 AM, bob gailer