Re: [Tutor] Database topic now fixed

2006-05-15 Thread Alan Gauld
>Does that mean you will soon fix the tutor.tgz :-) > Thanks for all the hard work you put into this. I updated the PDF. zip and tgz files at the same time I uploaded the fixed database topic, but before I made the additional fixes Bob suggested Alan G.

Re: [Tutor] Database topic now fixed

2006-05-13 Thread Alan Gauld
> Some observations: These have now all been addressed as previously discussed. I've also added a section at the end covering the use of execute() to insert parameters rather than relying on format strings since the latter can be a security risk. Hopefully its now complete! :-) Alan Gauld Autho

Re: [Tutor] Database topic now fixed

2006-05-13 Thread Alan Gauld
Thanks Bob, Feedback is always appreciated, its how the tutor improves. > 1 - people familiar with other databases might be puzzled by the > lack of column datatypes. I'd mention that sqlite allows but does > not require types at the first introduction of CREATE TABLE,. Fair point, although by

Re: [Tutor] Database topic now fixed

2006-05-13 Thread Bob Gailer
Alan Gauld wrote: > The mistakes in my databae topic have now been rectified. > I have no idea how I managed to post the file without testing > that section of code. And unfortunately it's one of the areas > where SqlLite SQL syntax varies from the Oracle syntax that > I'm most familiar with. Bu