python sql query stating 'not enough input arguments'

Question

In order to select the price of an item I have the following code:

product = ['user_input']
item(product)
day = int(self.ui.spinBox.value())

query = 'select price from (select * from %s order by count limit %d) order by count as limit desc'

sql = query % item % day

In response I get the error that there aren't enough input arguments.

Samuel · Accepted Answer · 2016-05-15 11:15:54Z

1

you have to specify multiple arguments as tuple, eg:

sql = query % (item, day)

answered May 15, 2016 at 11:15

Samuel

3,8166 gold badges40 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

python sql query stating 'not enough input arguments'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related