I hope that the poll is made in an understandable way. But, i cannot add any parameters that actually work 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
𝓂𝒾𝓂𝒾𓆙 (@itsmia_bb) • Threads, Say more
Just like the values are separated with commas and surrounded in parentheses, so too must the placeholders
Otherwise, sql won't know how to interpret them and match them up.
placeholder := "VALUES (" for i, c := range columns { if i == 0 { *query += c placeholder += "?" } else { *query += ", "+c placeholder += ", ?" } } placeholder += ")" *query += ") " + placeholder } // convert []string to []interface{} func string2interface(s []string) []interface{} { i := make([]interface{}, len(s)) for k, v := range s { I'm looping and with each loop i manipulate data and then save it to different csv file Now i'm trying to do the same with sqlite I have many tables but for sake of simplicity, lets say i have 3 tables
In postgres, the value placeholder is $#, which one is recommend when the value is the same, reusing the value placeholder or not How to use placeholders in postgresql In sql systems other than postgres, such as mysql for instance, prepared statements can use question marks as a placeholder for data in prepared statements I am not sure how to create placeholders in postgres.
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. but it doesn't show up in the getupdates api endpoint response Thanks for your help in advance. Why are the names john/jane doe used as placeholder names instead of any other name?
