Re: curious paramstyle qmark behavior

2006-10-21 Thread Jon Clements
BartlebyScrivener wrote: > Jon Clements wrote: > > > if your load on the data-entry/browsing side isn't too heavy, you can > > use the 'development server' instead of installing a full-blown server > > such as Apache (I'm not sure if IIS is supported). > > What's IIS? It's Internet Information S

Re: curious paramstyle qmark behavior

2006-10-21 Thread BartlebyScrivener
Jon Clements wrote: > However, only you know what > you really want to do, so it's up to you to evaluate which RDMS to go > for! That assumes a lot :) My needs are simple. I'm exploring. My only real db is a collection of 5,000 quotations, book passages etc. Flat file would probably even do it.

Re: curious paramstyle qmark behavior

2006-10-21 Thread Jon Clements
BartlebyScrivener wrote: > Thanks, Jon. > > I'm moving from Access to MySQL. I can query all I want using Python, > but so far haven't found a nifty set of forms (ala Access) for easying > entering of data into MySQL. My Python is still amateur level and I'm > not ready for Tkinkter or gui progr

Re: curious paramstyle qmark behavior

2006-10-20 Thread BartlebyScrivener
Thanks, Jon. I'm moving from Access to MySQL. I can query all I want using Python, but so far haven't found a nifty set of forms (ala Access) for easying entering of data into MySQL. My Python is still amateur level and I'm not ready for Tkinkter or gui programming yet. rd -- Jon Cleme

Re: curious paramstyle qmark behavior

2006-10-20 Thread Diez B. Roggisch
BartlebyScrivener schrieb: > With > > aColumn = "Topics.Topic1"' > > The first statement "works" in the sense that it finds a number of > matching rows. > > c.execute ("SELECT Author, Quote, ID, Topics.Topic1, Topic2 FROM > QUOTES7 WHERE " + aColumn + " LIKE ?", ("%" + sys.argv[1] + "%",)) > >

Re: curious paramstyle qmark behavior

2006-10-20 Thread Jean-Paul Calderone
On 20 Oct 2006 13:06:58 -0700, BartlebyScrivener <[EMAIL PROTECTED]> wrote: >With > >aColumn = "Topics.Topic1"' > >The first statement "works" in the sense that it finds a number of >matching rows. > >c.execute ("SELECT Author, Quote, ID, Topics.Topic1, Topic2 FROM >QUOTES7 WHERE " + aColumn + " LI

Re: curious paramstyle qmark behavior

2006-10-20 Thread Jon Clements
BartlebyScrivener wrote: > With > > aColumn = "Topics.Topic1"' > > The first statement "works" in the sense that it finds a number of > matching rows. > > c.execute ("SELECT Author, Quote, ID, Topics.Topic1, Topic2 FROM > QUOTES7 WHERE " + aColumn + " LIKE ?", ("%" + sys.argv[1] + "%",)) > > I've

curious paramstyle qmark behavior

2006-10-20 Thread BartlebyScrivener
With aColumn = "Topics.Topic1"' The first statement "works" in the sense that it finds a number of matching rows. c.execute ("SELECT Author, Quote, ID, Topics.Topic1, Topic2 FROM QUOTES7 WHERE " + aColumn + " LIKE ?", ("%" + sys.argv[1] + "%",)) I've tried about 20 different variations on this