Re: difference between statements

[email protected] wrote:
> Actually I agree with everything that you say.
If only my ex agreed. Ahem. :o)

> But I do tend to forget this from time to time, and I "load a stare 
> a", an old assembly language joke, it for awhile until I remember 
> that I forgot the commit. :-)

I hated it from the moment I put an executemany in a "BEGIN/END" pair
and after an evening battling with "SQL Logic error or missing database"
errors tracked it to a pysqlite bug that should have reported "Nested
transaction" error instead. I tend to use APSW now.

> as I look back on the offending code, it was using the
> mx.ODBC.Windows driver, not pysqlite, sorry for the confusion.

No probs. I've never used that driver, so hopefully I'll remember that 
error case if I do. ;)

>> SQL injection attacks, but you could argue that it only matters when 
> I agree completely, the scripts in question are internal scripts that

I have them too. I replace them as I see them though, for the sake of 
consistency if nothing else.

> Been doing this a long time, realized just recently that I have been 
> a web developer full or parttime for 10 years now, so none of this is
> new, even though I am relatively new to python, been coding in it 
> about 2.5 years. :-)

Time flies. I found an example of my first computer on eBay last night, 
a Nascom 2 I built from a kit in 1980. I used it to teach my self about 
digital stuff and to program in assembler. 4MHz CPU, 16k RAM, £400 and 
has no chance of running SQLite. I found/fixed a few bugs in Microsoft's 
ROM BASIC though. ;)

Martin