Alan Gauld 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 put in some magic
> charactrs the
>> 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
On 27 January 2013 18:21, Alan Gauld 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 put in some
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
Hello,
I am very new to python. Wrote a small program to use on my android phone using
pickle/shelve to access data.
That worked fine but i realised it would be better to use sqlite as a database
to more easily modify the data.
I havent got a clue about sqlite, have a book but cant find the ans
Roger Shaw wrote:
>
> Hello,
> I am very new to python.
>
> Wrote a small program to use on my android phone using pickle/shelve to
> access data.
>
> That worked fine but i realised it would be better to use sqlite as a
> database to more easily modify the data.
>
> I havent got a clue about
Hello,
I am very new to python.
Wrote a small program to use on my android phone
using pickle/shelve to access data.
That worked fine but i realised it would be better to use sqlite as a
database to more easily modify the data.
I havent got a clue about sqlite, have a book but cant find
