Replace the table name in query with variabale value
-
Thank you for your response :)
But, I'm still getting an error. I apologize, I'm not familiar with the syntax of python.table_name = '1.0' queryStrTemplate = 'SELECT NO_EXERCISE from {}' c.execute(queryStrTemplate.format(table_name)) c.execute('select NO_EXERCISE from {} \'.format(table_name) where SCHED_ID = ?', (1,)) row = c.fetchone() print(row[0])
@dvlpr-bernard said in Replace the table name in query with variabale value:
I'm not familiar with the syntax of python
Then you should learn it.
And please take a closer look at your execute() line it is really broken...c.execute('select NO_EXERCISE from {} where SCHED_ID = {}'.format(table_name, 1)) -
Thank you for your response :)
But, I'm still getting an error. I apologize, I'm not familiar with the syntax of python.table_name = '1.0' queryStrTemplate = 'SELECT NO_EXERCISE from {}' c.execute(queryStrTemplate.format(table_name)) c.execute('select NO_EXERCISE from {} \'.format(table_name) where SCHED_ID = ?', (1,)) row = c.fetchone() print(row[0])@dvlpr-bernard said in Replace the table name in query with variabale value:
But, I'm still getting an error. I apologize, I'm not familiar with the syntax of python.
We (I) do not want to be rude or mean to you. But if you are not familiar with Python or its syntax, why are you programming in it, how do you expect to get anywhere? You are going to get this kind of issue on every line you try to write. Which is also why I said you might want to use a general Python programming forum, since this sort of thing simply has nothing to do with Qt, but as you please.
-
This post is deleted!
-
I didn't meant to offend you guys. I was working on a PyQt app it is just a small school project. Python is the required language, what do I mean is I don't have time to dig deeper on learning other python stuff. I learned the fundamentals and I also interested on the things that I needed. But in this case, I was hyped because I was about to finish my project. The only thing left is replacing the table name in query with variable value and then my project will get finished. That's maybe the reason why I was hyped to get the correct syntax for that.
I apologize if I said something mean, English is not my first language. I hope you understand. Thank you for both of you :)
-
Thank you for your response :)
But, I'm still getting an error. I apologize, I'm not familiar with the syntax of python.table_name = '1.0' queryStrTemplate = 'SELECT NO_EXERCISE from {}' c.execute(queryStrTemplate.format(table_name)) c.execute('select NO_EXERCISE from {} \'.format(table_name) where SCHED_ID = ?', (1,)) row = c.fetchone() print(row[0])@dvlpr-bernard
I finally noticed the problem. It must betable_name = "\'1.0\'"not
table_name = '1.0'Thank you guys for your help :)
-
@dvlpr-bernard
I finally noticed the problem. It must betable_name = "\'1.0\'"not
table_name = '1.0'Thank you guys for your help :)
@dvlpr-bernard
One thing I meant to ask: what editor do you use when writing your Python code? If it's an IDE like PyCharm or VSCode it will helpfully show you when code is syntactically wrong, offer you methods/parameters to choose from etc.; if you are not using an editor with Python syntax you are missing out. -
@Denni-0 Thank you I will take note of that
-
@dvlpr-bernard
One thing I meant to ask: what editor do you use when writing your Python code? If it's an IDE like PyCharm or VSCode it will helpfully show you when code is syntactically wrong, offer you methods/parameters to choose from etc.; if you are not using an editor with Python syntax you are missing out. -
@JonB I actually using IDLE hahaha. I do have PyCharm but I got used to the IDLE environment. Prob would gonna try them.
-
@dvlpr-bernard
I imagine IDLE, being a Python editor, shows you errors, no? The point was, in your earlier erroneous code, I would have expected your editor to be showing you those lines were incorrect.@JonB HAHAHAHAHAH it works fine to me, IDLE also shows where the error is, but not as powerful as other IDE's can do. It would have been a little bit easier if I use other IDE's like PyCharm. But just like I what I have said I had so much fun and excitement using IDLE. Next time I would prob use PyCharm to put myself at ease.
-
@Denni-0 I'm sorry sir. I felt bad about the replies(they were indirectly telling me that I don't belong or I shouldn't be here), so I decided to delete it. Forget about it, I appreciate your help sir :).
@dvlpr-bernard said in Replace the table name in query with variabale value:
I felt bad about the replies(they were indirectly telling me that I don't belong or I shouldn't be here)
Hi @dvlpr-bernard, the Qt Forum is a place which welcomes everybody who wants to learn how to write software using Qt. If anyone says that you shouldn't be here, please let the Moderators know (click the triple-dots at the bottom-right of the post, and select "Flag this post for moderation") because we want to build a helpful and professional environment.
Anyway, I reviewed the replies in your other thread (Moderators can see deleted posts). I agree with @Denni-0 -- None of the replies were (directly or indirectly) saying that you don't belong here. Instead, they were saying that you should redesign your SQL database schema in order to solve your problem.
@Denni-0 said in Replace the table name in query with variabale value:
I would have contacted you directly but cannot figure out how to do that on this forum or even if its possible
You can send a Private Message from the user's profile page. Click the triple-dots and select "Start a new chat with <USERNAME>".
