Re: Using query parameters subtitution outside of execute()

2014-03-28 Thread Peter Otten
Daniele Forghieri wrote: > Il 28/03/2014 10:16, Peter Otten ha scritto: >> Daniele Forghieri wrote: >> >>> Hi to all. I'm using sqlite3 with python 2.7 on windows. >>> >>> I use the query substitution parameters in my query but I need to pass >>> part of the query to a function, something like (it

Re: Using query parameters subtitution outside of execute()

2014-03-28 Thread Neil Cerutti
On 2014-03-28, Daniele Forghieri wrote: > The worse is the contrary, when I must use C and I think 'Here > I use a dictionary, at the end convert it in a list that I sort > with that key ...' only to realize that I don't have dictionary > and the list I can use are very less manageable that the on

Re: Using query parameters subtitution outside of execute()

2014-03-28 Thread Daniele Forghieri
Il 28/03/2014 14:53, Peter Otten ha scritto: Daniele Forghieri wrote: Il 28/03/2014 10:16, Peter Otten ha scritto: Daniele Forghieri wrote: Hi to all. I'm using sqlite3 with python 2.7 on windows. I use the query substitution parameters in my query but I need to pass part of the query to a

Re: Using query parameters subtitution outside of execute()

2014-03-28 Thread Daniele Forghieri
Il 28/03/2014 10:16, Peter Otten ha scritto: Daniele Forghieri wrote: Hi to all. I'm using sqlite3 with python 2.7 on windows. I use the query substitution parameters in my query but I need to pass part of the query to a function, something like (it's not the real examples, just to clarify the

Re: Using query parameters subtitution outside of execute()

2014-03-28 Thread Peter Otten
Daniele Forghieri wrote: > Hi to all. I'm using sqlite3 with python 2.7 on windows. > > I use the query substitution parameters in my query but I need to pass > part of the query to a function, something like (it's not the real > examples, just to clarify the question): > > def loadAll(cursor, i