sqlite error?

[John Salerno]

Am I using the ? placeholder wrong in this example?


t = ('hi', 'bye')

self.connection .execute("INSER T INTO Personal (firstName, lastName)
VALUES ?", t)



Traceback (most recent call last):
File "C:\Python25\my scripts\labdb\d bapp.py", line 93, in OnSaveRecord
self.save_to_da tabase(textfiel d_values)
File "C:\Python25\my scripts\labdb\d bapp.py", line 97, in save_to_databas e
self.connection .execute("INSER T INTO Personal (firstName, lastName)
VALUES ?", t)
sqlite3.Operati onalError: near "?": syntax error

[BartlebyScrivener]

Re: sqlite error?

>self.connectio n.execute("INSE RT INTO Personal (firstName, lastName)
VALUES ?", t)

John,

I'm no expert, but try

self.connection .execute("INSER T INTO Personal (firstName, lastName)
VALUES ?, ?", t)

[thunderfoot@gmail.com]

Re: sqlite error?


John Salerno wrote:

Am I using the ? placeholder wrong in this example?
>
>
t = ('hi', 'bye')
>
self.connection .execute("INSER T INTO Personal (firstName, lastName)
VALUES ?", t)
>
>
>
Traceback (most recent call last):
File "C:\Python25\my scripts\labdb\d bapp.py", line 93, in OnSaveRecord
self.save_to_da tabase(textfiel d_values)
File "C:\Python25\my scripts\labdb\d bapp.py", line 97, in save_to_databas e
self.connection .execute("INSER T INTO Personal (firstName, lastName)
VALUES ?", t)
sqlite3.Operati onalError: near "?": syntax error

I believe you're missing the parens around your VALUES to insert. Also,
you need 1 placeholder per argument inserted, not just one for the
entire argument list. Try:

self.connection .execute("INSER T INTO Personal (firstName, lastName)
VALUES (?, ?)", t)

HTH

[John Salerno]

Re: sqlite error?

thunderfoot@gma il.com wrote:

John Salerno wrote:

>Am I using the ? placeholder wrong in this example?
>>
>>
>t = ('hi', 'bye')
>>
>self.connectio n.execute("INSE RT INTO Personal (firstName, lastName)
>VALUES ?", t)
>>
>>
>>
>Traceback (most recent call last):
> File "C:\Python25\my scripts\labdb\d bapp.py", line 93, in OnSaveRecord
> self.save_to_da tabase(textfiel d_values)
> File "C:\Python25\my scripts\labdb\d bapp.py", line 97, in save_to_databas e
> self.connection .execute("INSER T INTO Personal (firstName, lastName)
>VALUES ?", t)
>sqlite3.Operat ionalError: near "?": syntax error

>
I believe you're missing the parens around your VALUES to insert. Also,
you need 1 placeholder per argument inserted, not just one for the
entire argument list. Try:
>
self.connection .execute("INSER T INTO Personal (firstName, lastName)
VALUES (?, ?)", t)
>
HTH
>

Thanks guys. I'll try this. I thought the ? stood for the whole tuple.

[Frank Millman]

Re: sqlite error?


John Salerno wrote:

Am I using the ? placeholder wrong in this example?
>
>
t = ('hi', 'bye')
>
self.connection .execute("INSER T INTO Personal (firstName, lastName)
VALUES ?", t)
>

[snip]

>
Thanks guys. I'll try this. I thought the ? stood for the whole tuple.

Definitely not. You could have a sql command like this -

cur.execute("UP DATE table SET col1 = ?, col2 = ? WHERE col3 = ? AND
col4 = ?",(1,2,3,4) )

The parameters could be scattered throughout the command. Therefore the
substitution is one-for-one from left to right using the values in the
tuple.

Frank Millman

[John Salerno]

Re: sqlite error?

Frank Millman wrote:

Definitely not. You could have a sql command like this -
>
cur.execute("UP DATE table SET col1 = ?, col2 = ? WHERE col3 = ? AND
col4 = ?",(1,2,3,4) )
>
The parameters could be scattered throughout the command. Therefore the
substitution is one-for-one from left to right using the values in the
tuple.
>

Thanks! The example I was looking at in the docs didn't use parentheses,
but I also didn't connect that with the fact that it was only using a
one-tuple! :)