Re: [sqlite] Named parameters and spaces.

2012-01-12 Thread David Garfield
The named parameters need not match the column names, and the column names are probably what you want to match the CSV file. As such, you could make P1 throught P25 to be the named parameters for your 25 columns, and insert them into columns with the real name. The named parameters are there only

Re: [sqlite] Named parameters and spaces.

2012-01-11 Thread Steven Michalske
On Tue, Jan 10, 2012 at 4:11 PM, Simon Slavin wrote: > > On 10 Jan 2012, at 11:57pm, Steven Michalske wrote: > >> Some day they might have a field that is named with the underscore as >> a second column; not saying it makes sense.  We find all kinds on the >> internet :-) > > Well some day they mi

Re: [sqlite] Named parameters and spaces.

2012-01-10 Thread Steven Michalske
On Jan 10, 2012, at 5:02 PM, Darren Duncan wrote: > Steven Michalske wrote: >> On Tue, Jan 10, 2012 at 3:19 PM, Darren Duncan >> wrote: >>> Steven Michalske wrote: I would like to use the :nnn named parameters but have spaces in the named parameters. It seems that ":nnn nnn

Re: [sqlite] Named parameters and spaces.

2012-01-10 Thread Darren Duncan
Steven Michalske wrote: On Tue, Jan 10, 2012 at 3:19 PM, Darren Duncan wrote: Steven Michalske wrote: I would like to use the :nnn named parameters but have spaces in the named parameters. It seems that ":nnn nnn", :"nn nn", or :nn\ nn are all not recognized. Is there a way to use spaces in

Re: [sqlite] Named parameters and spaces.

2012-01-10 Thread Simon Slavin
On 10 Jan 2012, at 11:57pm, Steven Michalske wrote: > Some day they might have a field that is named with the underscore as > a second column; not saying it makes sense. We find all kinds on the > internet :-) Well some day they might have a field that is named with a space, too. There's noth

Re: [sqlite] Named parameters and spaces.

2012-01-10 Thread Steven Michalske
On Tue, Jan 10, 2012 at 2:37 PM, Pavel Ivanov wrote: >> Is there a way to use spaces in named parameters? > > No. Quick fix would be to replace all your spaces with underscores. > > > Pavel Understood, that what I did to cope, but that involves data manipulation of outside data. A feature that I

Re: [sqlite] Named parameters and spaces.

2012-01-10 Thread Steven Michalske
On Tue, Jan 10, 2012 at 3:19 PM, Darren Duncan wrote: > Steven Michalske wrote: >> >> I would like to use the :nnn named parameters but have spaces in the >> named parameters. >> >> It seems that ":nnn nnn", :"nn nn", or :nn\ nn are all not recognized. >> >> Is there a way to use spaces in named p

Re: [sqlite] Named parameters and spaces.

2012-01-10 Thread Darren Duncan
Steven Michalske wrote: I would like to use the :nnn named parameters but have spaces in the named parameters. It seems that ":nnn nnn", :"nn nn", or :nn\ nn are all not recognized. Is there a way to use spaces in named parameters? I would expect : to be the correct format for a named paramet

Re: [sqlite] Named parameters and spaces.

2012-01-10 Thread Pavel Ivanov
> Is there a way to use spaces in named parameters? No. Quick fix would be to replace all your spaces with underscores. Pavel On Tue, Jan 10, 2012 at 5:31 PM, Steven Michalske wrote: > Hello, > > I would like to use the :nnn named parameters but have spaces in the > named parameters. > > It s