Category ""
ADVERTISING
Here is simple example, what I tried to do. I can't get f string to work in my case to use it as table name placeholder and I can't figure it out, what you are suggesting (I'm beginner and English is not my primary language):
I think I'm just going to give up on the nested query and simply run it as a separate query with its own handle. This will increase the work needed to complete the task, but I simply don't think this is going to work as is, possibly because the query is "hiding" inside the parenthesis.
I am not sure how to create placeholders in Postgres. I did some research - I found some posts on Stackoverflow and tutorials on Postgres that suggested I used "$1, $2" or use "%s, %l" as a placeholder. However, I keep getting errors. Does anyone have any suggestions?
The character after the at sign @ in the placeholder key is the transformation that is applied to the argument before inserting it into the placeholder (S for raw SQL, I for Identifiers and L for literals, among others).
It's a little bit confusing. You say the code you've provided in your post is intended to execute when a button is clicked, correct? This means that you've already replied to a slash command interaction which sent a response
Now I want to do the same thing via inline queries so that queries can be made through any chat. Have used the /setinline command and set a placeholder, which appears when I make the inline query, and type the command and param, but I don't know where it's going. The article on inline queries says "The query is sent to your bot in an update."
It only seems to be these two lines, as I have other queries with LIKE statements that work no issue. I have other commands with a "%s" placeholder in the middle, and a LIKE statement, and those work no issue. And as mentioned, they worked no problem when I was using sqlite, but since switching they don't.
In Postgres, the value placeholder is $#, which one is recommend when the value is the same, reusing the value placeholder or not? db.Exec("INSERT… Skip to main content Open menu Open navigation Go to Reddit Home
Technically, you have the right amount, but you're missing parentheses and commas, and it's broken up throughout your query which I suspect is confusing SQL. Just like the values are separated with commas and surrounded in parentheses, so too must the placeholders.
I was able to successfully insert the date in without issue using the same notation however I've inserted it directly into the query until I resolve the issue here. I've printed the bank_account to ensure it is picking up the correct value "1205" which it is. If I insert "1205" directly into the query then it runs.