I hope that the poll is made in an understandable way. Cryptic error about placeholder and true/false, not using booleans as input though 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
Redd ^_−☆ (@hispudd1n) • Instagram photos and videos
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.
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. A subreddit dedicated to hacking and hackers
Constructive collaboration and learning about exploits, industry standards, grey and white hat hacking, new hardware and software hacking technology, sharing ideas and suggestions for small business and personal security. 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
Why are the names john/jane doe used as placeholder names instead of any other name? The only way to safely interpolate values into sql queries is to use the Do not use anything else (it’s dangerous, as discussed in other comments).
